Project

General

Profile

Actions
Copy link

Bug #81578

closed

sys_refindex CHANGE ref_string: Index column size too large

Added by Adrian Dymorz over 7 years ago. Updated about 6 years ago.

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

0%

Estimated time:
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

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Feature #84706: Database analyser can't detect index length changesClosed2018-04-12

Actions
Actions
Copy link

Also available in: Atom PDF