Orders not visible in the admin page

Hi All,

I upgraded a site from 1.3.8 to 1.3.9h and my orders are not visible in the admin page anymore.

When a customer places and order, all emails are properly sent to them and me and the orders are recorded in the database. But they don't turn up in the admin page.

Anybody has any idea what might be wrong?

Thanks,

Laszlo

Could you check if you can search for an orders_id in your Customers ... Orders ...

Could you check in the Modules ... Order Totals ... and make sure that you have Total ot_total installed ...

Can you check if you go to phpMyAdmin and search the table:
orders_total

and see what class settings come up ...

Do you see ot_total for this orders_id that you cannot see?

Hi Ajeh,

Thx for the feedback.

This is a new site so there are not many orders. I paid someone to migrate one of my existing sites to a new domain without the existing orders and customers and it appears that some mistakes were made.

I have 3 customers so far, each ordered one order.

All three customers are in the customers table. All three orders are in orders table. The customer ids in the orders table match the customers in the customers table correctly.

Orders total is installed. In the orders_total table I can see the ot_total class for each of the three orders.

I also noticed that I can not see the orders in My Account either (one of the three customers is my test customer).

Laszlo

If you browse the table:
orders

you see the 3 orders_id correctly?

If you browse the table:
orders_products

you see the 3 orders_id correctly?

If you browse the table:
orders_status

you see the 4 Order Statuses for:
Pending
Processing
Delivered
Updated

If you check the table:
orders

they have valid orders_status values?

Ok, we are getting somewhere:-)

Ajeh:

If you browse the table:
orders

you see the 3 orders_id correctly?

Yes.

If you browse the table:
orders_products

you see the 3 orders_id correctly?Yes.

If you browse the table:
orders_status

you see the 4 Order Statuses for:
Pending
Processing
Delivered
UpdatedNo, this table is empty. In fact I noticed that when I wanted to pick out some entries for the various stages in my payment modules, the usual ones (Pending, Processing etc), were not there.

If you check the table:
orders

they have valid orders_status values?They all have the value 1, but the order_status table is empty so they don't correspond to anything.

Laszlo

Ajeh, I owe you:-)))

I went back to the shop I migrated from and copied the for entries over into the orders_status table and everything works:-)

My orders are visible with both the customer account and the admin page and the payment modules have different status entries.

Now if I managed to solve the coupon problem I have another thread running about, I'd be all sorted:-)

Thanks for the help.

Laszlo

You are most welcome ... I figured one of those had to be broken ...

Thanks for the update on what it was ... :smile: