Geek Answers Handbook

PGError: ERROR: email column user relationship already exists

I am developing a website on a local hosting and this is terrible. This morning I tried to push him towards the hero using the command "git push heroku master" and then "heroku run rake db: migrate". When I try to make the second, 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'

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

Previous migration affecting the user table:

 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

and

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

Thanks in advance!

Edit - replies to 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 . . .
+2
source share
1 answer

I found the answer to Offer migration by existing model .

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

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

More articles:


All Articles