Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

No Orders are being displayed?


Guest

Recommended Posts

Posted

Morning all,

 

I'm an experienced programmer but new to OsCommerce so apologys if this is day one. I've recently installed osCommerce and got around the Limit -20, 20 problem as decribed in the posts but now when I go to the orders (All, Pending etc). I get no results even though my admin console shows 2 orders pending (my test cases). Here's the versions I am running on:

 

MySQL 4.1.14-standard

Apache 1.3.34 (Unix)

php Version 4.4.1

 

and the SQL being called is:

 

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 s.orders_status_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC

 

 

Many thanks,

 

NM.

  • 1 month later...
Posted

Did you ever get this resolved?? I am having the same problem. The only way to see my orders are by entering the order number. If I click on Pending, it comes up with no orders.

 

Any help would be greatly appreciated.

Archived

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

×
×
  • Create New...