pelle/oauth-plugin — Issue #105: Consumer_Tokens missing columns / Migrations issue in SQlite?
Author: tarr11
Created: 2011-12-24 19:21:00+00:00
State: open

i attempted to run rake db:migrate after generating the client, I received this error:

== CreateOauthConsumerTokens: migrating ======================================
-- create_table(:consumer_tokens)
rake aborted!
An error has occurred, this and all later migrations canceled:

SQLite3::SQLException: table "consumer_tokens" already exists: CREATE TABLE "consumer_tokens" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "type" varchar(30), "token" varchar(1024), "secret" varchar(255), "created_at" datetime, "updated_at" datetime)

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

Since this is a test app, i just reset my db and recreate it using rake db:create and then deleted this migration.

Then, the app worked, bu t it appears to have been expecting these columns authorized_at, invalidated_at, expires_at on consumer_tokens

I was able to resolve that issue by generating a migration myself.

rails generate migration AddTimestampsToConsumerTokens authorized_at:timestamp invalidated_at:timestamp expires_at:timestamp

rake db:migrate
Not sure if this is something that is either specific to SQLite, or something I may have done (I am using devise fwiw)