rails db:migrate エラー内容
rails
1== 20180830005803 AddPasswordDigestToUsers: migrating ========================= 2-- add_column(:users, :password_digest, :string) 3rails aborted! 4StandardError: An error has occurred, this and all later migrations canceled: 5 6SQLite3::SQLException: duplicate column name: password_digest: ALTER TABLE "users" ADD "password_digest" varchar 7C:/Users/maya7/sample_app/db/migrate/20180830005803_add_password_digest_to_users.rb:3:in `change' 8bin/rails:4:in `<main>' 9 10Caused by: 11ActiveRecord::StatementInvalid: SQLite3::SQLException: duplicate column name: password_digest: ALTER TABLE "users" ADD "password_digest" varchar 12C:/Users/maya7/sample_app/db/migrate/20180830005803_add_password_digest_to_users.rb:3:in `change' 13bin/rails:4:in `<main>' 14 15Caused by: 16SQLite3::SQLException: duplicate column name: password_digest 17C:/Users/maya7/sample_app/db/migrate/20180830005803_add_password_digest_to_users.rb:3:in `change' 18bin/rails:4:in `<main>' 19Tasks: TOP => db:migrate 20(See full trace by running task with --trace)
db\migrate\20180829180404_create_users.rb
db\migrate\20180829180404_create_users.rb
1class CreateUsers < ActiveRecord::Migration[5.2] 2 def change 3 create_table :users do |t| 4 t.string :name 5 t.string :email 6 7 t.timestamps 8 end 9 end 10end 11
db\migrate\20180830005641_add_index_to_users_email.rb
db\migrate\20180830005641_add_index_to_users_email.rb
1class AddIndexToUsersEmail < ActiveRecord::Migration[5.2] 2 def change 3 add_index :users, :email, unique: true 4 end 5end 6
db\migrate\20180830005803_add_password_digest_to_users.rb
class AddPasswordDigestToUsers < ActiveRecord::Migration[5.2] def change add_column :users, :password_digest, :string end end
自身で調べてはみたものの解決法がわからず困っています。
ご教授いただけないでしょうか。
ちなみにチュートリアルを進めていた中でのエラーであり右も左もわかりません。
rails db:migrate:resetも試してみましたが、下記のように表示されます。
Permission denied @ unlink_internal - C:/Users/maya7/sample_app/db/development.sqlite3 Couldn't drop database 'db/development.sqlite3' rails aborted! Errno::EACCES: Permission denied @ unlink_internal - C:/Users/maya7/sample_app/db/development.sqlite3 bin/rails:4:in `<main>' Tasks: TOP => db:drop:_unsafe (See full trace by running task with --trace)
回答1件
あなたの回答
tips
プレビュー