Disable MySQL strict mode

Disable MySQL strict mode

Many third party scripts viz. Cubecart, WHMCS etc. require to disable MySQL strict mode. If you do not disable MySQL strict mode, you may receive errors during installation.

WHMCS Complete Billing and Support

The most commons errors are as follow:

My SQL Error 1048 column description cannot be null
Incorrect integer value: '' for column 'id' at row 1
Field 'xyz' doesn't have a default value

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:

For Windows server, you can follow the below steps:

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

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

Note: After sql_mode= and sql-mode=, there is double quote. It may be parsed in the post. You should copy the data in notepadĀ  and edit double quote again.

Posted in MySQL.

4 Comments

  1. Pingback: WHMCS installation error - Field doesn't have a default value

Leave a Reply

Your email address will not be published. Required fields are marked *