migrate_plugins error ( BLOB/TEXT column 'command' used in key specification without a key length)

[techzhou]

==  CreateGitCaches: migrating ================================================
-- create_table(:git_caches)
   -> 0.0033s
-- add_index(:git_caches, :command)
rake aborted!
An error has occurred, all later migrations canceled:

Mysql2::Error: BLOB/TEXT column 'command' used in key specification without a key length: CREATE  INDEX `index_git_caches_on_command` ON `git_caches` (`command`)

branch:2.0-migration redmine:2.0.3

[plsamuel]

I also had this error during installation of the 2.0-migration branch over redmine 2.0.3.

[oliwel]

You can comment out the line "add_index :git_caches, :command" in redmine_git_hosting/db/migrate/20091119162428_create_git_caches.rb and create the index in mysql yourself afterwards.