Upgrade problem 2019.10 -> 2020.10

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!
nvindice
Posts: 27
Joined: 16 May 2019, 16:20

Upgrade problem 2019.10 -> 2020.10

Post by nvindice » 05 Aug 2021, 16:59

We have massive trouble with upgrading Aimeos on Typo3 v9.5.28 from Version 2019.10 -> 2020.10, managed via Composer.

As soon as the "aimeos" extension is activated, the Typo3 backend (and console) become unusable with the error message:
An exception occurred while executing 'SELECT `siteid`, `label`, `nleft`, `nright` FROM `mshop_locale_site` ORDER BY `nleft` ASC': Unknown column 'siteid' in 'field list'
We cannot run the aimeos database upgrade script because of this error. What can we do to fix this problem?

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

Re: Upgrade problem 2019.10 -> 2020.10

Post by aimeos » 06 Aug 2021, 06:47

We've backported a change from 2021 that should fix the problem. Can you install and test:

Code: Select all

composer req aimeos/aimeos-typo3:2020.10.x-dev
Background: TCA had been extended to associate a site ID to BE users.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

nvindice
Posts: 27
Joined: 16 May 2019, 16:20

Re: Upgrade problem 2019.10 -> 2020.10

Post by nvindice » 06 Aug 2021, 14:03

Worked, thanks alot!

Post Reply