Page 1 of 12
Upgrade from 18.10.11 to 22.7.1
Posted: 09 Sep 2022, 10:26
by 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 6858 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.
Re: Upgrade from 18.10.11 to 22.7.1
Posted: 09 Sep 2022, 16:10
by 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).
Re: Upgrade from 18.10.11 to 22.7.1
Posted: 13 Sep 2022, 06:18
by 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?
Re: Upgrade from 18.10.11 to 22.7.1
Posted: 13 Sep 2022, 06:41
by aimeos
It should be possible to upgrade directly from any previous version.
Re: Upgrade from 18.10.11 to 22.7.1
Posted: 15 Sep 2022, 07:16
by 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 6770 times
I executed the wizard and get this error.
- wizard_error_1.png (29.57 KiB) Viewed 6770 times
The table after this.
- mshop_stock_error_1.png (18.42 KiB) Viewed 6770 times
I executed the wizard again and get this error.
- wizard_error_2.png (29.27 KiB) Viewed 6770 times
The table after this.
- mshop_stock_error_2.png (17.12 KiB) Viewed 6770 times
Re: Upgrade from 18.10.11 to 22.7.1
Posted: 15 Sep 2022, 09:52
by aimeos
There are some stock entries without existing products and you have to remove them first.
Re: Upgrade from 18.10.11 to 22.7.1
Posted: 15 Sep 2022, 10:11
by 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 6766 times
Also when I want to edit a product I get an error.
- error_product.png (37.22 KiB) Viewed 6766 times
Re: Upgrade from 18.10.11 to 22.7.1
Posted: 15 Sep 2022, 10:22
by 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.
Re: Upgrade from 18.10.11 to 22.7.1
Posted: 15 Sep 2022, 10:24
by Moritz
Okay, and what can I do now?
Or do you fix it in the upgrade wizard?
Re: Upgrade from 18.10.11 to 22.7.1
Posted: 15 Sep 2022, 10:28
by 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