Error Number: 1366 (Incorrect integer value:

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.

solution:

Is your server running in MySQL “Strict” mode, comment that line as follows.

#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?