STRICT_TRANS_TABLES error when I setup database

Author: Edward Hardin Reference Number: AA-00289 Views: 22576 Last Updated: 08/08/2013 03:43 PM

56 Rating/ 4 Voters

KMP requires the STRICT_TRANS_TABLES option to be disabled in MySQL settings in order to be successfully installed:

sql-mode="STRICT_TRANS_TABLES"

This option must be removed from the sql-mode setting. You can find it in the my.ini configuration file.

Here are several examples for where you can find the my.ini:

C:\Program Files\MySQL\MySQL Server 5.1\my.ini

C:\Program Files (x86)\MySQL\MySQL Server 5.1\my.ini

C:\ProgramData\MySQL\MySQL Server 5.5\my.ini

C:\wamp\bin\mysql\mysql5.1.*\my.ini

C:\xampp\mysql\bin\my.ini

Sql-mode setting may have this look:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES"

In this case remove the STRICT_TRANS_TABLES option, like this:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

If STRICT_TRANS_TABLES is the only option in the sql-mode setting:

sql-mode="STRICT_TRANS_TABLES"

Then you can simply remove it and make sql-mode empty:

sql-mode=""

After that save the file, and restart the MySQL server to apply the change.