Error with MySQL 5 – disable SQL strict mode.

The script is written for MySQL version 4 or below.

It can run on MySQL 5, however you will need to turn of SQL strict mode.

Open your MySQL my.ini file and locate the following line:

#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

And change to:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Save the file and restart MySQL.

Posted in .

Leave a Reply