I stumbled upon the same problem the other day when I migrated our server. I have created a merge request https://gitorious.org/gitorious/mainline/merge_requests/220 that should fix the migration (once the MR is completely created, which is taking unusually long...) Otherwise you can find the actual change in my clone of Gitorious here: https://gitorious.org/~saur/gitorious/saurs-mainline/commit/edaebc8129c851b574573041a1e6817c61c1f0b2
The problem for you, however, is that you will have to revert the part of the failed migration that actually took place before you can apply the corrected version (unless you can revert using backups). You will have to remove the content_type column from the project_memberships table.
//Peter
From: gito...@googlegroups.com [mailto:gito...@googlegroups.com] On Behalf Of Rodrig Lima
Sent: 30 October 2012 14:03
To: gito...@googlegroups.com
Subject: [gitorious] rake db:migrate error
Hi all,
This is my error:
git@maverick:~$ pwd
/var/www/gitorious
git@maverick:~$ bundle exec rake db:migrate
.
.
.
== AddProjectMemberships: migrating ==========================================
-- create_table(:project_memberships)
-> 0.0043s
-- add_index(:project_memberships, [:project_id, :member_id, :member_type], {:name=>"project_memberships_index"})
-> 0.0062s
== AddProjectMemberships: migrated (0.0110s) =================================
== MakeProjectMembershipPolymorphicOnSubject: migrating ======================
-- add_column(:project_memberships, :content_type, :string)
-> 0.0062s
rake aborted!
An error has occurred, all later migrations canceled:
Mysql::Error: Table 'gitorious_production.content_memberships' doesn't exist: SELECT * FROM `content_memberships`
(See full trace by running task with --trace)
=======================================================
with --trace
git@maverick:~$ bundle exec rake db:migrate --trace
(in /var/www/gitorious)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
== MakeProjectMembershipPolymorphicOnSubject: migrating ======================
-- add_column(:project_memberships, :content_type, :string)
rake aborted!
An error has occurred, all later migrations canceled:
Mysql::Error: Duplicate column name 'content_type': ALTER TABLE `project_memberships` ADD `content_type` varchar(255)
I'm following this steps: http://gitorious.org/gitorious/pages/DebianSqueezeInstallation
How can I fix it?
--
To post to this group, send email to gito...@googlegroups.com
To unsubscribe from this group, send email to
gitorious+...@googlegroups.com
-- best regards, Thomas Kjeldahl Nilsson http://gitorious.com
$ rake db:migrate
(in /var/www/vmubuntu09.tif.ti.com/gitorious)
== AddSuspendedAtToProjects: migrating =======================================
-- add_column(:projects, :suspended_at, :datetime, {:default=>nil})
rake aborted!
An error has occurred, all later migrations canceled:
Mysql::Error: Duplicate column name 'suspended_at': ALTER TABLE `projects` ADD `suspended_at` datetime DEFAULT NULL
(See full trace by running task with --trace)
$ mv db/migrate/20110223130355_add_suspended_at_to_projects.rb db/migrate/.20110223130355_add_suspended_at_to_projects.rb.bak