sys_refindex CHANGE ref_string: Index column size too large
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
#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.