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!