Admin page order display issue

[Picasso]

Hello,

 

We have 2 OS commerce websites selling the same products under different domain names. While switching servers for one of them, our tech guy erroneously connected "domain 1" to the database of "domain 2" and for a few hours, both websites were displaying exactly the same info (products, customers database, who's online, etc.)

 

Then this issue was fixed when we realized what had happened.

 

However, I have realized that since then, "domain 2" has been having the following issue: although we're getting orders notifications by email as usual, the orders are not displayed in the Admin > Customers > Orders page (the ./admin/orders.php) .

 

I checked the MySql database and went to the orders table, then "orders_id" field and saw that the orders were all there, so no orders were lost. But they are not displayed anymore, that's all, so we cannot issue an invoice, packing list, etc.

 

"Domain 1" has had no problem whatsoever (or so it seems :-)

 

Any suggestion on how to fix that problem?

 

Thank you!