i'm getting error in running rake db:migrate

Question

i had typed in cmd of ruby on rails command rails generate controller user name:string email:string once it is created when i type in rake db:migrate it shows error like this: C:\Sites\twinkle>rake db:migrate (in C:/Sites/twinkle) == CreateMembers: migrating ================================================== -- create_table(:members) rake aborted! An error has occurred, this and all later migrations canceled:

 SQLite3::SQLException: table "members" already exists: CREATE TABLE "members" ("
  id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "email" var
  char(255), "created_at" datetime, "updated_at" datetime)

what should i do?

First check whether members table already exists in your database? — Krishna Rani Sahoo, Jul 24 '13 at 07:03

score 3 · Answer 1 · answered Jul 24 '13 at 07:08

3

This error means you already have a table called 'members' in your database. Remove your Members table and try again. Rails can't 'overwrite' the table so you have to make a new one.

You can drop your table like this:

$rails console
ActiveRecord::Migration.drop_table(:members)

Now you can run rake db:migrate again. it will work now.

answered Jul 24 '13 at 07:08

Kees Sonnema

5,759
6
51
106

one more thing after bundle install i'm nt able to run annotate command – twinkle mehta Jul 24 '13 at 07:59
can u explain me what is annotate and why it is used – twinkle mehta Jul 24 '13 at 08:00
Annotate is removed you need to add this to your gemfile instead `gem 'annotate'` then run bundle install again :) – Kees Sonnema Jul 24 '13 at 08:02
Here's a tutorial: http://news.railstutorial.org/model-annotation/ if version `2.4.0`doesn't work use `gem 'annotate', '2.4.1.beta1'` – Kees Sonnema Jul 24 '13 at 08:08
also look at this. http://stackoverflow.com/a/9654727/1379394 – Kees Sonnema Jul 24 '13 at 08:10
when i write gem 'annotate' , '2.4.0' it shows error :while executing gem runtime error unknown command annotate – twinkle mehta Jul 24 '13 at 09:10
same type of error coming in 2.4.1.beta1 – twinkle mehta Jul 24 '13 at 09:14
Try doing a bundle update. – Kees Sonnema Jul 24 '13 at 09:15
that also i tried it is showing error could not find gem 'annotate-models(=1.0.4)' in any of the sources listed in your gemfile – twinkle mehta Jul 25 '13 at 14:21
You have to delete your gem annotate-models and add 'annotate' the annotate-models gem doesn't exist anymore. – Kees Sonnema Jul 26 '13 at 06:56

score 0 · Answer 2 · answered Jul 24 '13 at 07:02

0

Seems table members already exists.

Try removing the table from db

answered Jul 24 '13 at 07:02

Siva

7,780
6
47
54

score 0 · Answer 3 · edited May 23 '17 at 10:34

0

See this Rails DB Migration - How To Drop a Table? for drop your existing table

edited May 23 '17 at 10:34

Community

1
1

answered Jul 24 '13 at 07:06

visnu

935
6
16

i'm getting error in running rake db:migrate

3 Answers3