Project

General

Profile

Actions
Copy link

Bug #82080

closed

Indexes too large for some tables with utf8mb4

Added by Tobias Hüske over 7 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2017-08-11
Due date:
% Done:

100%

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

Description

Hey,

after performing an update from an clean TYPO3 7.6.21 to 8.7.4 (maybe also when installing a clean 8.7.4) the Database Analyzer shows the following error:

Specified key was too long; max key length is 3072 bytes.

The query "CREATE INDEX `getDomainStartPage` ON `sys_domain` (pid, hidden, domainName)" fails, because domainName has varchar(80).

utf8 works, utf8mb4 not. I think varchar(80) should be raised or the index limited - https://github.com/TYPO3/TYPO3.CMS/blob/b66275c83818ddc02bda04ab67c53bf901cad54d/typo3/sysext/frontend/ext_tables.sql#L163.

What do you think? :)

Best regards
Tobias

Related issues 3 (0 open — 3 closed)

Related to TYPO3 Core - Bug #82551: Upgrade Wizard DeadlockClosed2017-09-25

Actions
Related to TYPO3 Core - Feature #80398: Make default charset and collation for new tables configurableClosed2017-03-22

Actions
Related to TYPO3 Core - Bug #89169: Redirects indey key too long after source path increaseClosed2019-09-13

Actions
Actions
Copy link

Also available in: Atom PDF