How to turn off MySQL strict mode
Posted by Edward T. on 03 September 2016 05:21 AM
When the MySQL strict mode is one, you may experience some unexpected issues with WPL (and some other well known web applications)
Please follow mentioned instruction to turn it off.
First, you should have SSH access to your Server, and login into it.
Please make following changes to the MySQL configuration file, it could be find at the "/etc/my.cnf" (or just my.ini in windows based servers)
1. Look for the following line:
2. Change it to:
(Blank, or just remove the 'STRICT_TRANS_TABLES,' part)
3. Save the file and Restart the MySQL service: