JohnWaters Posted July 24, 2005 Share Posted July 24, 2005 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 Link to comment Share on other sites More sharing options...
AlanR Posted July 25, 2005 Share Posted July 25, 2005 There's a fix: http://www.oscommerce.com/community/bugs,1605 Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
JohnWaters Posted July 25, 2005 Author Share Posted July 25, 2005 There's a fix: http://www.oscommerce.com/community/bugs,1605 <{POST_SNAPBACK}> Thanks Alan, that did the trick Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.