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 '!,r.id,r.rating FROM ratings AS r, movie_ratings AS mr, locations AS l WHERE ' at line 1 at /var/www/db/movies/autohandler line 165 |
||||||||||||||||||||||
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:165 /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 '!,r.id,r.rating FROM ratings AS r, movie_ratings AS mr, locations AS l WHERE ' at line 1 at /var/www/db/movies/autohandler line 165 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 \'!,r.id,r.rating^JFROM ratings AS r, movie_ratings AS mr, locations AS l^JWHERE \' at line 1 at /var/www/db/movies/autohandler line 165^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 \'!,r.id,r.rating^JFROM ratings AS r, movie_ratings AS mr, locations AS l^JWHERE \' 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(0x361be70)', 'sql', 'SELECT l.id,l.location_engNaughty!,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(0x2d867c0)', 'hashref', 1) called at /var/www/db/movies/autohandler line 165 HTML::Mason::Commands::__ANON__('display_set', 'engNaughty!', 'id', 5522, 'display_set', 'engNaughty!', 'id', 5522) 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(0x2a2a1e0)', 'display_set', 'engNaughty!', 'id', 5522, 'display_set', 'engNaughty!', 'id', 5522) 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, 'display_set', 'engNaughty!', 'id', 5522, 'display_set', 'engNaughty!', 'id', 5522) 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(0x36103b0)', 'display_set', 'engNaughty!', 'id', 5522) called at /var/www/db/autohandler line 2 HTML::Mason::Commands::__ANON__('display_set', 'engNaughty!', 'id', 5522) 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(0x2a2a480)', 'display_set', 'engNaughty!', 'id', 5522) 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, 'display_set', 'engNaughty!', 'id', 5522) 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(0x36103b0)') 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(0x36103b0)') 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(0x2914690)', 'Apache2::RequestRec=SCALAR(0x2c143c0)') called at (eval 30) line 8 HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x2c143c0)') called at -e line 0 eval {...} at -e line 0