General error: 1366 Incorrect integer value
Just upgraded via the dashboard from 220.127.116.11 to 5.7.5:
Now when I edit a block and save I get the following error
"An exception occurred while executing 'insert into CollectionVersionBlocks (cID, cvID, bID, arHandle, cbDisplayOrder, isOriginal, cbOverrideAreaPermissions, cbOverrideBlockTypeCacheSettings, cbOverrideBlockTypeContainerSettings, cbEnableBlockContainer) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["154", "5", "17", "Main", 0, 0, 0, 0, 0, false]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'cbEnableBlockContainer' at row 1"
If i make a new page I can add and save blocks, but not for long before the error returns.
Created a new blank website, installed my theme and the error is still coming up.
Anyone having similar problems?
@jaman: As a result, here is a workaround:
in your /etc/mysql/my.cnf (or the windows equivalent), find the line looking like this:
([...] being a placeholder for whatever)
and remove the STRICT_TRANS_TABLES, restart your MySQL server (/etc/init.d/mysql restart if your are running linux), then upgrade again.
After upgrade you can set the mysql mode like before.
That said, I am not too sure how to fix it from the current state, (that is broken in the middle of the upgrade :/), did you have a backup before you run the upgrade?
Luckily made a backup so just returned to 18.104.22.168.
May try your method depending on how fast an official fix is implemented.