Zen Cart Logo

Site maintenance: Sun 15 Nov, from 12:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice
Forums / General Questions / SQL Syntax error 1064 You have an error in your SQL syntax

SQL Syntax error 1064 You have an error in your SQL syntax

Started by vxnut on 25 Aug 2011, 3:24 AM · Views: 5,210

Results 1 to 2 of 2
25 Aug 2011, 3:24 AM
#1
vxnut avatar

vxnut

New Zenner

Join Date:
Aug 2011
Posts:
1
Plugin Contributions:
0

SQL Syntax error 1064 You have an error in your SQL syntax

I am getting the following error at the top of categories, I haven't made any changes that I know of other than trying to enter a new product, now I cannot get into products from user admin side.

Below is the error...

1064 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 'limit 0, 10' at line 1
in:
[ limit 0, 10]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Help anyone...someone...

Zen Cart v1.3.9a/v1.3.9a

25 Aug 2011, 4:58 AM
#2
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,897
Plugin Contributions:
21

Re: SQL Syntax error 1064 You have an error in your SQL syntax

First of all, when you get this going, you should upgrade to 1.3.9h.

Have you checked to make sure you have no 0 values in Admin >> Configuration >> Maximum. Most should not be 0

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com