Upgrade from 18.10.11 to 22.7.1

Questions around the TYPO3 integration and plugins
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Moritz
Advanced
Posts: 119
Joined: 07 Nov 2018, 14:05

Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 09 Sep 2022, 10:26

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
error.png (29.52 KiB) Viewed 846 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.
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

User avatar
aimeos
Administrator
Posts: 6739
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 09 Sep 2022, 16:10

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).
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Moritz
Advanced
Posts: 119
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 13 Sep 2022, 06:18

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?
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

User avatar
aimeos
Administrator
Posts: 6739
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 13 Sep 2022, 06:41

It should be possible to upgrade directly from any previous version.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Moritz
Advanced
Posts: 119
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 15 Sep 2022, 07:16

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
mshop_stock_v18.png (16.05 KiB) Viewed 758 times

I executed the wizard and get this error.
wizard_error_1.png
wizard_error_1.png (29.57 KiB) Viewed 758 times
The table after this.
mshop_stock_error_1.png
mshop_stock_error_1.png (18.42 KiB) Viewed 758 times

I executed the wizard again and get this error.
wizard_error_2.png
wizard_error_2.png (29.27 KiB) Viewed 758 times
The table after this.
mshop_stock_error_2.png
mshop_stock_error_2.png (17.12 KiB) Viewed 758 times
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

User avatar
aimeos
Administrator
Posts: 6739
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 15 Sep 2022, 09:52

There are some stock entries without existing products and you have to remove them first.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Moritz
Advanced
Posts: 119
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 15 Sep 2022, 10:11

Perfect! Now the upgrade wizard was successfully.

When I click on the order overview tab I get this error.
error_order.png
error_order.png (37.05 KiB) Viewed 754 times

Also when I want to edit a product I get an error.
error_product.png
error_product.png (37.22 KiB) Viewed 754 times
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

User avatar
aimeos
Administrator
Posts: 6739
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 15 Sep 2022, 10:22

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.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Moritz
Advanced
Posts: 119
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 15 Sep 2022, 10:24

Okay, and what can I do now?
Or do you fix it in the upgrade wizard?
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

User avatar
aimeos
Administrator
Posts: 6739
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 15 Sep 2022, 10:28

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
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply