Project

General

Profile

Actions
Copy link

Bug #99808

closed

Upgrade to 11.5 fails with database exception "Data too long for column 'lang' at row 1"

Added by Christoph Ascherl almost 2 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2023-02-03
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
11
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Sprint Focus:

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

Download all files
Data too long for column lang.png (88.8 KB) Data too long for column lang.png Christoph Ascherl, 2023-02-03 14:30
be_users.lang.png (136 KB) be_users.lang.png Christoph Ascherl, 2023-02-03 14:30
analyze database structure - change fields.png (182 KB) analyze database structure - change fields.png Christoph Ascherl, 2023-02-03 14:51

Related issues 1 (1 open — 0 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
Copy link

Also available in: Atom PDF