We’re in the process of migrating our EE install with the Freeform module to a new hosting environment. Everything in EE seems to be up, running, and working properly. When we tested the forms we have on our site, however, we get a MySQL error when submitting them. Here’s the error:

MySQL ERROR:

Error Number: 1364

Description: Field ‘weblog_id’ doesn’t have a default value

Query: INSERT INTO `exp_freeform_entries` (`author_id`, `group_id`, `ip_address`, `entry_date`, `edit_date`, `status`, `form_name`, `qc_name`, `qc_phone`, `email`, `qc_other`, `qc_newsletter`) VALUES (‘1’, ‘1’, ‘64.134.186.218’, ‘1278702327’, ‘1278702327’, ‘open’, ‘quick_contact’, ‘Shawn Berg’, ‘727-555-1212’, ‘shawn@itistic.com’, ‘Testing!’, ‘Yes!’)

I checked the weblog_id field in exp_freeform_entries in both environments (new and old) and neither have a default value set. Any idea what may be causing this problem in the new environment? Our database was backed up using the mysqldump utility and restored with the mysql command line utility.

Thanks!

Shawn

I’ve figured out the problem. After running the EE Server Wizard I determined that the MySQL Server in the new environment was running in strict mode. After disabling strict mode the problem was resolved.

Glad to see you found the solution. Please post again in case there’s anything else.