Sandeep Vishwakarma Sandeep Vishwakarma - 1 year ago 178
MySQL Question

After installing latest version of MySQL then I get error : #1366 - Incorrect integer value: '' for column 'group_id' at row 1

After installing the latest version of MySQL I get the following error when inserting data into the database. My application was running old version of mysql but after update new version all application was breakdown.

mysql query like this :

INSERT INTO tablename SET group_id='' etc..............

Error :

1366 - Incorrect integer value: '' for column 'name' at row 1

also I have try to set --


but not resolved problems
So Please help!

Answer Source
Find STRICT_ALL_TABLES in sql mode and try removing it in my.ini configuration file.
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download