rails db:migrateを行うとエラーが出てしまう

Question

rails:migrate を行うとこちらのエラーが発生します。
解決方法がわかりません。

== 20200619124251 CreateItems: migrating ======================================
-- create_table(:items)
rails aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: Table 'fleamarket_sample_77a_development.categories' doesn't exist: SHOW FULL FIELDS FROM categories
/Users/okazakikeisuke/projects/fleamarket_sample_77a/db/migrate/20200619124251_create_items.rb:3:in change' /Users/okazakikeisuke/projects/fleamarket_sample_77a/bin/rails:9:in <top (required)>'
/Users/okazakikeisuke/projects/fleamarket_sample_77a/bin/spring:15:in <top (required)>' bin/rails:3:in load'
bin/rails:3:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: Table 'fleamarket_sample_77a_development.categories' doesn't exist: SHOW FULL FIELDS FROM categories
/Users/okazakikeisuke/projects/fleamarket_sample_77a/db/migrate/20200619124251_create_items.rb:3:in change' /Users/okazakikeisuke/projects/fleamarket_sample_77a/bin/rails:9:in <top (required)>'
/Users/okazakikeisuke/projects/fleamarket_sample_77a/bin/spring:15:in <top (required)>' bin/rails:3:in load'
bin/rails:3:in `<main>'

Caused by:
Mysql2::Error: Table 'fleamarket_sample_77a_development.categories' doesn't exist
/Users/okazakikeisuke/projects/fleamarket_sample_77a/db/migrate/20200619124251_create_items.rb:3:in change' /Users/okazakikeisuke/projects/fleamarket_sample_77a/bin/rails:9:in <top (required)>'
/Users/okazakikeisuke/projects/fleamarket_sample_77a/bin/spring:15:in <top (required)>' bin/rails:3:in load'
bin/rails:3:in `<main>'

Caused by:
Mysql2::Error: Cannot add foreign key constraint
/Users/okazakikeisuke/projects/fleamarket_sample_77a/db/migrate/20200619124251_create_items.rb:3:in change' /Users/okazakikeisuke/projects/fleamarket_sample_77a/bin/rails:9:in <top (required)>'
/Users/okazakikeisuke/projects/fleamarket_sample_77a/bin/spring:15:in <top (required)>' bin/rails:3:in load'
bin/rails:3:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
okazakikeisuke@okazakikeisukenoMacBook-Pro fleamarket_sample_77a %

解決方法が分かる方おられましたら教えていただきたいです。
よろしくお願いします。

Answer 1

外部キー制約を外すと解決しました。