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

[Thomas Kieslich]

Am Fri, 2 Oct 2009 15:27:32 +0700 schrieb 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
>>

Hi
This works
CREATE TABLE sys_refindex (
hash varchar(32) NOT NULL default '',
tablename varchar(255) NOT NULL default '',
recuid int(11) NOT NULL default '0',
field varchar(40) NOT NULL default '',
flexpointer varchar(255) NOT NULL default '',
softref_key varchar(30) NOT NULL default '',
softref_id varchar(40) NOT NULL default '',
sorting int(11) NOT NULL default '0',
deleted tinyint(1) NOT NULL default '0',
ref_table varchar(128) NOT NULL default '',
ref_uid int(11) NOT NULL default '0',
ref_string varchar(200) NOT NULL default '',
PRIMARY KEY (hash),
KEY lookup_rec (tablename,recuid),
KEY lookup_uid (ref_table,ref_uid),
KEY lookup_string (ref_table,ref_string)
);

128 is in the ref_table