Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id:
47756
Status:
rejected
Priority:
Low/Low
Queue:

People
Owner:
Nobody in particular
Requestors:
krohne [...] gmail.com
Cc:
AdminCc:

BugTracker
Severity:
(no value)
Broken in:
(no value)
Fixed in:
(no value)



Subject: Related to #1960
Date: Thu, 9 Jul 2009 16:55:10 -0400
To: bug-DBD-mysql@rt.cpan.org
From: Gregory Krohne <krohne@gmail.com>
perl v5.8.4 for MSWin32-x86-multi-thread DBD:mysql v2.1026 This seemingly innocent line of code throws a syntax error. 7903 $sql =<<EOSQL; 7904 UPDATE myTable SET PrimaryID = '$ter{$keyname}' 7905 WHERE PrimaryID = $pid 7906 AND RequestID = '$ter{'RequestID'}' 7907 EOSQL 7908 $rv = $Dbh->do($sql); The 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 'AND RequestID = '927'' at line 3 at ../lib/Fwmi.pm line 7908. The PrimaryID and RequestID columns are integers, of course. The '$ter{$keyname}' and '$ter{'RequestID'}' expressions are used in a SELECT statement immediately preceding these lines, without incident. This seems related to bug #1960, but that bug was fixed in v2.1024. Is it a bug? If not, what else might I try? Regards, Greg Krohne
I *know* you filed this ticket a LONGGG time ago. But the error message you see here has nothing to do with DBD::mysql - it comes straight from the MySQL server; it's just an SQL syntax error. Rejecting this ticket.


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

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