VPSsupport Posted August 4, 2006 Share Posted August 4, 2006 Hi, I have the following error msg in admin/orders - any ideas? It happens when I view a customers order with no details just the error msg. 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 = '317' 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 Regards Regards, Clive Link to comment Share on other sites More sharing options...
VPSsupport Posted August 4, 2006 Author Share Posted August 4, 2006 customer orders are not being stored in the database and this seems to happen intermittently - any ideas? Regards, Clive Link to comment Share on other sites More sharing options...
Guest Posted August 4, 2006 Share Posted August 4, 2006 make sure you have this http://www.oscommerce.com/community/bugs,1605 fix at the end of page. the latest osc upgrade also includes it along with other fixes. Link to comment Share on other sites More sharing options...
VPSsupport Posted August 4, 2006 Author Share Posted August 4, 2006 make sure you have thishttp://www.oscommerce.com/community/bugs,1605 fix at the end of page. the latest osc upgrade also includes it along with other fixes. Mark - we all would be screwed without your knowledge! Thanks for taking the time! Regards, Clive Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.