Project

General

Profile

Actions

Bug #93326

closed

Error while Auto-Update: Error: Index column size too large

Added by Stefan Froemken about 3 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Should have
Category:
Authentication
Target version:
Start date:
2021-01-20
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
7.2
Tags:
Complexity:
easy
Is Regression:
Yes
Sprint Focus:

Description

Hello,

one of our customer has installed TYPO3 10 on MySQL 5.6 with InnoDB. While using Auto-Update it results in

Error: Index column size too large. The maximum column size is 767 bytes.

I found following patch which may be the problem: https://github.com/TYPO3/TYPO3.CMS/commit/ef816532ef

VARCHAR (255) * UTF8 = 765 Bytes

But as UTF8-MB4 is new default we have to calculate:

VARCHAR (255) * UTF8-MB4 = 1020 Bytes, which is higher than the allowed 767 Bytes

I prefer to set this value to 190.

As TYPO3 11 requires at least MySQL 5.7 were we have a bigger allowed index the patch should only match TYPO3 10.


Related issues 3 (0 open3 closed)

Related to TYPO3 Core - Bug #93150: Update / change in Analyze Database StructureClosed2020-12-22

Actions
Related to TYPO3 Core - Task #93131: Increase session id db field sizeClosed2020-12-21

Actions
Related to TYPO3 Core - Bug #93329: Fresh install not workingClosed2021-01-20

Actions
Actions

Also available in: Atom PDF