Issue Bug Closed

#100697Upgrade wizard "Migrate backend users' selected UI languages" does not work with missing DB compare

Georg Ringer 04/21/23, 06:23 updated 02/12/26, 11:10

Description

the upgrade wizard “Migrate backend users’ selected UI languages to new format.” does not work as long as the following change in the database compare is not done

ALTER TABLE `be_users` CHANGE `lang` `lang` VARCHAR(10) DEFAULT 'default' NOT NULL
Current value: lang VARCHAR(6) CHARACTER SET latin1 DEFAULT '' NOT NULL COLLATE `latin1_swedish_ci`

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

it would be great if the wizard could do the migration or at least checks it

Reviews 0

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

History 7

  1. Andreas Kienast commented <span data-processor="relativetime" data-value="2023-04-21T09:34:21+00:00" > 04/21/23, 09:34 </span>

    The migration is the reason the upgrade wizards depends on DatabaseUpdatedPrerequisite. I suspect that any code that should detect this missing change fails and suggest to investigate there.

  2. Thomas Hohn commented <span data-processor="relativetime" data-value="2023-04-21T10:17:28+00:00" > 04/21/23, 10:17 </span>

    AFAIK the DatabaseUpdatedPrerequisite only looks for thing that should be added and not modifications

  3. Riccardo De Contardi commented <span data-processor="relativetime" data-value="2023-06-29T09:47:50+00:00" > 06/29/23, 09:47 </span>

    See also:

    https://forge.typo3.org/issues/100057#note-2
    https://forge.typo3.org/issues/100057#note-4

    As far as I have understood performing the database update operations before running the wizard helps avoiding the issue.

  4. Georg Ringer commented and changed status Accepted Closed <span data-processor="relativetime" data-value="2026-02-12T11:10:42+00:00" > 02/12/26, 11:10 </span>

    guess now not needed anymore