Guest Posted August 31, 2006 Share Posted August 31, 2006 Just made a clean install and get this error in ADMIN under Costumers. Tried to repair the table in PHPMyAdmin, but without any luck. When I place a new order the error is gone. Same issue with all links listed below COSTUMERS. The errors appears when there's no orders, costumers etc. What causes 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 '-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 = '4' and s.orders_status_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 Awaiting your soonest reply Link to comment Share on other sites More sharing options...
Guest Posted September 3, 2006 Share Posted September 3, 2006 Just made a clean install and get this error in ADMIN under Costumers.Tried to repair the table in PHPMyAdmin, but without any luck. When I place a new order the error is gone. Same issue with all links listed below COSTUMERS. The errors appears when there's no orders, costumers etc. What causes 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 '-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 = '4' and s.orders_status_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 Awaiting your soonest reply Anyone that could be so kind telling me what causes this error? Link to comment Share on other sites More sharing options...
marty_mcfly Posted September 3, 2006 Share Posted September 3, 2006 Anyone that could be so kind telling me what causes this error? The -20, 20 is causing the problem. Someone else had the same problem in another thread. Have you installed any order contributions as I don't get the LIMIT clause in my shop? Martin Link to comment Share on other sites More sharing options...
Guest Posted September 4, 2006 Share Posted September 4, 2006 The -20, 20 is causing the problem. Someone else had the same problem in another thread. Have you installed any order contributions as I don't get the LIMIT clause in my shop? Martin Hi, Just made a clean install and no other contributions installed. What's the -20,20? The error disapears when adding something. Thanks! 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.