[Solved] Mystery: Database Out Of Step With Prestashop Back Office

[pchapple]

I have a strange situation, the back office doesn't match with the database.  If I change a product description in the back office, this isn't updated in product_lang but it does display correctly on the website.  Also, changing product prices in the database isn't reflected on the website or the back office.

 

If I check my orders and customers in the front office, then all the orders and customers for the last 7 months are not in the database.

 

I've talked to my VPS provider and the database in phpMyAdmin is the same one as the back office is connecting to.

 

I don't have any database caching that I am aware of and caching under Performance is switched off.

 

What is going on??!!  I'm completely stumped here.

 

Any advice will be gratefully received!

 

Thanks,

 

Piers.

 

Edited February 26, 2016 by pchapple (see edit history)

[pchapple]

After further conversations with the hoster it turned out that they hadn't updated WHM when they moved my server.  Funnily, all the old server is fully functional 7 months later!