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 about 1 year 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.
#3 Updated by Riccardo De Contardi 9 months ago
- Status changed from Needs Feedback to Closed
90 days without feedback -> closing it.
If you think that this is the wrong decision or experience the issue again or have more information about how to reproduce it, please reopen it or open a new issue with a reference to this one. Thank you.