Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Database Error


Recommended Posts

Right, I've just installed osCommerce, and when I click "Orders" under the "Customers" heading in the admin control panel, I get the following error:


"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.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 ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20




I've tried reinstalling it a few times, but the same thing keeps happening.


Does anyone know whats wrong? Or how to fix it?





Link to comment
Share on other sites

It worked for me, too. Problem is, that it's hard to know exactly what to search for when the error message uses negative error numbers and is so short. It can be a pain to find the right thread.



Link to comment
Share on other sites


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

  • Create New...