Project

General

Profile

Actions

Defect #5229

closed

db:migrate fails from older redmine

Added by Marc Tooley about 15 years ago. Updated almost 15 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
2010-04-01
Due date:
% Done:

0%

Estimated time:
Resolution:
Cant reproduce
Affected version:

Description

After running the upgrade procedure in the docs/UPGRADING instruction set, when running:

bash-3.1$ rake db:migrate RAILS_ENV="production"

... I get a few successful notes of upgrade and then:

CreateGroupsUsers: migrating ============================================
-- create_table(:groups_users, {:id=>false})
rake aborted!
An error has occurred, all later migrations canceled:

Mysql::Error: Table 'groups_users' already exists: CREATE TABLE `groups_users` (`group_id` int(11) NOT NULL, `user_id` int(11) NOT NULL) ENGINE=InnoDB

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

I didn't grab the --trace because I was just interested in fixing it. Deleting that table (which was empty at the time) allowed me to successfully from the db:migrate once more and it just worked after that.

Since the fix seems simple enough, I didn't think it warranted a whole new re-import of the old data. But, if you really insist, I will.

It's from the Bitnami stack for 0.9.3-stable.

Actions

Also available in: Atom PDF