Skip Menu |
 

This queue is for tickets about the GitDDL CPAN distribution.

Report information
The Basics
Id: 86317
Status: open
Priority: 0/
Queue: GitDDL

People
Owner: typester [...] gmail.com
Requestors: KALGAN [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.02
Fixed in: (no value)



Subject: Problem with deploy
MIME-Version: 1.0
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
Message-ID: <rt-4.0.13-11175-1371854569-1320.0-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 518
Download (untitled) / with headers
text/plain 518b
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&nbsp' 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;
MIME-Version: 1.0
In-Reply-To: <rt-4.0.13-11175-1371854569-1320.0-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <rt-4.0.13-11175-1371854569-1320.0-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.13-13428-1371855252-104.86317-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 91
Sorry, problem on line 189. It's working wrong if there is a ";" symbol in database field.
MIME-Version: 1.0
In-Reply-To: <rt-4.0.13-13428-1371855252-104.86317-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <rt-4.0.13-11175-1371854569-1320.0-0-0 [...] rt.cpan.org> <rt-4.0.13-13428-1371855252-104.86317-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-23165-1433196108-755.86317-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 218
Download (untitled) / with headers
text/plain 218b
On Fri Jun 21 18:54:12 2013, KALGAN wrote: Show quoted text
> Sorry, problem on line 189. > It's working wrong if there is a ";" symbol in database field.
This is a Pull Request with fix — https://github.com/typester/GitDDL/pull/11


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.