Bug #100057
closedUpgrade issue from v10 to v11 in legacy install with table be_users and column lang
0%
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;"
Updated by Stefan Bürk over 1 year ago
- Status changed from New to Needs Feedback
- run upgrade Wizard - Create Missing Tables and Fields
Can you flip the steps / execution order of these two? To:
- Create Missing Tables and Fields - run upgrade Wizard
It's always good practice to do the (safe) part of the database compare (creating missing tables and fields and updates first. I guess the update wizards misses the database updated prerequisit, albit not looked.
Can you please try with changed order first ?
Updated by Julien Savard over 1 year ago
Not really... When i wrote "run upgrade Wizard" I meant : Open your browser, type in https://typo3_URL/install.php, write your password then after that, click on "Create Missing Tables and Fields" ans so on. Sorry if it wasn't clear enough.
Updated by Benni Mack over 1 year ago
Hey Julien,
I had the same error a few weeks ago. Updating the DB field first before running the upgrade wizards helped me.
Updated by Georg Ringer over 1 year ago
- Is duplicate of Bug #100697: Upgrade wizard "Migrate backend users' selected UI languages" does not work with missing DB compare added
Updated by Riccardo De Contardi over 1 year ago
- Status changed from Needs Feedback to Closed
- Target version deleted (
next-patchlevel)
I close this issue as duplicate of #100697 please continue the discussion there. Thank you