jfcby Posted November 10, 2005 Share Posted November 10, 2005 Under Adminastration, Reports, Best Products Purchased I'm getting this error message: 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 How can I fix it? Thank you for your help, jfcby Link to comment Share on other sites More sharing options...
seaserver Posted November 11, 2005 Share Posted November 11, 2005 I am having the same problem. I recently moved my databases from a server running MySql 3 to a server running MySql 4 and receive the same error at different places throughout 8 unique shopping carts. Any ideas? Link to comment Share on other sites More sharing options...
seaserver Posted November 11, 2005 Share Posted November 11, 2005 I found the fix in the bug reports and it works great. http://www.oscommerce.com/community/bugs,1605/search,sql Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.