1064 - You have an error in your SQL syntax

[davidrichards]

Hi,

just installed oscommerce and i am trying to add a product. After I have added the product, I click on

manufacturers

reviews

specials

etc..

 

and this error appears

 

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 '-20, 20' at line 1

 

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -20, 20

 

 

we are using FreeBSD

4.11-STABLE FreeBSD 4.11-STABLE #9: Fri Apr 8 10:58:19 BST 2005

 

And using Mysql server version: 4.1.12

and oscommerce 2.2r2

 

 

any ideas why I am getting that error.

[Guest]

Hi,

just installed oscommerce and i am trying to add a product. After I have added the product, I click on

manufacturers

reviews

specials

etc..

 

and this error appears

 

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 '-20, 20' at line 1

 

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -20, 20

we are using FreeBSD

4.11-STABLE FreeBSD 4.11-STABLE #9: Fri Apr 8 10:58:19 BST 2005

 

And using Mysql server version: 4.1.12

and oscommerce 2.2r2

any ideas why I am getting that error.

 

 

 

Hi

 

Try this it is from Vger and from what i can tell this girl knows what she is talking about.

 

hope it helps

 

 

Jaz

[davidrichards]

try what ? i dont see any thing else on this post ?