How to fix order associated with customer deleted?

[AWWWW.WAHWAH]

I have a customer who made an order. For some reason unknown, when you click on the customer and hit the order button, their order(s), present and past, should appear. But it does not for this one customer.

 

I can go through the order list(all customers orders) and the order is NOT there (visibilly) but if I type in the order number in the order field and hit enter, the order shows up?

 

Is there a way to fix this in the database?

[♥mdtaylorlrim]

When you find the order by number what name appears on the order? If there is none I can understand, if the name is correct then I don't see how this can happen.

 

If there is none then determine the customer number, then go to the order in the orders table of phpMyAdmin and enter the customer number in that order.

 

Otherwise, a lot more thinking and checking is going to be required.

[AWWWW.WAHWAH]

Thanks for your help. I'm not sure what happened but I went to the orders table and looked up the customer in mysql and found that the order status was 0. the order number was already in there. So I changed the order status to 3 for shipped the way i have it set up. it reassociated.

 

this problem has been solved. thanks.

[AWWWW.WAHWAH]

Ok I have another weird problem.

 

I have a customer who has made an order in the past. Fine.

 

He made another order recently. When I look up his order history it only shows one order, the newest order. His first order does not show up in his order history but I'm able to manually type the order number in admin to pull it up. Any reason for this?

 

This is not happening with any other customer.