webmire Posted February 26, 2007 Posted February 26, 2007 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.
webmire Posted February 27, 2007 Author Posted February 27, 2007 bumping this up.... PS...forgot to add mySQL version is 4.1.10
Recommended Posts
Archived
This topic is now archived and is closed to further replies.