"Don't have permission" error when run installation

Wed, 01 Dec 2010 12:13:15 +0000

You may get the following error when run installation on a Linux/Unix server:

"You don't have permission to access '/admin/install/index.php' on this server."

This means that permissions are incorrect.

Run the following command (assuming that the web root folder on your server is "/var/www"):

sudo chmod -R a=rx /var/www

STRICT_TRANS_TABLES error when I setup database

Mon, 06 Jul 2009 17:00:00 +0000

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.