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

[Andreas Becker]

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 <rupi at 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 at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>