• SQL execution error! Please Turn debug mode On and check c

[iamlegendary3535]

Hi,
I am for some reason am getting this below error. I have tried searching the internet but have failed to get any solution. This problem happens in step 2.

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

Regards,

 

[hassanfakhro3650]

Re: • SQL execution error! Please Turn debug mode On and che

i am getting the same error... using iis 7.0

 

[adam]

Re: • SQL execution error! Please Turn debug mode On and che

This is as a result of mysql being configured in strict mode. Please contact your host or amend your my.cnf file it remove it.

 

[mw4945]

Re: • SQL execution error! Please Turn debug mode On and che

I get the same error message. I'm trying to install locally under an IIS environment with mySQL. How i can Turn On the debug mode on my Computer?

 

[ysmods]

Re: • SQL execution error! Please Turn debug mode On and che

I get the same error message. I'm trying to install locally under an IIS environment with mySQL. How i can Turn On the debug mode on my Computer?

You need to turn off strict mode in my.cnf or my.ini

Open the "my.ini" / "my.cnf" file within the MySQL installation directory and look for something like...

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Replace with:

# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"