loghova Posted March 21, 2007 Posted March 21, 2007 When I go into the admin panel and click 'Orders' I get the following error: Orders Order ID: Status: All OrdersPendingProcessingDelivered Customers Order Total Date Purchased Status Action 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.customers_id, 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.customers_id = '4' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20 [TEP STOP] Please help m out, I am stuck.
loghova Posted March 21, 2007 Author Posted March 21, 2007 Here is what I am thinking. I had this happen in the Tax Rate Table too and this was because there were no rows in the database. I manually entered a row and it was fine. It may be posible that one of these tables has no rows, but that wouldnt make sense because there should be an order stored there? I guess I will figure out what it is using and check the tables. I am seriously at a loss.
Jan Zonjee Posted March 21, 2007 Posted March 21, 2007 I am seriously at a loss. And at risk too, because you haven't applied the updates to osC 2.2. Download the latest version, there is an update instruction. Or either looks in the contributions where there also seems to be more elaborate instructions for updating. The -20,20 error is old, very, very, very, very old and tiring.
loghova Posted March 21, 2007 Author Posted March 21, 2007 This is a new install though, no more than 2 months. The install isnt up to date?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.