Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Orders not showing any more - error coming up


mshisha

Recommended Posts

Hi don't know if anyone has any ideas on this - my website was working fine with payment via Paypal - but now the orders are not showing on the site and get this error on each customer other than the first one :-

 

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 = '27' 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

 

[TEP STOP]

 

Has anyone experienced this or have any ideas why this is suddenly coming up?

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...