Online Chat
 Call Us: 
1-877-744-1221
Browse Submit a Ticket
 
Advanced Search
Tools
Rss Categories

STRICT_TRANS_TABLES error when I setup database

Author: Edward Hardin Reference Number: AA-00289 Views: 21961 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:

Separate installation of MySQL:

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

WAMP:

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

XAMMP:

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.