This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
July 26, 2010 3:56pm
Subscribe [3]#1 / Jul 26, 2010 3:56pm
When a custom field is created with Field Type: Text Input, Field Content: Integer, Required Field: No, and I create a new entry, while leaving this field blank, the error
A Database Error Occurred
Error Number: 1366
Incorrect integer value: ‘’ for column ‘field_id_10’ at row 1
is displayed.
EE 2.1.0 Build 20100720 - PHP 5.2.8
#2 / Jul 26, 2010 3:57pm
Is your server running in MySQL “Strict” mode, perhaps?
#3 / Jul 26, 2010 4:16pm
Yes it was running in “Strict” mode:
#sql-mode=“STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
After changing the my.ini file and restarting the mySQL server, the problem disappeared.
The Server Wizard should mention this as a warning/error, shouldn’t it?
#4 / Jul 26, 2010 8:22pm
Good suggestion; database-related checks are currently outside the scope of the Wizard. Glad you’re up and running.
