Issue Bug Closed

#100057Upgrade issue from v10 to v11 in legacy install with table be_users and column lang

Julien Savard 03/01/23, 18:37 updated 06/29/23, 09:45

Description

Description :
When runing the upgrade Wizard the step “Execute database migrations on single rows” fails with : “Error : An exception occurred while executing ‘UPDATE `be_users` SET `lang` = ? WHERE `uid` = ?’ with params [“default”, 1]: Data too long for column ‘lang’ at row 1 / Data too long for column ‘lang’ at row 1”

Column “lang” from table “be_users” is a varchar(6) in Typo3 v10. Value “default” is 7 char.
Upgrade Wizard does not seems to change the “lang” column to a varchar (10) as it is when installing typo3 v11

Step to reproduce :
- Having a typo3 v10 legacy install
- Untar typo3_src-11.5.24.tar.gz in /var/www/html
- Remove symlink /var/www/html/public/typo3_src ( target = ../typo3_src-10.4.36 )
- Create symlink /var/www/html/public/typo3_src ( target = ../typo3_src-11.5.24 )
- touch /var/www/html/public/ENABLE_INSTALL_TOOL
- chown apache:apache ENABLE_INSTALL_TOOL
- run upgrade Wizard
- Create Missing Tables and Fields
- Click “Create Missing tables and fields“
- Click “Execute database migrations on single rows”

Workaround :
In DB run “ALTER TABLE be_users MODIFY lang varchar(10) DEFAULT ‘info’ NOT NULL;”

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.