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

Michael Stucki michael at typo3.org
Sat Aug 26 11:54:45 CEST 2006


Franz Holzinger wrote:

>>>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 based on reading the code

Honestly, but I think that this change is too critical that it could be
approved by simply reading the code.

This is not only a change of the key length, but it also touches the
database parser (which I find hard to understand anyway...).

- michael
-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/



More information about the TYPO3-team-core mailing list