Issue Bug Closed

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

Stefan Froemken 01/20/21, 13:04 updated 02/19/22, 17:08

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.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.