I have an install of Omeka 1.5.1 running under PHP 5.3.27 and MySQL 5.5.33. I am trying to move this to a different server and upgrade it to Omeka 2.0.4. The new server is running PHP 5.4.17 and MySQL 5.6.13.
I had no problem moving Omeka 1.5.1 to the new server. (It ran fine.) I also have no problems running a fresh install of Omeka 2.0.4 on the same environment as the new server. The problem I do have is in upgrading Omeka 1.5.1 successfully on the new server to 2.0.4. The process always fails in the database upgrade. I get this error:
Omeka encountered an error when upgrading your installation.
SQL error in migration: Mysqli statement execute error : Incorrect integer value: '' for column 'html' at row 1
Please restore from your database backup and try again. If you have any questions please refer to Omeka documentation or post a message on the Omeka forums.
I consistently get the above error if I restore the database after dropping and recreating the database.
I deactivated all plugins before dumping the Omeka 1.5.1 database.
Does anyone know what I might try in order to upgrade successfully?