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

Michael Stucki michael at typo3.org
Thu Aug 24 17:29:11 CEST 2006

This is a SVN patch request.

When using multiplyDBfieldSize=2 the whole sys_refindex table cannot be 

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.

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.

TYPO3_4-0 / Trunk

Many thanks to Dmitry who helped me to fix this at T3DD06!

Bugtracker reference:

- michael
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sys_refindex_key_fix.diff
Type: text/x-diff
Size: 2153 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20060824/70308853/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20060824/70308853/attachment.pgp 

More information about the TYPO3-team-core mailing list