Issue Bug Closed

#82080Indexes too large for some tables with utf8mb4

Tobias Hüske 08/11/17, 09:33 updated 10/02/18, 10:59

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

Reviews 1