Categories exist and not exist - ...\Category\Exception\CategoryConstraintException code 6]

[leonidnk]

Hi,

I did migrate from 1.6 to 1.7.8.0 and got a working shop, but with a number of problems. Most important one - I cannot add new product or modify old one.

In "Main menu->Configure" and in "Catalog->Products" I can see Categories (see attachment), but in "Catalog->Categories" I cannot see categories. If I try to add any category I get error message: "PrestaShop\PrestaShop\Core\Domain\Category\Exception\CategoryConstraintException code 6]".

Please, help. Leonid.

Edited November 11, 2021 by leonidnk
I forgot screenshots. (see edit history)

[musicmaster]

Most likely this is a database problem. But I haven't seen this problem before and don't know what it might be.

Check the ps_category, ps_category_shop, ps_category_group and ps_shop tables.

If you want I can have a look. PM me if you want that.

[leonidnk]

2 hours ago, musicmaster said:

Most likely this is a database problem. But I haven't seen this problem before and don't know what it might be.

Check the ps_category, ps_category_shop, ps_category_group and ps_shop tables.

If you want I can have a look. PM me if you want that.

Thank you very much,

I already contacted the migration module support to solve the problem. For now I have to wait.