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 #1

Updated by Julien Savard over 1 year ago

  • Target version set to next-patchlevel
Actions #2

Updated by Stefan Bürk over 1 year ago

  • Status changed from New to Needs Feedback

@Julien Savard

- 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 ?

Actions #3

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.

Actions #4

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.

Actions #5

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
Actions #6

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

Actions

Also available in: Atom PDF