Search code examples
mysqlruby-on-railsdevisemigration

Migration error with devise

Hey I have a problem with my page here. I used a gem 'devise' to create a migration file for "users" I might have forgotten to rake db:migrate after that but I'm really not too sure what I did here to duplicate anything.

I ran the code rails g devise user I may have forgotten to db:migrate and then ran the code rails g devise:views

It's for a TeamTreeHouse project, and I'm sorry if I was too confusing with my question...anyway here is the error message.

==  AddDeviseToUsers: migrating ===============================================

-- change_table(:users, :email) rake aborted! An error has occurred, this and all later migrations canceled:

SQLite3::SQLException: duplicate column name: email: ALTER TABLE "users" ADD "email" varchar(255) DEFAULT '' NOT NULL

Tasks: TOP => db:migrate (See full trace by running task with --trace)

Solution

  • It seems you already have an "users" table

    Try to run: rake db:reset to run your migrations after drop and recreate your database.

    UPDATE

    This command will clear all data you have stored (unless is present in your seeds.rb), be careful to use this if you have important data in your database.