"SQL execution error!" On Installation

Issue

On installation after step 2 you get the following error:

• SQL execution error! Please Turn debug mode On and check carefully a syntax of your SQL dump file.

Fix

If you get an sql error when running /install/ it is because you have strict mode enabled in MySQL. You need to disable this:

https://www.webhostingdiscussion.net/blog/mysql/disable-mysql-strict-mode.htm

If you can not do this your host or server admin will be able to do it.

After it's disabled, ensure you clear any partially added tables from your database before trying the install again.