0

Hey guys, I want to add twitter-oauth functionality to my work. I have installed "omniauth-twitter" gem. When I try to run my migration, this is the error message

C:\Sites\omniauth-tutorial>rake db:migrate == 20160904075837 CreateUsers: migrating ====================================== -- create_table(:users) -- add_index(:users, :provider) rake aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLException: no such table: main.users: CREATE INDEX "index_users_on_ provider" ON "users" ("provider") C:/Sites/omniauth-tutorial/db/migrate/20160904075837_create_users.rb:10:in `block in change' C:/Sites/omniauth-tutorial/db/migrate/20160904075837_create_users.rb:3:in `change' C:in `migrate' ActiveRecord::StatementInvalid: SQLite3::SQLException: no such table: main.users: CREATE INDEX "index_users_on_provider" ON "users"("provider") C:/Sites/omniauth-tutorial/db/migrate/20160904075837_create_users.rb:10:in `block in change' C:/Sites/omniauth-tutorial/db/migrate/20160904075837_create_users.rb:3:in `change' C:in `migrate' SQLite3::SQLException: no such table: main.users C:/Sites/omniauth-tutorial/db/migrate/20160904075837_create_users.rb:10:in `block in change' C:/Sites/omniauth-tutorial/db/migrate/20160904075837_create_users.rb:3:in `change' C:in `migrate' Tasks: TOP => db:migrate (See full trace by running task with --trace) 

This is my migration file

class CreateUsers < ActiveRecord::Migration def change create_table :users do |t| t.string :provider, null: false t.string :uid, null: false t.string :name t.string :location t.string :image_url t.string :url add_index :users, :provider add_index :users, :uid add_index :users, [:provider, :uid], unique: true t.timestamps null: false end end end 

Pls any idea on how this can be solved???

1 Answer 1

2

You need to put the add_index commands after the create_table

class CreateUsers < ActiveRecord::Migration def change create_table :users do |t| t.string :provider, null: false t.string :uid, null: false t.string :name t.string :location t.string :image_url t.string :url t.timestamps null: false end add_index :users, :provider add_index :users, :uid add_index :users, [:provider, :uid], unique: true end end 
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.