Unable to Manage the categories - Prestashop 8.1.4

[djo1919]

Dear Prestashop Community,

After importing data from Old Store 1.6 to Prestashop 8.1.4 using a tool Migrator 4. I've been unabled to see the list of categories or even add new category to the list of categories (please see attached).
PS: Enabling debug mode doesn't show anything.
Do you have a solution for this?

Regards

[djo1919]

The Solution is :
This is the default SQL query for getting the Category overview:
SELECT COUNT(cp.id_product) AS products_count, c.id_category, c.id_parent, c.active, cl.name, cl.description, cs.position FROM ps_category c LEFT JOIN ps_category_lang cl ON c.id_category = cl.id_category AND cl.id_lang = 1 AND cl.id_shop = c.id_shop_default LEFT JOIN ps_category_shop cs ON c.id_category = cs.id_category AND cs.id_shop = 1 LEFT JOIN ps_category_product cp ON c.id_category = cp.id_category WHERE (c.id_category != '800') AND (c.id_parent = 2) AND (c.id_category != '800') AND (c.id_category != '800') GROUP BY c.id_category ORDER BY position asc LIMIT 50

Changing "c.id_parent = 2" to "c.id_parent = 1" shows the categories.

 

OR

 

Go to phpmyadmin > ps_category > replace Home category's ID with "2" instead of "1"