Bug #100697
open
Upgrade wizard "Migrate backend users' selected UI languages" does not work with missing DB compare
0%
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
Updated by Andreas Kienast over 1 year ago
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.
Updated by Thomas Hohn over 1 year ago
AFAIK the DatabaseUpdatedPrerequisite only looks for thing that should be added and not modifications
Updated by Georg Ringer over 1 year ago
- Has duplicate Bug #100057: Upgrade issue from v10 to v11 in legacy install with table be_users and column lang added
Updated by Riccardo De Contardi over 1 year ago
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.
Updated by Riccardo De Contardi over 1 year ago
- Has duplicate Bug #99808: Upgrade to 11.5 fails with database exception "Data too long for column 'lang' at row 1" added