chancemedia/mbzdb — Issue #39: init.pl option "create index" failed
Author: MLKiiwy
Created: 2011-12-06 08:56:55+00:00
State: open

Hi,

I have an issue with mbzdb.
When i try to create all the index on my database, i get :

Option: 5
The most time consuming option. This will apply indexing to your already loaded
database. If using PostgreSQL, apply the index after you load the raw data because
it is faster.... if you cancel, you can safely return by running this again.
Ready to proceed? (y/n): y
CREATE UNIQUE INDEX `artist_alias_idx_locale_artist` ON `artist_alias` (`artist`,`locale`(256))
DBD::mysql::db do failed: Specified key was too long; max key length is 767 bytes at src/functions.pl line 92, line 288.
SQL: 'CREATE UNIQUE INDEX `artist_alias_idx_locale_artist` ON `artist_alias` (`artist`,`locale`(256))'

Have you an idea, on how to fix this issue ?

thx,

ML