Skip to content


Subversion checkout URL

You can clone with
Download ZIP


Consumer_Tokens missing columns / Migrations issue in SQlite? #105

tarr11 opened this Issue · 1 comment

2 participants


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)


Had the same problem, in mysql. Your migration worked for me.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.