[TYPO3-english] [TYPO3 english] 4.3.0beta1 ALTER TABLE sys_refindex ADD KEY lookup_string (ref_table,ref_string);

Rupert Germann rupi at gmx.li
Fri Oct 2 09:30:11 CEST 2009


Andreas Becker schrieb:
> After updating to 4.3.0beta1 we performed the update wizard and now tried a
> compare of all tables as otherwise we only receive error messages in front
> and backend.
> Unfortunately we can't alter:
> 
> *ALTER TABLE sys_refindex ADD KEY lookup_string (ref_table,ref_string);*
> 
> MySQL is complaining:
> 
> *#1071 - Specified key was too long; max key length is 1000 bytes*
> 
> How can we work around this problem or even bet get rid of it?

please change the key lenght of the key lookup string to 128 chars
in phpmyadmin

this bug is already known:
http://bugs.typo3.org/view.php?id=11867
http://bugs.typo3.org/view.php?id=11694

but it seems to happen only on utf-8 databases.

greets
rupert



More information about the TYPO3-english mailing list