The script is attempting to insert or update a row with the integer entry taking on either the default value (e.g., of 0 or NULL) or the next AUTO_INCREMENT value.
MySQL is not interpreting this action as valid due to its SQL_MODE being in STRICT mode.
To fix:
/etc/mysql/mysql.conf.d/mysqld.cnf
Change
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
To:
sql_mode=””
Restart MYSQL.
*In my case I had so sql_mode entry so I just appended to the end of the file.
Credit – http://www.devside.net/wamp-server/mysql-error-incorrect-integer-value-for-column-name-at-row-1
Leave a Comment