Bug #81578

sys_refindex CHANGE ref_string: Index column size too large

Added by Adrian Dymorz 2 months ago. Updated 2 months ago.

Status:
Needs Feedback
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2017-06-14
Due date:
% Done:

0%

TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Database analyzer generates the following SQL command

ALTER TABLE sys_refindex CHANGE ref_string `ref_string` VARCHAR(1024) DEFAULT '' NOT NULL 
Current value: ref_string VARCHAR(200) DEFAULT '' NOT NULL COLLATE utf8_general_ci

which leads to the error message


Database update failed
Error: Index column size too large. The maximum column size is 767 bytes.

MariaDB Server version: 10.0.29-MariaDB-0+deb8u1
T3 8.7.1

History

#1 Updated by Adrian Dymorz 2 months ago

As a workaround, https://stackoverflow.com/a/30767600/7173655 helped.

ALTER TABLE sys_refindex ROW_FORMAT=DYNAMIC;

#2 Updated by Morton Jonuschat 2 months ago

  • Status changed from New to Needs Feedback

This is probably happening due to a dependency between the index and the alteration of the column. If you check the install tool you should see a change to the index as well (limiting the length of the prefix on ref_string). This change needs to be done before altering the column, then the update should work.

Also available in: Atom PDF