Guest Posted May 16, 2008 Share Posted May 16, 2008 I would be very greatful if someone could point me in the right direction of fixing this error - i get it on the "orders" section of the admin area and in a couple of others aswell - my store is coming on nicely but my lack of coding knowledge is holding me back a little !! 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 many thanks Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 16, 2008 Share Posted May 16, 2008 See this thread. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Guest Posted May 16, 2008 Share Posted May 16, 2008 See this thread. Jack Jack. many thanks for that - it worked a charm and now my store is finished !!!! cheers 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.