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

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


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

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
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?

Kõike hääd,


More information about the Dancer-users mailing list