action #33856
closedopenQA needle editor causes internal server error at lib/OpenQA/WebAPI/Controller/Step.pm
Description
When trying to create a needle from this screenshot http://pinky.arch.suse.de/tests/958#step/inkscape/17 I get an internal server error, other screenshots work fine
In the logs I get the following Output:
Mar 27 15:23:58 pinky openqa[2217]: Use of uninitialized value in join or string at
Mar 27 15:23:58 pinky openqa[2217]: /usr/lib/perl5/vendor_perl/5.18.2/SQL/Abstract.pm line 1482 (#1)
Mar 27 15:23:58 pinky openqa[2217]: (W uninitialized) An undefined value was used as if it were already
Mar 27 15:23:58 pinky openqa[2217]: defined. It was interpreted as a "" or a 0, but maybe it was a mistake.
Mar 27 15:23:58 pinky openqa[2217]: To suppress this warning assign a defined value to your variables.
Mar 27 15:23:58 pinky openqa[2217]:
Mar 27 15:23:58 pinky openqa[2217]: To help you figure out what was undefined, perl will try to tell you
Mar 27 15:23:58 pinky openqa[2217]: the name of the variable (if any) that was undefined. In some cases
Mar 27 15:23:58 pinky openqa[2217]: it cannot do this, so it also tells you what operation you used the
Mar 27 15:23:58 pinky openqa[2217]: undefined value in. Note, however, that perl optimizes your program
Mar 27 15:23:58 pinky openqa[2217]: anid the operation displayed in the warning may not necessarily appear
Mar 27 15:23:58 pinky openqa[2217]: literally in your program. For example, "that $foo" is usually
Mar 27 15:23:58 pinky openqa[2217]: optimized into "that " . $foo, and the warning will refer to the
Mar 27 15:23:58 pinky openqa[2217]: concatenation (.) operator, even though there is no . in
Mar 27 15:23:58 pinky openqa[2217]: your program.
Mar 27 15:23:58 pinky openqa[2217]:
Mar 27 15:23:58 pinky openqa[2217]: [error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: syntax error at or near "AND"
Mar 27 15:23:58 pinky openqa[2217]: LINE 1: ..._created, me.t_updated FROM needles me WHERE ( ( AND t_crea...
Mar 27 15:23:58 pinky openqa[2217]: ^ [for Statement "SELECT me.id, me.dir_id, me.filename, me.first_seen_module_id, me.last_seen_module_id, me.last_matched_module_id, me.file_present, me.tags, me.t_created, me.t_updated FROM needles me WHERE ( ( AND t_created > ? ) ) ORDER BY id DESC LIMIT ?" with ParamValues: 1='2018-03-27T07:19:42', 2='5'] at /usr/share/openqa/script/../lib/OpenQA/WebAPI/Controller/Step.pm line 326