[TYPO3-core] Bug for Kasper in sys_refindex table

Michael Stucki mstucki at snowflake.ch
Wed Mar 29 09:51:34 CEST 2006


Hi Kasper,

please have a look at the problem below:

The table sys_refindex contains a field ref_string, type varchar, length 200.
This field is part of the index "lookup_string".

The problem is that the usage of $TYPO3_CONF_VARS[SYS][multiplyDBfieldSize]=2 
changes this field type to "text" which breaks with the index setting 
(because indexes need a size limit but text fields don't have this).

This applies at least to MySQL. Suggestion is to remove the index or to change 
the field type.

- michael
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 191 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20060329/fbec8e81/attachment.pgp 


More information about the TYPO3-team-core mailing list