May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  

MySQL Error: Data truncated for column ‘…’ at row 0

If you’ve recently migrated from MySQL 4 to MySQL 5, queries that used to work might cause errors. The thing is that MySQL got much more struct about what data can go where. MySQL 4 used to cast NULL values to 0 INT, DOUBLE, FLOAT etc implicitly. MySQL 5 doesn’t do it so you ether [...]