ps 1.7 product and category in DB but not in backoffice

[vs-consulting]

Hi every body,

I've got some probs with ma prestashop1.7

 

I just change a category (i change the parent).

And when i did it, the category disepear and also all products.

 

But when i check in the databas, the category exists (id 146) and all the products also exists bur nothing i my backoffice catalog??

 

How can i repair this problem?

 

Thanks for your help

Fabrice

[infisual]

if you made the change from db, then make sure the parent is Home (id for home) and the table category_shop has the ID for category and home as well