Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1064 error when no orders


Recommended Posts

2.2ms2, MySQL 5


Login to Admin area"Orders" box shows

Pending: 2

Processing: 0

Delivered: 0


When I click on the link "Pending" it shows the correct results

When I click on the link "Processing" I get:



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 '-100, 100' at line 1


select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and s.orders_status_id = '2' and ot.class = 'ot_total' order by o.orders_id DESC limit -100, 100





This error only occurs if "Processing" = 0, if I set "Processing" to some value, other than zero, error disapears

Same error occurs with "Pending" or "Delivered" if they are zero.


Al Moodie.

Link to comment
Share on other sites


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

  • Create New...