hawas Posted July 7, 2008 Share Posted July 7, 2008 Dear Sir/ madam, Every time a customer order from my site I get a confermation of his payment. But the problem is when I go to my site admin to view the order I find the following message insead: {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 o.orders_id, o.customers_name, o.customers_id, 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.customers_id = '46' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20}. Can you please help. Kind regards Samir Link to comment Share on other sites More sharing options...
Guest Posted July 7, 2008 Share Posted July 7, 2008 Try here Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.