Mysql 5 sometimes includes a new setting by default that causes an error when adding an item to a collection. The setting is for "sql-mode" and is included in my.ini. The property is STRICT_TRANS_TABLES.

The solution is to remove STRICT_TRANS_TABLES from my.ini manually or uncheck "Enable Strict Mode" if using the Mysql Server Instance Configuration Wizard.

Its fairly easy to generate an error when strict mode is enforced so while disabling is not ideal, many other apps have similar problems.

For more information on STRICT_TRANS_TABLES and STRICT_ALL_TABLES see the mysql website.