[thelist] MySQL Error in PHP but not SQLYog
Fred Jones
fredthejonester at gmail.com
Wed Mar 5 05:03:12 CST 2008
I have code that was working before and today it fails. MySQL returns an
error, so I echo mysql_errno() and see only:
1406
which should be this:
===
# Error: 1406 SQLSTATE: 22001 (ER_DATA_TOO_LONG)
Message: Data too long for column '%s' at row %ld
===
I also echo the SQL I was trying to execute. My code is this:
$my_result = mysql_query($sql);
if (0 == $my_result)
{
echo "\n\n ERROR: ".mysql_errno()."\n for:\n $sql \n\n";
}
so I am quite certain that the SQL echoed is the same that generated the
error. The odd thing is that if I run the SQL (that same SQL) using
SQLYog [1] which is just another client to connect to MySQL, it runs
fine with no error, and I can confirm that the UPDATE worked.
I have never seen such a thing. I am a bit stuck. Any ideas?
Thanks.
[1] http://www.webyog.com/en/
More information about the thelist
mailing list