Rake Aborted: Pins?

Question

I am trying to learn Ruby, thus far have been breezing through for a few days but finally really stuck on this error message:

$ rake db:migrate
==CreatePins: migrating =====
--create_table<:pins>
rake aborted!
An error has occurred, this and all later migrations canceled:

SQLite3::SQLException: table "pins" already exists: CREATE TABLE "pins" <"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar<255>, "created_at" datetime, "updated_at" datetime> C:/users/xxx/xxx/xxx/xxx/xxx/xxx/##########_create_pins.rb:3:in 'change'
c:in 'migrate'
Tasks: TOP => db:migrate
<See full trace by running task with --trace>

I've tried rake db:rollback, rake db:rollback STEP=2, going into individual files and eliminating anything that has any resemblance to pins/pins table. Perhaps I did something wrong with git push or push heroku?? Thoughts?

Do you have data that you don't to loose? You could try to drop and-create the database if not. — Agis, Jan 22 '14 at 12:11
How do you do that? I have data I'd rather not lose though.. — user3223348, Jan 22 '14 at 12:16
On my localhost/3000 I get this message: Migrations are pending; run 'rake db:migrate RAILS_ENV=development' to resolve this issue. But it doesn't solve the issue when I run it... — user3223348, Jan 22 '14 at 12:17
reconstruct the table: http://stackoverflow.com/questions/19097558/pg-undefinedtable-error-relation-users-does-not-exist/19804714#19804714 — Малъ Скрылевъ, Jan 22 '14 at 12:35

score 2 · Accepted Answer · answered Jan 22 '14 at 13:23

2

Try rake db:reset i hope its work for you. If it not work than you have 2 migration file for same table pins delete anyone and again run rake db:reset

answered Jan 22 '14 at 13:23

Divyang Hirpara

998
4
23

score 0 · Answer 2 · answered Aug 22 '14 at 08:52

0

I have the same problem with you ,I work it out by adding "drop_table:pins" at my create_pins.rb

answered Aug 22 '14 at 08:52

Duoduo

1

Rake Aborted: Pins?

2 Answers2