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

[Xavier Perseguers]

Hi,

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.

HTH

-- 
Xavier Perseguers
MVC ExtJS Leader

http://forge.typo3.org/projects/show/extension-mvc_extjs