[TYPO3-dev] db key length conflicts

Dmitry Dulepov [typo3] dmitry at typo3.org
Wed Aug 22 11:52:33 CEST 2007


Hi!

Elmar Hinz wrote:
> when I use the DB compare tool of the installation tool, most problems
> result from key length conflicts of different extensions like dam or
> realurl.
> 
> Two examples:
> 
> ALTER TABLE tx_realurl_uniqalias ADD KEY bk_realurl02
> (tablename,field_alias,field_id,value_alias(230),expire);

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

> What is to do for the user? 

Nothing really... In case of realurl it is possible to decrease index 
part for value_alias but this will impact performance.

> What is to do for the extension maintainer?

Nothing really, because it is already fixed for multiplyDbSize=1 and you 
still can put multiplyDbSize to whatever you want (2, 10, 100, 10000) 
and get this error.

-- 
Dmitry Dulepov
TYPO3 freelancer / TYPO3 core team member
Web: http://typo3bloke.net/
Skype: callto:liels_bugs




More information about the TYPO3-dev mailing list