How can I turn off MySQL strict mode?
Posted by Howard R. on 09 April 2014 06:57 AM
WPL or RPL may give you SQL errors in MySQL strict mode such as "My SQL Error 1048 column deleted cannot be null". We are working to get WPL and RPL running smoothly under this mode but we are not quite there yet.
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= '';