DB migration fails upgrading from 1.5.1 to 2.0.4

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?

This looks like it might be some problem with old data and your new server being set to one of MySQL's "strict" modes.

Normally, MySQL will silently ignore an error like that. Unsetting the strict mode for MySQL may resolve this.

Thanks for the help---setting sql-mode='' in my.cnf allowed the DB migration to complete.