[Dancer-users] Plugin::Database failed on reconnect

WK wanradt at gmail.com
Thu Apr 12 09:53:00 CEST 2012


Hi!

My little application stand whole night and when on morning user made
first request, app did not connect properly to Database. Error was
like:

DBD::mysql::db do failed: 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
''utf8&am'
at line 1 at /usr/local/share/perl/5.12.4/Dancer/Plugin/Database.pm
line 198.
/usr/local/share/perl/5.12.4/Dancer/Plugin/Database.pm around line 198
195         return;
196     } elsif (exists $settings->{on_connect_do}) {
197         for (@{ $settings->{on_connect_do} }) {
198             $dbh->do($_) or Dancer::Logger::error(
199                 "Failed to perform on-connect command $_"
200             );
201         }


As i use also Plugin::EscapeHTML with automatic_escaping: 1,  it seems
that there is some problem with 2 of them together. At least there is
made some weird escaping. Or?

After restarting app, connenction to DB was alright.

Main problem: how to avoid reconnecting failure?

-- 
Wbr,
Kõike hääd,

Gunnar


More information about the Dancer-users mailing list