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

Written by Matt Cooper
Hi, I'm Matt Cooper. I started this blog to pretty much act as a brain dump area for things I learn from day to day. You can contact me at: matt@linuxtutorial.co.uk.