Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HELP! First order and I cant see what they ordered! (Errors)


loghova

Recommended Posts

Posted

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.

Posted

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.

Posted
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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...