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

1
votes

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

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

but not resolved problems So Please help!

1
phpmysql
Anybody help to resolve this problem because this issues help everyone......... – Sandeep Vishwakarma
Please add your insert sql here. – chandresh_cool
INSERT INTO tablename SET group_id='' etc ............... – Sandeep Vishwakarma
Please add full sql in the question section. – chandresh_cool
Different error message in title and in body, missing query, not enough info. There is no 'name' column in the query like thing in body. – Pred

1 Answers

2
votes
Find STRICT_ALL_TABLES in sql mode and try removing it in my.ini configuration file.