Skip to content

FIX: MySQL5.6 – MySQL5.7 without changing the code. Errors like: (22003): Out of range value , ERROR 1365 (22012): Division by 0, and etc.

December 22, 2015

When your code is for mysql5.6 and your admin upgrade to mysql5.7

you can see errors like this:

ERROR 1264 (22003): Out of range value for column 'a' at row 1

ERROR 1365 (22012): Division by 0

ERROR 1406 (22001): Data too long for column 'a' at row 1

ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'a' at row 1
ERROR 1055 (42000): Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'invoice_line_items.description' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


Quick tutor:

https://www.digitalocean.com/community/tutorials/how-to-prepare-for-your-mysql-5-7-upgradeĀ 

 

Detailed doc:

http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-changes

Advertisements

From → bookmarks, databases

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: