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(0x20da3d0)', '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(0x20e6100)', 'hashref', 1) called at /var/www/db/movies/autohandler line 180
HTML::Mason::Commands::__ANON__('image_id', '<% $poster_image->{id} %>', 'display_set', '<% $display_set %>', 'id', '<% $id %>', 'display_set', '<% $display_set %>', 'image_id', '<% $poster_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(0x25ab500)', 'image_id', '<% $poster_image->{id} %>', 'display_set', '<% $display_set %>', 'id', '<% $id %>', 'display_set', '<% $display_set %>', 'image_id', '<% $poster_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', '<% $poster_image->{id} %>', 'display_set', '<% $display_set %>', 'id', '<% $id %>', 'display_set', '<% $display_set %>', 'image_id', '<% $poster_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(0x260a3a0)', 'display_set', '<% $display_set %>', 'image_id', '<% $poster_image->{id} %>', 'id', '<% $id %>') called at /var/www/db/autohandler line 2
HTML::Mason::Commands::__ANON__('image_id', '<% $poster_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(0x7f6c2ef8afd0)', 'image_id', '<% $poster_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', '<% $poster_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(0x260a3a0)') 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(0x260a3a0)') 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(0x1b4a590)', 'Apache2::RequestRec=SCALAR(0x1fdac50)') called at (eval 30) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x1fdac50)') called at -e line 0
eval {...} at -e line 0