DBD::mysql::st execute failed:
Status: Alpha
Brought to you by:
cicciobello2
Menu
▾
▴
#5 DBD::mysql::st execute failed:
Sometimes logfile looks like that:
20061207 13:40:01
Created temporary file 1165495201
traduttore......... OK
MySQL......... OK
Deleted temporary file 1165495201
20061207 13:50:01
Created temporary file 1165495801
traduttore......... OK
MySQL......... OK
Deleted temporary file 1165495801
20061207 14:00:01
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to
Unable to execute query: DBI::db=HASH(0x842b2d0)->errstr
Created temporary file 1165496402
traduttore......... OK
20061207 14:10:01
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to
Unable to execute query: DBI::db=HASH(0x842b2d0)->errstr
Created temporary file 1165497001
traduttore......... OK
everything gone OK but at 20061207 14:00:01 was errors till end of file. What's going on?. If I'll import the file using mysqlimport it insterts to mysql with no errors. Anybody can help?
Logged In: YES
user_id=1298065
Originator: NO
Check if you have an apostrophe symbol in that row.
We're waiting for your answer.
Logged In: YES
user_id=1663902
Originator: YES
Yes I Have, for example: vanishesunconsciousness's@ad.gov.yu. I think It's a spam. Do you know how to fix it?
Logged In: YES
user_id=1298065
Originator: NO
We try to fix the bug in these days, unfortunately mysql sees an apostrophe like the end of the query, meanwhile, try to replace this apostrophes with another symbol.
Logged In: NO
The problem is about the ' char. It was not correctly escaped, so you have to dig the perl code to find where the insert is constructed and apply a patch.
Sorry but I don't know perl so I cannot tell you more than that.
Logged In: YES
user_id=1663902
Originator: YES
New version has no errors like that. Was solved. Thnx for janiceitit.
Logged In: YES
user_id=1298065
Originator: NO
Actually, the new version hasn't got the patch. I posted it in Tracker/Patches. You had the patch, beacause I posted it time ago.