[RC5 fixed]How to set the group access for all categories at one time?

[Guest]

PS 1.3.0.7

After I import categories by the same CSV file for twice, all the categories' Group access check box are set to null. Because of this I can not see any categories on my home page? I have more than 150 categories imported, which change all of their the Group access one by one would take a very long time?
Maybe delete all the existing categories and import one more time would help.
So I tried to delete all the categories, but when i import the CSV file, the same result.
Any ideas?

[rocky]

It might be worth posting this on the bug tracker. If updating existing categories using CSV messes up the categories group access, the PrestaShop team will want to know about it.

[Guest]

Well, I have reported this problem to Prestashop team.
Wish they can reproduce the problem.

[Guest]

Well, this bug has been fixed on SVN version at revision 2287, but i still don't know how to solve my problem.
Maybe I have to import the categories in 1.2.5.0 and then update the PS to 1.3.0.7.

[rocky]

PrestaShop v1.3 RC5 has just been released and includes this bug fix, so you should upgrade from v1.3 RC4 to RC5.

[Guest]

Thanks a lot.
Wish this is the last RC -_-'
I will check out this bug later.

[Денис]

if you don't want upgrade:

http://www.prestashop.com/bug_tracker/view/1286

SOLUTION FOR THIS PROBLEM:

open phpmyadmin and run this sql, worked for me and all categories were visible and accessible

INSERT INTO ps_category_group (id_category,id_group) SELECT id_category AS id_category, ‘1’ AS id_group FROM ps_category;



fixing:
in classes/Category.php after method public function updateGroup($list) place code:

   static public function categoryGroupFix()
   {
       Db::getInstance()->Execute("INSERT INTO "._DB_PREFIX_."category_group (id_category,id_group) SELECT  id_category AS id_category, '1' AS id_group FROM  "._DB_PREFIX_."category;");
   }

and in admin/tabs/AdminImport.php method categoryImport() after $this->closeCsvFile($handle); place code:

       Category::categoryGroupFix();