#178 Bug During Upgrade

[Anonymous]

During the upgrade I was presented with an error stating:

SQLState[HY000]: General error: 1366 Incorrect integer value: '' for column 'state' at row 126.

Failed query:
/ change tag /
ALTER TABLE ipaddresses CHANGE state INT(3) NULL DEFAULT '1';

This seems to be related to the STRICT_TRANS_TABLES in newer versions of mysql. To resovle the issue I needed to do the following:

Run this to get the current mysql mode:
SELECT @@GLOBAL.sql_mode;

Modify the value returned to omit STRICT_TRANS_TABLES. So in my instance I ran:
SET @@GLOBAL.sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Then I re-ran the upgrade and it ran successfully. After doing so I went back and restored STRICT_TRANS_TABLES using the following:

SET @@GLOBAL.sql_mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Not that big of a deal but maybe something to look at working around in a future release. Hopefully this will save someone else some effort.