#1366 – Incorrect integer value: ” for column ‘upd_iid’ at row 1

While I was switching a legacy site from servers… some SQLs weren’t working…

#1366 - Incorrect integer value: '' for column 'upd_iid' at row 1

This worked for me…
I’v edited my /etc/mysql/my.cnf  and comment the original “sql_mode” and added this one

sql_mode = ""

Save and restart mysql!

https://stackoverflow.com/questions/14762904/incorrect-integer-value-for-column-id-at-row-1/53154716#53154716

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.