1064

[JohnWaters]

Hi,

 

I have just set up a new site.

 

When placing an order, everything is fine.

 

But when I go to Admin, Reports, Products purchased I receive

 

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 p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20.

 

MY SQL 4.1

 

Any Ideas ?

 

Thanks

[AlanR]

There's a fix:

 

http://www.oscommerce.com/community/bugs,1605

[JohnWaters]

There's a fix:

 

http://www.oscommerce.com/community/bugs,1605

<{POST_SNAPBACK}>

 

Thanks Alan, that did the trick