Guest Posted March 16, 2006 Posted March 16, 2006 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.
PattiH Posted May 4, 2006 Posted May 4, 2006 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.