Orders not showing in Admin

[LunchBox]

:? I'm probably being really thick but...

 

I've set up my catalog and put through an order using the Cheque/Money Order payment module.

 

The Catalog seems to work fine, but the order isn't appearing in the Admin.

 

After further investigation, going into the My Account section of Catalog and viewing order history, it shows the order, but there is no order status.

 

Am I missing something? Is there a big on switch?

 

Many Thanks,

 

Jason.

[LunchBox]

The order_status table is empty.

 

Any ideas?

[LunchBox]

n/t

[eljorge]

(if received twice, please excuse, connection died)

 

Then I too am thick...

 

if you type in the order number in the upper left, can you pull up the order? I am having the same trouble, please let me know if you figure it out, I will do the same. SO far I have pulled apart the SQL query and run it, it returns an empty set, so something is wrong. I also noticed that the orders_total table is empty, and prob. shouldn't be since the order query depends on a condition from orders_total

 

 

 

here is the query that runs:

 

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 " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and s.orders_status_id = '" . tep_db_input($status) . "' and ot.class = 'ot_total' order by o.orders_id DESC"

 

 

 

here is what I modified it to be (for real numbers instead of constants:

 

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

 

 

 

It comes back empty though..... :?: :?: :?:

 

 

 

 

:? I'm probably being really thick but...

 

I've set up my catalog and put through an order using the Cheque/Money Order payment module.

 

The Catalog seems to work fine, but the order isn't appearing in the Admin.

 

After further investigation, going into the My Account section of Catalog and viewing order history, it shows the order, but there is no order status.

 

Am I missing something?  Is there a big on switch?

 

Many Thanks,

 

Jason.

[leolll]

I'm having the same problem. This post has been up for 10 days now and nobody has posted a solution. If you have any ideas on how to fix this, please post them.

[leolll]

My bad, I should have searched the forum a little more. The solution to my problem was posted in: [bUGS] Bug #686: Updated: ORDERS NOT SHOWN IN ADMIN

 

Basically the order_status table was empty and should have contained an insert similar to this:

 

INSERT INTO orders_status VALUES (1, 1, 'Pending');

INSERT INTO orders_status VALUES (2, 1, 'Processing');

INSERT INTO orders_status VALUES (3, 1, 'Delivered');

 

The above insert will vary for each site depending on mods and languages installed. Hope this helps.

[eljorge]

I got it to work a different way. I exported all of my tables related to products and users (but not orders)

 

Then I reinstalled OCS.

 

Then imported the tables again.

 

I suspect that the same thing happened, the table mentione by Leo was recreated properly.

 

 

Hope that helps