On 3/31/2021 at 1:36 PM, batevladi said:Hi Guys, if anyone does the same I did - i.e. migrated 1.3 or such to 1.7.7 here is my experience:
Did the transfer of category and _lang as well as the category_product linkage. However in the newer version, there is a "Root" category id = 1, which is not present in older versions of the database. So I had to modify it and create a "Home" category relating to id=1 and mark as root category then update the connections (id_parent) from id=1 to that new home category (for me I had space for id=2) and the depth needs to be managed accordingly (in my case I needed to increase all by one, leaving category 1 to depth of 0). If you are moving form version without category_shop table, you will need copy the content table category into that category_shop with the appropriate shop id (I only have the default =1). Also dont worry about the nleft and nright also position columns, those get updated by the system the moment you make a change to a category position in the Admin UI.
This re-arranged all the categories and showed them in the interface as well as in the shop.
Here is my 1.3 category table:
And here is my 1.7.7 category table:
Hope that helps someone else. 🙂
NB - to the post of @HackID1 (above) - I only have one category marked root - and that is my category 2 (the home category - not id=1 the root category)
Hi @batevladi!
I'm having the same issue after upgrading, but even I've made the same changes you said, my backoffice is still showing the category with id 1 and level_depth = 0 as root and the new one marked a is_root_category as a subcategory (I've also changed the PS_HOME_CATEGORY config to the new ID):
Is there something else I should do? I've tried everything and nothing have worked…