Upgrade from 18.10.11 to 22.7.1

[Moritz]

For our client we make a Typo3 upgrade from v9 to v11.
Because of this we also want upgrade Aimeos from 18.10.11 to current 22.7.1.
Is there any guideline for this in the documentation?

My first try was installing Aimeos 22.7.1 and start the upgrade wizard.
That fails with an error.

error.png (29.52 KiB) Viewed 6864 times

After that I tried installing every major version and execute the upgrade wizard each time.
That works but all relations from product to categories was lost.
Futhermore I get some exceptions that columns are set to null although the default value is string.

Maybe you can give me some advices to do such a big version jump.

[aimeos]

We've found and fixed the problem regarding the "key" syntax error and the missing categories.
If you update to aimeos/aimeos-core:2022.07.x-dev, you can test yourself.

The fixes will be included in the next release (probably next week).

[Moritz]

But it is possible to do an upgrade directly from 18.10.11 to 22.7.1?
Or should I execute the Upgrade Wizard for each major version?

[aimeos]

It should be possible to upgrade directly from any previous version.

[Moritz]

Thank you for the update!
I tried the upgrade wizard with the new version 22.7.2 and get errors for table mshop_stock.

Before the upgrade the table looks like this.

mshop_stock_v18.png (16.05 KiB) Viewed 6776 times

I executed the wizard and get this error.

wizard_error_1.png (29.57 KiB) Viewed 6776 times

The table after this.

mshop_stock_error_1.png (18.42 KiB) Viewed 6776 times

I executed the wizard again and get this error.

wizard_error_2.png (29.27 KiB) Viewed 6776 times

The table after this.

mshop_stock_error_2.png (17.12 KiB) Viewed 6776 times

[aimeos]

There are some stock entries without existing products and you have to remove them first.

[Moritz]

Perfect! Now the upgrade wizard was successfully.

When I click on the order overview tab I get this error.

error_order.png (37.05 KiB) Viewed 6772 times

Also when I want to edit a product I get an error.

error_product.png (37.22 KiB) Viewed 6772 times

[aimeos]

There seems to be a problem in migrating the columns because mshop_order.relatedid must be VARCHAR NOT NULL and mshop_price.taxrates a JSON-encoded array of key/value pairs.

[Moritz]

Okay, and what can I do now?
Or do you fix it in the upgrade wizard?

[aimeos]

Please check the columns in your database first. Afterwards, try to find out why the migration of the taxrates fails:
https://github.com/aimeos/aimeos-core/b ... axrate.php