Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

problem with Mysql When receive orders


Guest

Recommended Posts

Posted

Hello i have a problem I don't receive orders

 

I only see the following message

 

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

 

select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '4' order by orders_id DESC limit -10, 10

 

[TEP STOP]

 

How can fix it. Please i need instructions step by step

 

 

Thanks you in advance.

Archived

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

×
×
  • Create New...