MySQL with error 1264 : Out of range value.........

One of my staff found some strange error

1264 Out of range value adjusted for column 'ID' at row 1

"ID" is auto increment field. This should insert if we have not define a field record id...

The problem from Guaranteeing Data Integrity with MySQL 5.0 !

you can remove a SQL-MODE parameter - "STRICT_TRANS_TABLES" in my.ini file

change
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

to
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"





Links
Guaranteeing Data Integrity with MySQL 5.0
5.2.5. The Server SQL Mode
11.1.4. Data Type Default Values