System error
| error: | You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '% $display_set %>,r.id,r.rating FROM ratings AS r, movie_ratings AS mr, locati' at line 1 at /var/www/db/movies/autohandler line 180 |
||||||||||||||||||||||
| context: |
|
||||||||||||||||||||||
| code stack: |
/opt/perl-5.8.8/lib/5.8.8/Carp.pm:269 /opt/perl-5.8.8/lib/site_perl/5.8.8/x86_64-linux-thread-multi/HKMDB/Database.pm:402 /var/www/db/movies/autohandler:180 /var/www/db/autohandler:2 |
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '% $display_set %>,r.id,r.rating
FROM ratings AS r, movie_ratings AS mr, locati' at line 1 at /var/www/db/movies/autohandler line 180
Trace begun at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Exceptions.pm line 125
HTML::Mason::Exceptions::rethrow_exception('You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'% $display_set %>,r.id,r.rating^JFROM ratings AS r, movie_ratings AS mr, locati\' at line 1 at /var/www/db/movies/autohandler line 180^J') called at /opt/perl-5.8.8/lib/5.8.8/Carp.pm line 269
Carp::croak('You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near \'% $display_set %>,r.id,r.rating^JFROM ratings AS r, movie_ratings AS mr, locati\' at line 1') called at /opt/perl-5.8.8/lib/site_perl/5.8.8/x86_64-linux-thread-multi/HKMDB/Database.pm line 402
HKMDB::Database::select_rows('HKMDB::Database=HASH(0x1ea9380)', 'sql', 'SELECT l.id,l.location_<% $display_set %>,r.id,r.rating^JFROM ratings AS r, movie_ratings AS mr, locations AS l^JWHERE mr.movie_id = ?^J AND l.id = r.location_id^J AND mr.rating_id = r.id^J', 'bind', 'ARRAY(0x1e77b20)', 'hashref', 1) called at /var/www/db/movies/autohandler line 180
HTML::Mason::Commands::__ANON__('image_id', '<% $movie_image->{id} %>', 'display_set', '<% $display_set %>', 'id', '<% $id %>', 'display_set', '<% $display_set %>', 'image_id', '<% $movie_image->{id} %>', 'id', '<% $id %>') called at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x25a0310)', 'image_id', '<% $movie_image->{id} %>', 'display_set', '<% $display_set %>', 'id', '<% $id %>', 'display_set', '<% $display_set %>', 'image_id', '<% $movie_image->{id} %>', 'id', '<% $id %>') called at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Request.pm line 1302
eval {...} at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'image_id', '<% $movie_image->{id} %>', 'display_set', '<% $display_set %>', 'id', '<% $id %>', 'display_set', '<% $display_set %>', 'image_id', '<% $movie_image->{id} %>', 'id', '<% $id %>') called at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x1fa2ae0)', 'display_set', '<% $display_set %>', 'image_id', '<% $movie_image->{id} %>', 'id', '<% $id %>') called at /var/www/db/autohandler line 2
HTML::Mason::Commands::__ANON__('image_id', '<% $movie_image->{id} %>', 'display_set', '<% $display_set %>', 'id', '<% $id %>') called at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f6c2ef8afc0)', 'image_id', '<% $movie_image->{id} %>', 'display_set', '<% $display_set %>', 'id', '<% $id %>') called at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Request.pm line 1297
eval {...} at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'image_id', '<% $movie_image->{id} %>', 'display_set', '<% $display_set %>', 'id', '<% $id %>') called at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Request.pm line 481
eval {...} at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Request.pm line 481
eval {...} at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x1fa2ae0)') called at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x1fa2ae0)') called at /opt/perl-5.8.8/lib/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x1b4a580)', 'Apache2::RequestRec=SCALAR(0x25b1850)') called at (eval 30) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x25b1850)') called at -e line 0
eval {...} at -e line 0