Defect #6329
closed
Upgrade redmine from 0.8.7 to 1.0.0
0%
Description
I have a problem when I excute the step4
Step 4 - Update the database¶
This step is the one that could change the contents of your database. Go to your new redmine directory, then migrate your database:
rake db:migrate RAILS_ENV=production
I meet an error:a member_roles table already created. Then I rename the member_roles table to member_roles_saved as the upgrade guide told. Then restart the command:rake db:migrate RAILS_ENV=production . But a new error come up: mysql::Error: Can't create table '.\bitnami_redmine\member_roles.frm'<error 121>:CRTATE TABLE 'member_roles' <'id' int<11> DEFAULT NULL auto_increment PRIMARY KEY, 'member_id' int<11> NOT NULL, 'role_id' int<11> NOT NULL> ENGINE=InnoDB
Please help me to resolve the problem.
Thanks very much.
Updated by Felix Schäfer over 14 years ago
- Category deleted (
Database) - Status changed from New to Closed
- Priority changed from Urgent to Normal
- Resolution set to Invalid
This tracker is only for bugs and feature requests, not for help with installation or upgrade, please visit the forums for help with that.
As to your problem: it seems to be either a misconfiguration of mysql or a permission problem with it. Either way, that error:
Can't create table '.\bitnami_redmine\member_roles.frm'<error 121>:CRTATE TABLE 'member_roles' <'id' int<11> DEFAULT NULL auto_increment PRIMARY KEY, 'member_id' int<11> NOT NULL, 'role_id' int<11> NOT NULL> ENGINE=InnoDB
is a MySQL error, so have a look that way.
Last but not least: it seems you have installed the bitnami package, they might be in better position to help you than us.