[TYPO3-dev] Compare in 4.3 fails

[Dmitry Dulepov]

Hi!

Steffen Ritter wrote:
> install tool wants to make the following two changes in database which
> fail all the time because of to long indexes.
> " Specified key was too long; max key length is 1000 bytes"

Do you have multipyDbSize set to more than 1?

Side note: it does not make sense to have that index at all because it will never be used in real life: it is too long. MySQL will use full table scan if the index is that long and there is a lot of data. If it is just for uniqueness, it would make sense to wrap everything into transactional sql with checking the row for existance before inserting it.

> entry_namespace varchar(128) NOT NULL default '',
> entry_key varchar(255) NOT NULL default '',
...
> UNIQUE entry_identifier (entry_namespace,entry_key)

-- 
Dmitry Dulepov
Facebook: http://www.facebook.com/dmitryd
Twitter: http://twitter.com/dmitryd
Skype: liels_bugs