Opencart installation problem

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

Change the lines of code from the following files:

• install/cli_install.php

  Search for $db->query("SET @@session.sql_mode = 'MYSQL40'"); and replace with $db->query("SET @@session.sql_mode = ''");

• install/model/install/install.php

  Search for $db->query("SET @@session.sql_mode = 'MYSQL40'"); and replace with $db->query("SET @@session.sql_mode = ''");