Community Forums

You have an error in your SQL syntax

Please post any issues you are having concerning installation or upgrade of OpenCart v1.x

You have an error in your SQL syntax

Postby techni » Thu Jan 28, 2010 9:56 am

Following configuration (Step 3) I get the following message:

"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"

A previous poster in this forum had the same problem but the remedy was not clear to me. (Ref to MySQL class). As a complete newby could someone spell out the solution to this problem for me. Thanks
techni
 
Posts: 7
Joined: Wed Jan 27, 2010 10:31 pm

Re: You have an error in your SQL syntax

Postby i2Paq » Thu Jan 28, 2010 10:02 am

Where is the topic you refer to?
Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.

First Things First: Opencart Check List.
Documentation: Our Documentation section.
BUGs?: Known BUGS for All OC Versions.

Problemen met de BTW?: [How to] BTW + Verzend & betaalmethodes.
User avatar
i2Paq
Global Moderator
 
Posts: 9750
Joined: Mon Nov 09, 2009 11:00 am
Location: Winkel - The Netherlands

Re: You have an error in your SQL syntax

Postby techni » Thu Jan 28, 2010 10:25 am

search for "no auto value on zero at line 1"
techni
 
Posts: 7
Joined: Wed Jan 27, 2010 10:31 pm

Re: You have an error in your SQL syntax

Postby i2Paq » Thu Jan 28, 2010 10:30 am

techni wrote:search for "no auto value on zero at line 1"


Me?
Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.

First Things First: Opencart Check List.
Documentation: Our Documentation section.
BUGs?: Known BUGS for All OC Versions.

Problemen met de BTW?: [How to] BTW + Verzend & betaalmethodes.
User avatar
i2Paq
Global Moderator
 
Posts: 9750
Joined: Mon Nov 09, 2009 11:00 am
Location: Winkel - The Netherlands

Re: You have an error in your SQL syntax

Postby techni » Thu Jan 28, 2010 10:35 am

The topic was MySQL version 6 this forum
techni
 
Posts: 7
Joined: Wed Jan 27, 2010 10:31 pm


Return to Installation, Upgrade, & Config Support

Who is online

Users browsing this forum: No registered users and 22 guests

Hosted by Arvixe Web Hosting