HomeUser ManualMiscellaneousHow to turn off MySQL strict mode?

8.8. How to turn off MySQL strict mode?

Crowd Vox requires MySQL strict mode to be disabled. If you do not disable the strict mode, you may encounter errors while using the script.

To disable the strict mode, you should have administrative access to your MySQL server. Edit "sql-mode" value in MySQL configuration file (my.ini or my.cnf).

For Linux server, add the following:

[mysqld]
sql_mode="TRADITIONAL,NO_AUTO_CREATE_USER"

For Windows server, add this:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

After making the above changes, restart MySQL service.

For more details on Strict SQL Mode you may refer - http://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sql-mode-strict

Knowledge Tags

This page was: Helpful | Not Helpful