Categories block empty after I log in

[Shin_P]

Hello there.

I have this issue with PS now:

after I log in, the categories block is EMPTY!

I tried disable the dynamic stuff, uninstall the my account block.. but nothing!

Please help !

[rocky]

Edit each category and check the group permissions. Make sure that "Default" (and the customer group of the currently-logged-in customer) are ticked.

[Shin_P]

Thank you Rocky, you were right!

I had to manually give permission to my newly created group on each category & subcategories.. .. so slow!

It will be nice to have a recursive option for all the subcats!

[rocky]

The only faster way I can think of is to run an SQL query like this using phpMyAdmin:

DELETE FROM `ps_category_group` WHERE `id_group` = 1;
INSERT INTO `ps_category_group` SELECT `id_category`, 1 FROM `ps_category`;

Change ps_ to your database prefix and 1 to the ID of the group you want all categories to be in. This will delete all the existing categories from group 1, then put all categories in group 1.

Remember to make a backup of your ps_category_group table first in case anything goes wrong.

[mechell.baradillo]

Thanks rocky. I was looking for this solution for ages. This solution works.

Edited March 9, 2013 by mechell.baradillo (see edit history)