pelle / oauth-plugin

Rails plugin for OAuth
http://stakeventures.com/articles/2009/07/21/consuming-oauth-intelligently-in-rails
MIT License
716 stars 216 forks source link

SQLite3::ConstraintException (column token is not unique): #97

Open bournenapster opened 12 years ago

bournenapster commented 12 years ago

i am getting this after getting redirected to roo_url in twitter oaut .

What is the root_url actually getting to ? and this error is occuringi tried a lot but cannot fix it ?any help?

Parameters: {"oauth_token"=>"8tzD7IiU3gDMmXWNdUNG9YaMosMzB57H10godoFUIMs", "oauth_verifier"=>"a2UASn1fuF3u0llu6c2uakM18VuOmSPrAqmNJz6gWIc", "id"=>"twitter"} User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 TwitterToken Load (0.1ms) SELECT "consumer_tokens".* FROM "consumer_tokens" WHERE "consumer_tokens"."type" IN ('TwitterToken') AND "consumer_tokens"."user_id" = 1 LIMIT 1 CALLBACK TwitterToken Load (0.2ms) SELECT "consumer_tokens".* FROM "consumer_tokens" WHERE "consumer_tokens"."type" IN ('TwitterToken') AND "consumer_tokens"."user_id" = 1 AND "consumer_tokens"."token" = '403266725-vXEf4Uj2NIguhTwqTMwJLRbLlFGn5reU1mCbcPjs' LIMIT 1 CACHE (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1 SQL (0.5ms) INSERT INTO "consumer_tokens" ("created_at", "secret", "token", "type", "updated_at", "user_id") VALUES (?, ?, ?, ?, ?, ?) [["created_at", Tue, 08 Nov 2011 05:18:49 UTC +00:00], ["secret", "EcCIjAQsa1UZIg7coiS0cEejVPJLNHh4sgBJM9U6G0"], ["token", "403266725-vXEf4Uj2NIguhTwqTMwJLRbLlFGn5reU1mCbcPjs"], ["type", "TwitterToken"], ["updated_at", Tue, 08 Nov 2011 05:18:49 UTC +00:00], ["user_id", nil]] SQLite3::ConstraintException: constraint failed: INSERT INTO "consumer_tokens" ("created_at", "secret", "token", "type", "updated_at", "user_id") VALUES (?, ?, ?, ?, ?, ?) Completed 500 Internal Server Error in 2046ms

SQLite3::ConstraintException (column token is not unique):