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 mr' at line 1 at /var/www/db/movies/autohandler line 165
context: 
... 
265:  # whether they should generate a full stack trace (confess() and cluck())
266:  # or simply report the caller's package (croak() and carp()), respectively.
267:  # confess() and croak() die, carp() and cluck() warn.
268: 
269:  sub croak { die shortmess @_ }
270:  sub confess { die longmess @_ }
271:  sub carp { warn shortmess @_ }
272:  sub cluck { warn longmess @_ }
273: 
... 
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
raw 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  mr' 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  mr\' 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  mr\' 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(0x7f375e356960)', 'sql', 'SELECT l.id,l.location_eng.,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(0x2da2d60)', 'hashref', 1) called at /var/www/db/movies/autohandler line 165
HTML::Mason::Commands::__ANON__('display_set', 'eng.', 'id', 6335, 'complete_credits', 1, 'display_set', 'eng.', 'id', 6335, 'complete_credits', 1) 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(0x2895a20)', 'display_set', 'eng.', 'id', 6335, 'complete_credits', 1, 'display_set', 'eng.', 'id', 6335, 'complete_credits', 1) 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', 'eng.', 'id', 6335, 'complete_credits', 1, 'display_set', 'eng.', 'id', 6335, 'complete_credits', 1) 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(0x2cb39d0)', 'display_set', 'eng.', 'id', 6335, 'complete_credits', 1) called at /var/www/db/autohandler line 2
HTML::Mason::Commands::__ANON__('display_set', 'eng.', 'id', 6335, 'complete_credits', 1) 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(0x2895ce0)', 'display_set', 'eng.', 'id', 6335, 'complete_credits', 1) 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', 'eng.', 'id', 6335, 'complete_credits', 1) 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(0x2cb39d0)') 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(0x2cb39d0)') 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(0x279e570)', 'Apache2::RequestRec=SCALAR(0x2da76c0)') called at (eval 30) line 8
HTML::Mason::ApacheHandler::handler('HTML::Mason::ApacheHandler', 'Apache2::RequestRec=SCALAR(0x2da76c0)') called at -e line 0
eval {...} at -e line 0