Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

error on report tool


slime

Recommended Posts

dear sir(s):

 

i havent changed any of the default settings of database of oscommerce but i have these errors on the report section of the admin tools:

 

+--------------------------------------------------------------------------------------------------------------------------+

Best Products Purchased

 

No. Products Purchased

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

+-------------------------------------------------------------------------------------------------------------------------+

 

any idea or walkthrough?

 

tia

 

~slime

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...