Post by mitchen9 » Fri Aug 28, 2009 7:28 am

I am trying to install Open Cart on a Unix server running MySQL client version: 6.0.8-alpha. After I click continue on the Step 2 - Configuration page, I get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"NO_AUTO_VALUE_ON_ZERO\"' at line 1

The database that I'm using is completely empty. Does anyone know why I might be receiving this error?

The server is also running Apache/2.2.11 (FreeBSD) mod_ssl/2.2.11 OpenSSL/0.9.8e DAV/2 PHP/5.2.9 with Suhosin-Patch

Newbie

Posts

Joined
Fri Aug 28, 2009 7:22 am

Post by Daniel » Fri Aug 28, 2009 8:31 am

just remove the line of code in the mysql class

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by mitchen9 » Fri Aug 28, 2009 9:00 pm

Can you tell me the exact line in the exact file that you are referring to? If I open the opencart.sql file and remove:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

I receive the exact same error with the next line of code

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

This pattern repeats with every subsequent line of code I remove. I get the before stated error message with the next line of code in the error.

Newbie

Posts

Joined
Fri Aug 28, 2009 7:22 am
Who is online

Users browsing this forum: No registered users and 8 guests