Knowledgebase
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
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Replace with:
# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

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))
Helpful
Not helpful