SQL Error Creating New Form

[dbolton1221]

I am getting an error when I attempt to create a new form.

Sorry can't execute SQL query
1366:Incorrect integer value:'' for column
'frm_hw_confirm' at row 1

Any ideas as to what may be setup incorrectly?

[dbolton1221]

Problem solved:

I needed to turn off "strict mode"

On Windows Server edit my.ini

Replace line: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

with line: sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Stop and restart mysql service