Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 error when no orders


doon1947

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

 

[TEP STOP]

--------------------------------------

 

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

Archived

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

×
×
  • Create New...