Ps 1.6.1.4 Messed Up Categories

[Kermit65]

Hi There

 

I am running Prestashop 1.6.1.4 and have issues recently (possibly after the automatic update to 1.6.1.4) to create any new or change existing products. I am getting error messages related to categories ("Article has to be in one category at least",  "Article has to be in the standard category" error messages translated from German).

 

Did I possibly mess up my categories?

 

I have in prstshp_categories 4 entries:

 

id_category id_parent is_root_category

1                  0              1

2                  0              1

12                2              0  (this is one of the categogies I am using)

13                2              0  (this is the other categorie I am using).

 

are these proper values for categories, in particular id 1 Root and id 2 Home?

Thank you in advance for your support,

Andreas

 

[Daresh]

Hi,

 

it's usually something like that:

 

id_category id_parent is_root_category

1                  0              0

2                  1              1

 

If you still have problems with categories this trick may help:

 

create a CSV file with two columns - ID category and ID parent. Fill it with your data and import in the BO (selecting force ID's). Other columns also matter for everything to be correctly displayed.

[Kermit65]

HI Daresh

 

thank you for the hint: I fixed the categories with ID 1 and 2 in mySQL.

 

It seems it fixed some of my issues and the hierarchy of categories is now properly displayed. Nevertheless, when I want to create a new product or change an existing one, I get two errors:

 

2 Fehler 

1. Der Artikel muss in mindestens einer Kategorie vorhanden sein.
2. Der Artikel muss in der Standard-Kategorie sein.

Any idea where I should look next?

Regards

Andreas

[musicmaster]

Did you assign your article to one or more categories? If you do not select one you would get this error.