Bug #99808
closed
Upgrade to 11.5 fails with database exception "Data too long for column 'lang' at row 1"
0%
Description
Upgrade from 10.4.34 to 11.5.22
Upgrade Wizard fails with database exception
(1/2) Doctrine\DBAL\Exception\DriverException
An exception occurred while executing 'UPDATE `be_users` SET `lang` = ? WHERE `uid` = ?' with params ["default", 74]: Data too long for column 'lang' at row 1
In fact, field be_users.lang is of VARCHAR but string to be updated ("default") has a length of 7. This does not work at all.
Woraround:
ALTER TABLE xxx.be_users MODIFY COLUMN lang VARCHAR;
where xxx is your database name.
Files
Updated by Christoph Ascherl almost 2 years ago
- File analyze database structure - change fields.png analyze database structure - change fields.png added
Remark: this step to update be_users.lang with value "default" while running upgrade wizard is probably not necessary at all as next step "Analyze database structure" sets default value accordingly to VARCHAR DEFAULT 'default' NOT NULL
see attachment.
Updated by Riccardo De Contardi 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 New to Closed
I close this issue as duplicate of #100697 please continue the discussion there. Thank you