theraven Posted June 13, 2007 Share Posted June 13, 2007 Customers Order Total Date Purchased Status Action 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 can someone please tell me what this error means and how do i fix the issue? thanks Link to comment Share on other sites More sharing options...
Guest Posted June 13, 2007 Share Posted June 13, 2007 Make sure you have all the updates http://www.oscommerce.com/forums/index.php?showtopic=180289 and http://www.oscommerce.com/forums/index.php?showtopic=223556 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.