Project

General

Profile

Actions

Bug #100057

closed

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

Added by Julien Savard over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2023-03-01
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
11
PHP Version:
7.4
Tags:
Complexity:
no-brainer
Is Regression:
Yes
Sprint Focus:
Needs Decision

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;"


Related issues 1 (1 open0 closed)

Is duplicate of TYPO3 Core - Bug #100697: Upgrade wizard "Migrate backend users' selected UI languages" does not work with missing DB compareAccepted2023-04-21

Actions
Actions

Also available in: Atom PDF