Turn off MySQL strict mode?
Posted by David Stanley on 07 May 2014 12:28 AM

MySQL strict mode with error "My SQL Error 1048 column description cannot be null" or .mysql error : Incorrect integer value:

This can be fixed in one of two ways but you may have to get your hosting company to do this for you.

Method 1:
Open the "my.ini" file within the MySQL installation directory and look for something like...
# Set the SQL mode to strict

Replace with:
# Set the SQL mode to strict

Method 2:
You may be able to run an SQL query within your database management tool such as phpMyAdmin which can normally be found from your web hosting control panel:

SET @@global.sql_mode= '';



(2 vote(s))
Not helpful