Mason error

error in file:   /usr/local/share/perl/5.8.8/HTML/Mason/Interp.pm
 
line 70:  WHERE ' at line 1
context:  
... 
54:  current_time => 'real',
55:  data_cache_dir => '',
56:  data_dir => undef,
57:  dhandler_name => 'dhandler',
58:  die_handler => sub { Carp::confess($_[0]) },
59:  die_handler_overridden => 0,
60:  system_log_file => undef,
61:  system_log_separator => "\cA",
62:  max_recurse => 32,
... 
66:  resolver => undef,
67:  static_file_root => undef,
68:  use_autohandlers => 1,
69:  use_data_cache => 1,
70:  use_dhandlers => 1,
71:  use_object_files => 1,
72:  use_reload_file => 0
73:  );
74: 
... 
component stack:   /db/movies/autohandler
/db/autohandler
code stack:   /usr/local/share/perl/5.8.8/HKMDB/Database.pm:354
/var/lib/mason/obj/db/movies/autohandler:70
/var/lib/mason/obj/db/movies/autohandler:16
/var/lib/mason/obj/db/autohandler:14


raw_error




























raw error:
 






























error while executing /db/movies/autohandler:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL 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/lib/mason/obj/db/movies/autohandler line 70
 at /usr/local/share/perl/5.8.8/HTML/Mason/Interp.pm line 58
HTML::Mason::Interp::__ANON__('You have an error in your SQL syntax; check the manual that c...') called at /usr/share/perl/5.8/Carp.pm line 102
Carp::croak('You have an error in your SQL syntax; check the manual that c...') called at /usr/local/share/perl/5.8.8/HKMDB/Database.pm line 354
HKMDB::Database::select_rows('HKMDB::Database=HASH(0x9c0a558)', 'sql', 'SELECT l.id,l.location_engNaughty!,r.id,r.rating\x{a}FROM   ratin...', 'bind', 'ARRAY(0x9cc251c)', 'hashref', 1) called at /var/lib/mason/obj/db/movies/autohandler line 70
HTML::Mason::Commands::__ANON__('display_set', 'engNaughty!', 'id', 5522, 'display_set', 'engNaughty!', 'id', 5522) called at /usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 131
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9b3e36c)', 'display_set', 'engNaughty!', 'id', 5522, 'display_set', 'engNaughty!', 'id', 5522, ...) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 376
HTML::Mason::Request::call_self('HTML::Mason::Request::ApacheHandler=HASH(0x9cc84a0)', 'SCALAR(0x9caec14)', 'SCALAR(0x9d85420)') called at /var/lib/mason/obj/db/movies/autohandler line 16
HTML::Mason::Commands::__ANON__('display_set', 'engNaughty!', 'id', 5522, 'display_set', 'engNaughty!', 'id', 5522) called at /usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 131
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9b3e36c)', 'display_set', 'engNaughty!', 'id', 5522, 'display_set', 'engNaughty!', 'id', 5522, ...) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 654
eval {...} called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 654
HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x9cc84a0)', 'HTML::Mason::Component::FileBased=HASH(0x9b3e36c)', 'display_set', 'engNaughty!', 'id', 5522, 'display_set', 'engNaughty!', 'id', ...) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 317
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x9cc84a0)', 'display_set', 'engNaughty!', 'id', 5522) called at /var/lib/mason/obj/db/autohandler line 14
HTML::Mason::Commands::__ANON__('display_set', 'engNaughty!', 'id', 5522) called at /usr/local/share/perl/5.8.8/HTML/Mason/Component.pm line 131
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9b3e63c)', 'display_set', 'engNaughty!', 'id', 5522) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 654
eval {...} called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 654
HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x9cc84a0)', 'HASH(0x9cccdb0)', 'HTML::Mason::Component::FileBased=HASH(0x9b3e63c)', 'display_set', 'engNaughty!', 'id', 5522) called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 160
eval {...} called at /usr/local/share/perl/5.8.8/HTML/Mason/Request.pm line 160
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9cc84a0)', '/db/movies/reviews.mhtml', 'display_set', 'engNaughty!', 'id', 5522) called at /usr/local/share/perl/5.8.8/HTML/Mason/ApacheHandler.pm line 914
HTML::Mason::ApacheHandler::handle_request_1('HTML::Mason::ApacheHandler=HASH(0x9acf5c4)', 'Apache=SCALAR(0x9d75ee8)', 'HTML::Mason::Request::ApacheHandler=HASH(0x9cc84a0)', 'undef') called at /usr/local/share/perl/5.8.8/HTML/Mason/ApacheHandler.pm line 560
eval {...} called at /usr/local/share/perl/5.8.8/HTML/Mason/ApacheHandler.pm line 560
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x9acf5c4)', 'Apache=SCALAR(0x9d75ee8)') called at /etc/apache-perl//mason_handler.pl line 48
HTML::Mason::handler('Apache=SCALAR(0x9d75ee8)') called at /dev/null line 0
eval {...} called at /dev/null line 0