I recently migrated a script called perldesk from mysql 4 to mysql 5.
When I envoke the script from the web, I am now getting an error. I suspect its a version
Here is what I see:
Couldn't execute statement: 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 'call = '1307'
ORDER BY id' at line 1; stoppedContent-type: text/html
PerlDesk: Script Error
Perldesk was unable to launch due to the following errors:
1 at include/staff_subs.cgi line 1401.
line 1401 is the third line below:
$statemente = 'SELECT * FROM notes WHERE call = ? ORDER BY id;';
$sth = $dbh->prepare($statemente) or die print "Couldn't prepare
$sth->execute($trackedcall) or die print "Couldn't execute statement:
Any help on how to fix this would be appreciated,