Project

General

Profile

Actions

Defect #2966

closed

rake db:migrate fails with MySQL 6

Added by Fernando Silva about 16 years ago. Updated almost 12 years ago.

Status:
Closed
Priority:
Normal
Category:
Database
Target version:
-
Start date:
2009-03-13
Due date:
% Done:

100%

Estimated time:
Resolution:
Wont fix
Affected version:

Description

Hi all,

I'm a new redmine user and I followed the steps from Redmine Installation guide, everything went well until the command rake db:migrate RAILS_ENV="production" , after it the migratation starts but stop on the 91 step, see the error below:

-----
90 ChangeVersionsNameLimit: migrated (0.0470s) ===========================

91 ChangeChangesetsRevisionToString: migrating ===========================
-- change_column(:changesets, :revision, :string, {:null=>false})
rake aborted!
Mysql::Error: #42000Specified key was too long; max key length is 767 bytes: ALT
ER TABLE `changesets` CHANGE `revision` `revision` varchar(255) NOT NULL

(See full trace by running task with --trace)

C:\redmine-0.8.2>

I using a windows XP Pro, MySQL Server 6.0, rubygems-update (1.3.1),rake (0.8.4, 0.7.3),rails (2.2.2) with all dependecies installed correctly.

Is there any way to execute the other steps manually? because it still has until 101 right?

Please, could anyone help me?

Best regards,
Fernando

Actions

Also available in: Atom PDF