VirtueMart 3.8 and category order

[vis18neu]

Hello. We have a large number of product categories that were manually ordered, but after upgrading shop to VM 3.8 this morning, category order was lost, they are all mixed up and we cannot figure out the logic behind the new order. Of course, we can reorder them again, but we are talking about 150+ categories, which is a time consuming process. Will we again loose the manually set order of categories when we upgrade VM the next time? Thanks.

[pinochico]

1. How fixed?

Export from DB to csv from backup DB.
Import to actually DB

cca 1-2 hours

2. Why create update on production (master) version?
We use sifistic system with git and branchies (devel, master, hotfix...) and two hostings - devel.xxxx.com + xxx.com

3.

Will we again loose the manually set order of categories when we upgrade VM the next time?

I don't know, VM 3.8 is new and you must testing

[vis18neu]

Thank you for your answer.

We always create backup before the upgrade but restoring the website from backup won't solve anything as we will still have to upgrade VirtueMart to the latest version. As for the backup DB - I thought that upgrades make changes to database, would it be possible to simply import DB from backup? Wouldn't that cause the problem with the latest VM version?

I'd like to understand why did this change / problem happen and whether I can expect the same problem with the next upgrades, then maybe we can find some solution to avoid it.

[pinochico]

I can't find why heappend, I think some people from VM DEV or some developer

So we use another system for creating eshop and our DB is backuped on our server every day - 2 months back. Then if I need load the crash DB Table or deleted info from DB Table, I download 1-X day backup and then compare the same collumn.
If you have, then you can make the same - load two CSV and compare - sorting by ID and copy value from one collumn (old DB Table) to another collumn (new DB Table).

I think - load backup DB and replace is not really right away