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!
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 » 19 Sep 2022, 09:08

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
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 » 19 Sep 2022, 13:40

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?
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 » 20 Sep 2022, 08:13

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.
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 » 20 Sep 2022, 08:44

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?
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 » 20 Sep 2022, 11:05

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
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 » 20 Sep 2022, 12:58

Only installing the package does not solve the problem.
Should I manually change the siteId of the fe_users table?
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 » 20 Sep 2022, 13:56

You have to run the upgrade wizard again to migrate the site IDs in the fe_users table.
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 » 21 Sep 2022, 06:42

The IDs have not changed after executting 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: 6728
Joined: 01 Jan 1970, 00:00

Re: Upgrade from 18.10.11 to 22.7.1

Post by aimeos » 21 Sep 2022, 06:55

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 » 21 Sep 2022, 07:20

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

Post Reply