Bug #82080

Specified key was too long when creating an index

Added by Tobias Hüske 13 days ago.

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

0%

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

Also available in: Atom PDF