Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database Error 1064


webmire

Recommended Posts

Posted

Suddenly, with no apparent changes in the database or otherwise in the prgram, there is an error message. This message occurs when tryint to view the customers order...in the customer section of the admin control panel. I tried doing a restore from the oscommerce admin control panel and whie it did restore it to a copy previous to the error message....the message was still there.

 

This is the meassage that I get:

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.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 = '2' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -10, 10

 

[TEP STOP]

 

I have no idea what this means or how to fix it. This is my first time with SQL. I am confused as to why this has been working fine for a year and now suddenly, it no longer works. We did recently change hosts, but they moved the site and checked to make sure it was running correctly...it was for almost 2 months and now suddenly there is no way to look at customer's orders.

 

TIA for any suggestions on this.

Archived

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

×
×
  • Create New...