Bug #105515
closed
Database update failed: Specified key was too long; max key length is 1000 bytes
100%
Description
See screenshot below:
The table is of type MyISAM.
Key is UNIQUE KEY entry_identifier (entry_namespace,entry_key)
Both fields are varchar(128) and with the change from utf8mb3 to utf8mb4 this is now: (128 + 128) * 4 = 1024
The core fails to update the table to InnoDB.
Files
Updated by Benjamin Franzke 22 days ago
- Related to Task #104153: About "row size too large" added
Updated by Benjamin Franzke 22 days ago
We should add an upgrade wizard (or integrate as forced default into Database Analyzer) to migrate all tables to InnoDB,
as it turns out that our schema relies on that (we default to utf8mb4 in new installations and use key length that are not allowed with MyISAM).
…and then we should update sections like
https://docs.typo3.org/c/typo3/cms-core/main/en-us/Changelog/13.2/Important-104153-AboutDatabaseErrorRowSizeTooLarge.html#ensure-storage-engine-is-innodb
to be informative only and mention that this is auto-updated and has not to be checked manually by an integrator (less things to do manually, that'd be good!)
Updated by Gerrit Code Review 17 days ago
- Status changed from Accepted to Under Review
Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86878
Updated by Gerrit Code Review 17 days ago
Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86878
Updated by Gerrit Code Review 17 days ago
Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86878
Updated by Gerrit Code Review 17 days ago
Patch set 4 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86878
Updated by Gerrit Code Review 17 days ago
Patch set 5 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86878
Updated by Gerrit Code Review 17 days ago
Patch set 6 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86878
Updated by Gerrit Code Review 14 days ago
Patch set 7 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86878
Updated by Gerrit Code Review 14 days ago
Patch set 1 for branch 13.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/86904
Updated by Benjamin Franzke 14 days ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 571c153c12b10420a7f7809e3550605f603b111e.