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

[vxnut]

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

[dbltoe]

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