Categories disappeared from BO

[kmorgen]

Hi

 

I was just editing some text in on of the categories (PS 1.6.1.6) and when saved, all categories are now missing in BO. Everything still works in FO.

 

If I create/delete a new category and save, I can temporarily see all of them, but if clicking "go back to list" or just click "Category" in Menu it will not show any categories. So it seem to be a root listing issue in BO.

 

I remember it also had similar problem when updating from 1.5 to 1.6, and solved it by changing a value in the database, and it's been working ever since. However this time I can't figure out how to solve it, and apparently this scenario is a common issue discussed since 1.4

 

Anybody know how to fix this?

[sandipchandela]

Yes Kim, 

You are right.

Its issue related with root category.

 

Table ps_category first two row should be like follows:

 

id_category id_parent id_shop_default level_depth nleft nright active date_add date_upd position is_root_category

1                  0  1  0  1  25                     1                                               2016-04-16 16:33:37 2016-04-16 16:33:37 0 0         

2                  1  1  1  2  26                     1                                              2016-04-16 16:33:37 2016-04-16 16:33:37 0 1        

 

Sory  abt d formatting

 

Regards

Edited July 16, 2016 by archSandy (see edit history)

[kmorgen]

Hmm, tried to edit some with no effect.

 

This is how mine looks by default:

 

id_category id_parent id_shop_default level_depth nleft nright active date_add date_upd position is_root_category

1                    0                1                           0                    1       30         1                                              1              0

5                    1                1                           1                    22     23         1                                               6             0 

6                    1                1                           1                    20     21         1                                               5             0

Edited July 19, 2016 by kmorgen (see edit history)

[musicmaster]

In a shop that is upgraded from 1.4 like yours the id_category of the root will always be a rather high number as it is only added with the upgrade. This shouldn't cause any problems.

 

Editing the category table without knowing what you do is strongly discouraged.

[sandipchandela]

yes do agree with d music master.

don't change on the category or any table in db!

 

Table looks fine as of now except missing one column.

There may be migration issue in the category classes or how works in category admin grid ?

[kmorgen]

I don't think I am missing any column? I just left out the date content (I have edited the formatting in the post, so it is more readable)

 

So I'm a bit stuck. All categories disappeared in BO after I just edited some regular category text in BO, not in the DB.
So it was just by saving this, I no longer have any categories listed in BO.

 

I just checked the categories in Prestools and it appears like this:

 

ID  Parent       Position active description

14  Root          0            0        1

1    Products   0            1        1

23  Bluetooth  1            0        1

24  Accessory 2           1        1

 

So appears I have a Root category id 14??

 

 

So any ideas how I get the Category tree back in BO?

 

Seems to be a common bug discussed for years, but really never seem to be actually solved?

Edited July 19, 2016 by kmorgen (see edit history)

[musicmaster]

As I said before, it is normal to have a higher id number for the root when you have an upgrade from 1.4. 1.4 doesn't have a Root - it only has a Home. The Root was only added in 1.5 with the multishop to have something above all the Homes. Obviously you had some 13 categories at that time.

 

You say that it seems to be a common bug. Can you point to other people who had the same?

 

I suggest that you start by making a backup of your database. That gives you some freedom to experiment.

[kmorgen]

Have not been able to solve this, so frustrating!

 

Does anybody know if I can just replace these 5 tables with a backup, and it should be like before again (even though have no clue why the problem even occurred in the first place, by just editing and saving some category text in BO)?

 

ps_category

ps_category_group

ps_category_lang

ps_category_product

ps_category_shop

 

My concern if other tables are also affected, so it might screw up something else. 

 

When comparing with a backup, I can see the level_depth seem to have jumped on number on all of them (1 became 2 etc). Also nleft and nright seem to be different.

 

PS. I just googled the issue, and seem through time several have experienced the category tree to be missing in BO for various versions, but no really proper solution/explanation.

Edited August 2, 2016 by kmorgen (see edit history)

[musicmaster]

Does anybody know if I can just replace these 5 tables with a backup, and it should be like before again (even though have no clue why the problem even occurred in the first place, by just editing and saving some category text in BO)?

 

ps_category

ps_category_group

ps_category_lang

ps_category_product

ps_category_shop

 

I think that you have a good chance that it will work. Just make sure that you make a backup of the database before you start. If if doesn't work out you can then put that back.

[sandipchandela]

Have not been able to solve this, so frustrating!

 

Does anybody know if I can just replace these 5 tables with a backup, and it should be like before again (even though have no clue why the problem even occurred in the first place, by just editing and saving some category text in BO)?

 

ps_category

ps_category_group

ps_category_lang

ps_category_product

ps_category_shop

 

My concern if other tables are also affected, so it might screw up something else. 

 

When comparing with a backup, I can see the level_depth seem to have jumped on number on all of them (1 became 2 etc). Also nleft and nright seem to be different.

 

PS. I just googled the issue, and seem through time several have experienced the category tree to be missing in BO for various versions, but no really proper solution/explanation.

kim all the best.

With the advancement of category algorithm i dont think so it will messed up when you go for change.

[kmorgen]

I have now copied the 5 tables from a previous DB backup, and all the categories shows again in BO.

I also seem to be able to edit a sub category without problems. However if I edit the Home category they will all dissappear again from BO, so there must be a bug somewhere.