Opencart安装问题

Question

I am trying to install opencart for the first time in my local machine. I am using xampp 1.7.4 PHP 5.3.4 and Windows7 is my OS. I try to follow all the steps describe HERE. But, after giving the db name, db user name and password when I press "Continue" button I am getting the following error message:

Variable 'sql_mode' can't be set to the value of 'NO_AUTO_VALUE_ON_ZERO'

I try to google it with this error message but do not find anything. Please help me.....

Answer 1

Remove below line from opencart.sql

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"

you can find opencart.sql file in install folder

Above error comes if different version of mysql is being used.