Bug #93326

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

Added by Stefan Froemken 4 months ago. Updated 4 months ago.

Status:
New
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

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 workingNew2021-01-20

Actions
#1

Updated by Stefan Froemken 4 months ago

  • Related to Bug #93150: Update / change in Analyze Database Structure added
#2

Updated by Stefan Froemken 4 months ago

Just see in GIT BLAME that this issue is solved already

#3

Updated by Stefan Froemken 4 months ago

  • Related to Task #93131: Increase session id db field size added
#4

Updated by Steffen Mächtel 3 months ago

  • Related to Bug #93329: Fresh install not working added

Also available in: Atom PDF