Bug #56786
closedIndex on sys_file_processedfile is too large
100%
Description
Since #54234 a SQL error in the Upgrade Wizard / Database Compare is left open:
ALTER TABLE sys_file_processedfile ADD KEY identifier (storage,identifier);
Specified key was too long; max key length is 1000 bytes
"identifier" is varchar(512) but on utf8 charset every character needs 3 bytes of space. So the index is "too large" (for MyISAM).
Solution would be to limit the key to the first 332 chars.
Updated by Gerrit Code Review over 10 years ago
- Status changed from Accepted to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/28272
Updated by Gerrit Code Review over 10 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/28272
Updated by Ernesto Baschny over 10 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset aa1fb872471a1275a87f0dc433c48f97b800c6b7.
Updated by Gerrit Code Review over 10 years ago
- Status changed from Resolved to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/28429
Updated by Ernesto Baschny over 10 years ago
- Status changed from Under Review to Resolved
Applied in changeset 7d80f335cd8c93d86845a754177c5f0a71847f21.
Updated by Riccardo De Contardi almost 7 years ago
- Status changed from Resolved to Closed