Actions
Bug #93326
closedError while Auto-Update: Error: Index column size too large
Status:
Closed
Priority:
Should have
Assignee:
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.
Actions