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

Comments

Popular posts from this blog

Wowza 4.0.1 (Wowza Streaming Engine) Released!

WebRTC for Real-Time Communications