[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