Upgrade from 18.10.11 to 22.7.1

[Moritz]

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.

[aimeos]

Thanks for investigating!
Can you please try aimeos/aimeos-core:2022.10.x-dev which includes the fixes?

[Moritz]

Is there a possibility to build a TER version by myself?
We use Typo3 in non composer mode.

[aimeos]

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

[Moritz]

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 (6.19 KiB) Viewed 2188 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 (43.4 KiB) Viewed 2188 times

[aimeos]

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?

[Moritz]

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

[aimeos]

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.

[Moritz]

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.

[Moritz]

Where can I debug to see which SQL is executed to retrieve the customers?