Missing subcategories after update 1.5.6.1 to 1.6.0.11

[genata93]

Hello,

today I updated my Prestashop store to version 1.6.0.11 with the 1-click-update module. 

Everything went smooth with the update and the store seemed to be working ok. I updated my modules and started configuring them. Now I notice that all my subcategories are not showing. Neither in front-office, nor in Back-office. I searched in google what the problem might be but nothing helped me. Display subcategories option in theme configuration is set to "Yes".

I decided to import my ps_category table, but first I went to phpMyAdmin and checked it. What I notice there is that all categories are in the table.

Can you please help me to figure it out what the problem is? I don't know if it is some bug with the update or some option that I need to configure.

 

[genata93]

Update:

 

On the attached file you can see an example of my categories. The imported one dont have position, while the one that i make as test has position. I think this is part of the problem.

 

The old categories dont have positions but have products assigned to them. Now if i click on Edit on category that dont have position I am being redirected to categories top... 

 

I am sure that after I updated prestashop I saw horizontal menus on index.php which means that the categories have been assigned one to another.. 

 

Please help me how to make my subcategories show up

[genata93]

Last update:

 

Problem is solved. I have changed the name of my store, and during that change I have not associated my subcategories to it. Now that I did this everything is back to normal. Prestashop is great ! 

 

Here are the steps that I did to manage this problem: 

BO -> Preferences -> Multistore -> On shop_id 1 click Edit -> Under associated categories click Expand all -> Check all -> Save

[alaksa]

insert into ps_category_shop
SELECT a.`id_category`,bb.id_shop,0
FROM `ps_category` as a
left join ps_category_shop aa on a.`id_category`=aa.`id_category`
left join ps_category as b on a.`id_parent`=b.`id_category`
left join ps_category_shop bb on b.`id_category`=bb.`id_category`
where a.id_parent>2 and aa.id_shop is null

This will restore subcategories for all shops where main categories are used and have no subcategory assigned to a shop.