Hi Rupert where do I need to enter the 128?? hmm not really working. I deleted those 133 in
*SQL query:* [image: Edit]<http://t3pack.com/phpmyadmin/tbl_sql.php??sql_query=ALTER+TABLE+%60thaipo3_bee%60.%60sys_refindex%60+DROP+INDEX+%60lookup_string%60%2C+ADD+INDEX+%60lookup_string%60+%28%60ref_table%60%2C+%60ref_string%60%29&show_query=1&db=thaipo3_bee&table=sys_refindex&token=7c35af120cb24d1dd90685609eac5275> ALTER TABLE `db_name`.`sys_refindex` DROP INDEX `lookup_string` , ADD INDEX `lookup_string` ( `ref_table` , `ref_string` ) *MySQL said: *[image: Documentation]<http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html> #1071 - Specified key was too long; max key length is 1000 bytes Any other idea Andi On Fri, Oct 2, 2009 at 2:30 PM, Rupert Germann <r...@gmx.li> wrote: > 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 > > _______________________________________________ > TYPO3-english mailing list > TYPO3-english@lists.netfielders.de > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english > _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.netfielders.de http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english