System error
| error: | Can't execute SQL statement: SELECT id, joke, kind, status, note, voters, date, ip, teller, teller_url, teller_email FROM jokes WHERE kind= and date < and date > and status=1 ORDER BY date DBI Error Code: 1064 DBI Error Message: 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 'and date < and date > and status=1 ORDER BY date' at line 14 at /usr/www/docs/yook/jokes/dhandler line 64 |
||||||||||||||||||||||
| context: |
|
||||||||||||||||||||||
| code stack: |
/usr/share/perl/5.8/Carp.pm:86 /usr/local/share/perl/5.8.4/Persistent/DBI.pm:728 /usr/local/share/perl/5.8.4/Persistent/DBI.pm:631 /usr/www/docs/yook/jokes/dhandler:64 /usr/www/docs/yook/autohandler:10 |
Can't execute SQL statement:
SELECT
id,
joke,
kind,
status,
note,
voters,
date,
ip,
teller,
teller_url,
teller_email
FROM jokes
WHERE kind= and date < and date > and status=1
ORDER BY date
DBI Error Code: 1064
DBI Error Message: 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 'and date < and date > and status=1
ORDER BY date' at line 14
at /usr/www/docs/yook/jokes/dhandler line 64
Trace begun at /usr/local/share/perl/5.8.4/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('Can\'t execute SQL statement:^JSELECT^Jid,^Jjoke,^Jkind,^Jstatus,^Jnote,^Jvoters,^Jdate,^Jip,^Jteller,^Jteller_url,^Jteller_email^JFROM jokes^JWHERE kind= and date < and date > and status=1^JORDER BY date^J^JDBI Error Code: 1064^JDBI Error Message: 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 \'and date < and date > and status=1^JORDER BY date\' at line 14^J at /usr/www/docs/yook/jokes/dhandler line 64^J') called at /usr/share/perl/5.8/Carp.pm line 86
Carp::croak('Can\'t execute SQL statement:^JSELECT^Jid,^Jjoke,^Jkind,^Jstatus,^Jnote,^Jvoters,^Jdate,^Jip,^Jteller,^Jteller_url,^Jteller_email^JFROM jokes^JWHERE kind= and date < and date > and status=1^JORDER BY date^J^JDBI Error Code: 1064^JDBI Error Message: 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 \'and date < and date > and status=1^JORDER BY date\' at line 14^J') called at /usr/local/share/perl/5.8.4/Persistent/DBI.pm line 728
Persistent::DBI::_check_dbi_error('Joke=HASH(0x8667938)', 'Can\'t execute SQL statement:^JSELECT^Jid,^Jjoke,^Jkind,^Jstatus,^Jnote,^Jvoters,^Jdate,^Jip,^Jteller,^Jteller_url,^Jteller_email^JFROM jokes^JWHERE kind= and date < and date > and status=1^JORDER BY date^J') called at /usr/local/share/perl/5.8.4/Persistent/DBI.pm line 631
Persistent::DBI::restore_where('Joke=HASH(0x8667938)', 'kind= and date < and date > and status=1', 'date') called at /usr/www/docs/yook/jokes/dhandler line 64
HTML::Mason::Commands::__ANON__ at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8c9551c)') called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1256
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1250
HTML::Mason::Request::comp(undef, undef) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 915
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x8899370)') called at /usr/www/docs/yook/autohandler line 10
HTML::Mason::Commands::__ANON__ at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8572cf4)') called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1251
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1250
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 460
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 460
eval {...} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 412
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x8899370)') called at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x8899370)') called at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 826
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x8470800)', 'Apache2::RequestRec=SCALAR(0x8c90ac0)') called at /usr/www/mason/handler.pl line 76
Yook::Handler::handler('Apache2::RequestRec=SCALAR(0x8c90ac0)') called at -e line 0
eval {...} at -e line 0