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: 118
Joined: 07 Nov 2018, 14:05

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 15 Sep 2022, 10:57

While executing the taxrate migration the taxrate column in mshop_price was decimal.
When the update SQL is executed it tries to insert the JSON in the decimal column what is resulting in 0.00
At the end of the upgrade wizard the column is varchar.
I think the change of the column type comes to late.

The column relatedid in mshop_order is of type varchar(36) with default ''.
In my case all entries has NULL in this column and not an empty string.
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: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 15 Sep 2022, 14:15

Thanks for investigating!
Can you please try aimeos/aimeos-core:2022.10.x-dev which includes the fixes?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

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

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 16 Sep 2022, 05:28

Is there a possibility to build a TER version by myself?
We use Typo3 in non composer mode.
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: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 16 Sep 2022, 08:06

Can you try this pre-release?
https://aimeos.org/fileadmin/download/a ... 3-pre3.zip

You can build them yourself if you checkout aimeos/aimeos-typo3, download Phing and execute:

Code: Select all

phing deploy
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

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

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 16 Sep 2022, 08:58

Thank's for the pre release. With it the upgrade wizard works fine!

But I have another problem.
After the upgrade some customers are missing.
I can click on every order and then "show customer" (the eye symbol).
After that I get an error that the customer is not found.
error_missing.png
error_missing.png (6.19 KiB) Viewed 163 times

I compared the old customer list (v18.10.11) with the new one (22.7.3-pre3) and can confirm that.
missing_customer.png
missing_customer.png (43.4 KiB) Viewed 163 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: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 16 Sep 2022, 09:09

It's not clear why customer records should be deleted. In the setup tasks, there's no such thing:
https://github.com/aimeos/ai-typo3/tree/master/setup

Can you investigate?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

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

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 16 Sep 2022, 09:24

I don't think that they're customers deleted.
In both versions the mshop_customers table are empty.
The customers came from the Typo3 Frontend Users as far as I know.
For example customer with ID 11 is available in both versions (as Frontend User), but are missing in the customer list of v22.7.x
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: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 16 Sep 2022, 09:31

No entries in the "fe_users_list" table shouldn't cause entries in "fe_users" to not show up. Are these customers in fe_users table marked as deleted? Please check the "fe_users" table of both versions for differences any try to find out why that happened.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

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

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 16 Sep 2022, 10:43

I can't recognice any differences between the fe_users tables, because you see the same table on both pictures.
Left is my VM with Typo3 v9 and Aimeos 18.10.11 and right is my VM with Typo3 v11 and Aimeos 22.7.3-pre after running the upgrade wizard.

I recogniced that mostly customers not found which have already ordered something.
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

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

Re: Upgrade from 18.10.11 to 22.7.1

Post by Moritz » 16 Sep 2022, 10:45

Where can I debug to see which SQL is executed to retrieve the customers?
Ubuntu 22.04.01
PHP 7.4.30
Typo3 v11.5.19 LTS
Aimeos web shop 22.10.4-pre2

Post Reply