Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

what does this mean?


scoopy

Recommended Posts

Can any one advise me what this error means and how to fix it? It is in Administration > Orders

 

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 c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price) as ordersum from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC limit -20, 20

 

Scoopy

No external links here.  

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...