Project

General

Profile

Actions

Bug #20988

closed

Alter table "sys_refindex" is not possible if database is utf8

Added by Sven Juergens about 15 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Category:
-
Target version:
-
Start date:
2009-09-03
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.3
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

After an update from TYPO 4.2.8 to current trunk (5888), the following statement ist not possible if database is utf8

ALTER TABLE sys_refindex CHANGE ref_table ref_table varchar(255) default '';

Mysql Error:
#14729 - Specified key was too long; max key length is 1000 bytes

Solution could be the same like here:

Follow-up to #14729: Add a registry to t3lib - Limited the key field size to 128 chars to fit the UNIQUE key

(issue imported from #M11867)


Related issues 1 (0 open1 closed)

Is duplicate of TYPO3 Core - Bug #20867: Table sys_refindex / KEY lookup_string not UTF-8 compatibleClosedRupert Germann2009-08-12

Actions
Actions

Also available in: Atom PDF