dave249 Posted December 1, 2005 Share Posted December 1, 2005 done a test run and made an order on my site but when i look at orders in admin all i get is 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] Whats happened here? Appreciate any help pn this one Thanks Dave Link to comment Share on other sites More sharing options...
dave249 Posted December 1, 2005 Author Share Posted December 1, 2005 ok i have been trying to read up on this but i really have no idea what is wrong or what to do so is anyone willing to sort this out for me and just slightly change the main page? I of course will pay for this. If anyone is interested please pm me thanks Dave 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.