[TYPO3-core] RFC #11023: Table sys_refindex cannot be created with DBAL

[David Bruchmann]

> David Bruchmann wrote:
>>>> However, it is not possible to define a key on a text field because 
>>>> these have an undefined length while keys must not be longer than 
>>>> 1000 bytes. So thanks to this limiter, the key was valid again and 
>>>> sys_refindex could be created successfully.
>>> I'm sorry bringing up this item again but maximum amount of signs is 
>>> 133 for me with beta 1 (yesterday fetched from sourceforge).
>> Sorry,
>>
>> some additional Info:
>>
>> MySQL
>> utf8_unicode_ci
>> $TYPO3_CONF_VARS[SYS][multiplyDBfieldSize] = 1
> 
> What do you mean with maximum amount of signs is 133? You mean the index 
> is not created without length restriction? That's that? Then I guess you 
> upgraded a previous version of TYPO3 and you did not make a full fresh 
> install. This is normal as the index won't be recreated with unlimited 
> length. Just delete it from MySQL and TYPO3 will let you recreate it as 
> it should.
> 

Hi Xavier,

thanks, I deleted all Indexes, changed the fieldlength to 255 and made 
another DB-Check by Installtool.
Keeps one query that isn't proceeded because of max Index-Length:

ALTER TABLE sys_refindex ADD KEY lookup_string( ref_table, ref_string )

Best Regards
David