| Subject: | Problem with deploy |
When records in database contains single quotes ('), there is an SQL error:
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 ''<p>Are ' at line 2 at /usr/local/share/perl/5.10.1/GitDDL.pm line 191.
Maybe will be better using placeholders or something like this (from DBI manual):
my $rows_deleted = $dbh->do(q{
DELETE FROM table
WHERE status = ?
}, undef, 'DONE') or die $dbh->errstr;