mc_exotics Posted March 6, 2005 Share Posted March 6, 2005 I installed two contributions into my store, including the SQL in my database for: Hide Price if $0 v.2 and Download_Controllev5.4 MS2.2 and now in admin/orders.php I am getting this error: 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 'limit 0, 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 limit 0, 20 [TEP STOP] I can't figure out what file has this error in it though, or how to fix it. Is the error in my SQL database, or one of my PHP files? Can anyone please help me figure out how to fix it? Thanks! Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.