Disable MySQL strict mode - Turn off MySQL strict mode
« on: October 18, 2014, 02:39:41 PM »
You may get a message stating that you require to disable MySQL strict mode to install third party script. The common errors are like  column description cannot be null etc.

To disable MySQL strict mode, you will need your server’s root or administrative access. You will need to edit “sql-mode” value in your MySQL configuration file (my.ini or my.cnf).

For Linux server, you will need to add the following:

[mysqld]
sql_mode="TRADITIONAL,NO_AUTO_CREATE_USER"

For Windows server, you can follow the below steps:

# The following line will set MySQL strict mode

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

To disable MySQL strict mode, you can change the above line as follow:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

After making the above changes, you will have to restart your MySQL service.