[TYPO3-dev] db key length conflicts

[Elmar Hinz]

Dmitry Dulepov [typo3] wrote:

> 
> I guess it happens if you use multiplyDbSize (which you should not use
> any more).
> 

Right. That was still set to 2. 


Setting it to 1 and most problems can be solved. :-)


One problem remains:

ALTER TABLE tx_realurl_uniqalias ADD KEY bk_realurl02
(tablename,field_alias,field_id,value_alias(230),expire);

#1071 - Specified key was too long; max key length is 1000 bytes 


Same problem upon new installation of realurl:

CREATE TABLE tx_realurl_uniqalias(
uid int( 11 ) NOT NULL AUTO_INCREMENT ,
tstamp int( 11 ) NOT NULL default '0',
tablename varchar( 50 ) NOT NULL default '',
field_alias varchar( 30 ) NOT NULL default '',
field_id varchar( 30 ) NOT NULL default '',
value_alias varchar( 255 ) NOT NULL default '',
value_id int( 11 ) NOT NULL default '0',
lang int( 11 ) NOT NULL default '0',
expire int( 11 ) NOT NULL default '0',
PRIMARY KEY ( uid ) ,
KEY tablename( tablename ) ,
KEY bk_realurl01( field_alias, field_id, value_id, lang, expire ) ,
KEY bk_realurl02( tablename, field_alias, field_id, value_alias( 230 ) ,
expire )
) 

#1071 - Specified key was too long; max key length is 1000 bytes 


Regards

Elmar