senaTTor Posted December 28, 2005 Share Posted December 28, 2005 I'm getting this error when I click on "Orders" or "Order Reporting"... Orders Order ID: Status: 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 [TEP STOP] This was working once, but no longer. Any ideas? What's the solution...? I'd rather not reinstall the whole package, as we put a lot of time into making osC look exactly how we needed it to look... Thanks!!! :thumbsup: Link to comment Share on other sites More sharing options...
♥Vger Posted December 28, 2005 Share Posted December 28, 2005 Two possible solutions: 1. Read the "1064" link below my signature. 2. Before you go live update your site to the latest patched/ updated version of osCommerce MS2 which you can find by following the Latest News link on the forum homepage. The download gives you the choice of installing the whole store or applying the individual patches/security fixes. Vger Link to comment Share on other sites More sharing options...
senaTTor Posted December 29, 2005 Author Share Posted December 29, 2005 Two possible solutions: 1. Read the "1064" link below my signature. That totally fixed it. You, sir, are The Man. Thanks so much!!! J. 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.