PGError：ERROR：列“电子邮件”关系“用户”已经存在 [英] PGError: ERROR: column "email" of relation "users" already exists

问题描述

我一直在本地开发一个网站，并且更糟糕。今天早上，我试图用git push heroku master命令，然后是heroku run rake db：migrate把它推到heroku。当我尝试做第二个，我有一个错误：

I've been developing a website on localhost and it wors fine. This morning, I've tried to push it to heroku using the command "git push heroku master" and then "heroku run rake db:migrate". When I try to do the second one, I have an error:

Connecting to database specified by DATABASE_URL
Migrating to DeviseCreateUsers (20130427200347)
Migrating to CreateAuthentications (20130427210108)
Migrating to AddTokenToAuth (20130427233400)
Migrating to AddNotificationToAuth (20130427234836)
Migrating to AddNotifToUser (20130428031013)
Migrating to AddDeviseToUsers (20130712103048)
==  AddDeviseToUsers: migrating ===============================================
-- change_table(:users)
rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR:  column "email" of relation "users" already exists
: ALTER TABLE "users" ADD COLUMN "email" character varying(255) DEFAULT '' NOT N
sql_adapter.rb:652:in `async_exec'

我发现有同样问题的人（ heroku PGError：已经存在500我们很抱歉，但出了问题），但在我的情况下迁移AddDeviseToUsers不在'db / migrate'文件夹中。

I have found someone who had the same issue (heroku PGError: already exists 500 We're sorry, but something went wrong) but in my case the migration "AddDeviseToUsers" is not in the 'db/migrate' folder.

以前的影响用户的迁移表是：

Previous migration affecting users table are :

class DeviseCreateUsers < ActiveRecord::Migration
  def change
  create_table(:users) do |t|
  ## Database authenticatable
  t.string :email,              :null => false, :default => ""
  t.string :encrypted_password, :null => false, :default => ""

  ## Recoverable
  t.string   :reset_password_token
  t.datetime :reset_password_sent_at

  ## Rememberable
  t.datetime :remember_created_at

  ## Trackable
  t.integer  :sign_in_count, :default => 0
  t.datetime :current_sign_in_at
  t.datetime :last_sign_in_at
  t.string   :current_sign_in_ip
  t.string   :last_sign_in_ip

  ## Token authenticatable
  # t.string :authentication_token


  t.timestamps
end

add_index :users, :email,                :unique => true
add_index :users, :reset_password_token, :unique => true
end
end

和

class AddNotifToUser < ActiveRecord::Migration
 def change
  add_column :users, :notif, :string
 end
end

提前感谢

编辑 - 回答评论
当我运行：heroku run rake db：migrate：status

Edit - answering comments when I run : heroku run rake db:migrate:status

up     20130427200347  Devise create users
up     20130427210108  Create authentications
up     20130427233400  Add token to auth
up     20130427234836  Add notification to auth
up     20130428031013  Add notif to user
down    20130712103048  Add devise to users
down    20130719091217  Create relationships
.
.
.

推荐答案

我在设计现有模型上的迁移。

我做了什么在DeviseCreateUsers迁移中注释掉这一行：

What I did was to comment out this line in DeviseCreateUsers migration:

"t.string :email,              :null => false, :default => """ 

这篇关于PGError：ERROR：列“电子邮件”关系“用户”已经存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！