[TYPO3-core] RFC: Fix sys_refindex problem when using multiplyDBfieldSize=2

Dmitry Dulepov typo3 at accio.lv
Fri Aug 25 14:45:34 CEST 2006


Michael Stucki wrote:
> This is a SVN patch request.
> Problem:
> When using multiplyDBfieldSize=2 the whole sys_refindex table cannot be 
> created.
> The reason for this is that the field "ref_string" is part of the key 
> "lookup_string". The field is defined to be varchar(200), and this is where 
> the problem occurs:
> multiplyDBfieldSize=2 changes the field type to "text", and since text fields 
> have no size limitation, it cannot be part of the key.
> Solution:
> Define the key to be only 199 characters long. For some reason it didn't work 
> with a length of 200 chars.

+1 since it was seen already on t3dd06...

Dmitry Dulepov

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)

More information about the TYPO3-team-core mailing list