Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database Error


Skiny

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

 

[TEP STOP]"

 

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

 

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

 

Thanks,

 

Anthony

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.

 

-jared

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...