I am trying to upgrade a 1.7.5 server to the 2.x version. I have tried to upgrade to 2.1 and 2.5.1.1 and am having the same issue.
The first failure I get is this:
Error: Failed to execute DB schema transformations. MySQL said: Out of range value for column 'priority' at row 1
I temporarily changed the value of plugins.priority to varchar (instead of smallint) to work around this.
I run the upgrade again and get this error:
Error: Failed to execute DB schema transformations. MySQL said: Field 'plugin_id' doesn't have a default value
To work around this I set default values for plugin_id (4 instances) to 0
I run the upgrade again and get this error:
Error: Failed to execute DB schema transformations. MySQL said: Field 'path' doesn't have a default value
To work around this I set the path default to ' '
I ran it again and now get the error:
Error: Failed to execute DB schema transformations. MySQL said: Field 'default_options' doesn't have a default value
To work around this I set default_options default to ' '
Now I am stuck because I get the error:
Error: Failed to execute DB schema transformations. MySQL said: BLOB/TEXT column 'default_options' can't have a default value
We have no plugins installed. I tired changing the sql_mode to MYSQL40 but it had no effect.
Any help would be appreciated.