Upgrade from 18.10.11 to 22.7.1

[aimeos]

We've added debug logging for delete/insert/update statements executed during the migration in this pre-release:
https://aimeos.org/fileadmin/download/a ... 3-pre4.zip

[Moritz]

With this prerelease you removed the string parsing in Aimeos\MShop\Order\Item\Standard so the type error with the relatedId come up again.

Where can I find the log?

Edit: Ah I get the output in the Upgrade Wizard. I only installed the prerelease.
I will take a look at it tomorrow.
Are the customers are loaded from fe_users or fe_users_list?

[aimeos]

Next pre-release with the changes from pre3:
https://aimeos.org/fileadmin/download/a ... 3-pre5.zip

Customers are from fe_users, the fe_users_list is only for assigning relations to customer records.

[Moritz]

I think I found the problem.
In the fe_users table there is a column "siteId".
For many users the value is set to "1", for the rest it's empty.
Only the users with an empty value in this column are displayed.
When I set the value to an empty string for a missing user, it is shown up in the list again.
Is this a bug or a wrong configuration in my system?

[aimeos]

The values in the siteid columns must be changed from e.g. "1" to "1." to work properly in the newer Aimeos versions.
There was a problem in the migration. Can you please try this package:
https://aimeos.org/fileadmin/download/a ... 3-pre6.zip

[Moritz]

Only installing the package does not solve the problem.
Should I manually change the siteId of the fe_users table?

[aimeos]

You have to run the upgrade wizard again to migrate the site IDs in the fe_users table.

[Moritz]

The IDs have not changed after executting the upgrade wizard.

[aimeos]

Can you please check why the site IDs are not migrated here?
- https://github.com/aimeos/ai-typo3/blob ... dTypo3.php
- https://github.com/aimeos/aimeos-core/b ... #L112-L149

[Moritz]

I think here https://github.com/aimeos/ai-typo3/blob ... o3.php#L49 the second condition should be negated?
The function never comes to the UPDATE part.