#100697Upgrade wizard "Migrate backend users' selected UI languages" does not work with missing DB compare
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
-
Georg Ringer changed description <span data-processor="relativetime" data-value="2023-04-21T06:24:54+00:00" > 04/21/23, 06:24 </span>
-
Andreas Kienast commented <span data-processor="relativetime" data-value="2023-04-21T09:34:21+00:00" > 04/21/23, 09:34 </span>
-
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
-
Georg Ringer changed Duplicated by #100057 <span data-processor="relativetime" data-value="2023-05-10T07:52:40+00:00" > 05/10/23, 07:52 </span>
-
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-4As far as I have understood performing the database update operations before running the wizard helps avoiding the issue.
-
Riccardo De Contardi changed Duplicated by #99808 <span data-processor="relativetime" data-value="2023-06-29T09:48:27+00:00" > 06/29/23, 09:48 </span>
-
Georg Ringer commented and changed status
AcceptedClosed <span data-processor="relativetime" data-value="2026-02-12T11:10:42+00:00" > 02/12/26, 11:10 </span>guess now not needed anymore
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.