現在integer のカラムの型をstringに変更しようとしたのですがエラーが出てしまい行うことが出来ません
rails g migration change_datatype_user_id _ of _ user
class ChangeDatatypeuser_idofUsers < ActiveRecord::Migration[5.2] def change change_column :users, :user_Id,:string end end
rake aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::ConstraintException: FOREIGN KEY constraint failed: DROP TABLE "users" /Library/Ruby/Gems/2.3.0/gems/sqlite3-1.4.1/lib/sqlite3/resultset.rb:170:in `step' /Library/Ruby/Gems/2.3.0/gems/sqlite3-1.4.1/lib/sqlite3/resultset.rb:170:in `next_hash' /Library/Ruby/Gems/2.3.0/gems/sqlite3-1.4.1/lib/sqlite3/resultset.rb:105:in `next' /Library/Ruby/Gems/2.3.0/gems/sqlite3-1.4.1/lib/sqlite3/resultset.rb:133:in `each' /Library/Ruby/Gems/2.3.0/gems/sqlite3-1.4.1/lib/sqlite3/database.rb:202:in `to_a' /Library/Ruby/Gems/2.3.0/gems/sqlite3-1.4.1/lib/sqlite3/database.rb:202:in `block in execute' /Library/Ruby/Gems/2.3.0/gems/sqlite3-1.4.1/lib/sqlite3/database.rb:151:in `prepare' /Library/Ruby/Gems/2.3.0/gems/sqlite3-1.4.1/lib/sqlite3/database.rb:193:in `execute' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:255:in `block (2 levels) in execute' /Library/Ruby/Gems/2.3.0/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads' /Library/Ruby/Gems/2.3.0/gems/activesupport-5.2.3/lib/active_support/concurrency/share_lock.rb:187:in `yield_shares' /Library/Ruby/Gems/2.3.0/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:254:in `block in execute' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:581:in `block (2 levels) in log' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:580:in `block in log' /Library/Ruby/Gems/2.3.0/gems/activesupport-5.2.3/lib/active_support/notifications/instrumenter.rb:23:in `instrument' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:571:in `log' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:253:in `execute' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/schema_statements.rb:496:in `drop_table' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:421:in `move_table' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:413:in `block in alter_table' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:265:in `transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:412:in `alter_table' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:332:in `change_column' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:871:in `block in method_missing' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in `block in say_with_time' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in `say_with_time' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:860:in `method_missing' /Users/nakagawajo/nexceed/project/Tool_management/db/migrate/20190722064806_change_datatype_rf_idof_tools.rb:3:in `change' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:814:in `exec_migration' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:798:in `block (2 levels) in migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:797:in `block in migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in `with_connection' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:796:in `migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:977:in `migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1292:in `block in execute_migration_in_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1343:in `block in ddl_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `block in transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:239:in `block in within_new_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:236:in `within_new_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:267:in `transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/transactions.rb:212:in `transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1343:in `ddl_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1291:in `execute_migration_in_transaction' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1263:in `block in migrate_without_lock' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `each' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in `migrate_without_lock' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1212:in `migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1036:in `up' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/migration.rb:1011:in `migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/tasks/database_tasks.rb:172:in `migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <main>' /Library/Ruby/Gems/2.3.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>' Caused by: ActiveRecord::InvalidForeignKey: SQLite3::ConstraintException: FOREIGN KEY constraint failed: DROP TABLE "users" Caused by: SQLite3::ConstraintException: FOREIGN KEY constraint failed /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/tasks/database_tasks.rb:172:in `migrate' /Library/Ruby/Gems/2.3.0/gems/activerecord-5.2.3/lib/active_record/railties/databases.rake:60:in `block (2 levels) in <main>' /Library/Ruby/Gems/2.3.0/gems/rake-12.3.2/exe/rake:27:in `<top (required)>' Tasks: TOP => db:migrate
わかる方いればよろしくお願いしたします
回答2件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。