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

[Michael Stucki]

Committed to TYPO3_4-0 & Trunk.

- michael

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.
> 
> Additionally I had to add support for such key definitions in the database
> parser of t3lib_install.
> 
> Branches:
> TYPO3_4-0 / Trunk
> 
> Comments:
> Many thanks to Dmitry who helped me to fix this at T3DD06!
> 
> Bugtracker reference:
> n/A
> 
> - michael

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