[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