minglou Posted October 18, 2005 Share Posted October 18, 2005 Hi guys, i got this errors today suddenlty, in admin/orders.php 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 '-9, 9' 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 s.orders_status_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -9, 9 anyone knows what the errors means? and how to fix it? Thank you so much!!! guys, urgent!!!! Link to comment Share on other sites More sharing options...
minglou Posted October 18, 2005 Author Share Posted October 18, 2005 Anyone help please!!!!! Link to comment Share on other sites More sharing options...
Guest Posted October 18, 2005 Share Posted October 18, 2005 It may happen when the tables are empty with certain mysql versions. See this fix (near the end of the page) and add it to your files. http://www.oscommerce.com/community/bugs,1605 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.