railsのマイグレーションに関して

Question

railsを使用して簡単なアプリケーションの開発を進めているのですが、データベースにマイグレーションを行うと下記の様なエラーが発生してしまうのですがどこを改善すればよろしいでしょうか？？

syota0618:~/workspace/jobs (master) $ rails db:migrate
== 20171116145743 AddNameToMessages: migrating ================================
-- add_column(:messages, :name, :string)
rails aborted!
StandardError: An error has occurred, this and all later migrations canceled:

SQLite3::SQLException: no such table: messages: ALTER TABLE "messages" ADD "name" varchar
/usr/local/rvm/gems/ruby-2.4.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `initialize'
/usr/local/rvm/gems/ruby-2.4.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `new'
/usr/local/rvm/gems/ruby-2.4.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:91:in `prepare'
/usr/local/rvm/gems/ruby-2.4.0/gems/sqlite3-1.3.13/lib/sqlite3/database.rb:137:in `execute'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:251:in `block (2 levels) in execute'
/usr/local/rvm/gems/ruby-2.4.0/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:46:in `block in permit_concurrent_loads'
/usr/local/rvm/gems/ruby-2.4.0/gems/activesupport-5.1.4/lib/active_support/concurrency/share_lock.rb:185:in `yield_shares'
/usr/local/rvm/gems/ruby-2.4.0/gems/activesupport-5.1.4/lib/active_support/dependencies/interlock.rb:45:in `permit_concurrent_loads'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:250:in `block in execute'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:612:in `block (2 levels) in log'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:611:in `block in log'
/usr/local/rvm/gems/ruby-2.4.0/gems/activesupport-5.1.4/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract_adapter.rb:603:in `log'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:249:in `execute'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/schema_statements.rb:554:in `add_column'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:344:in `add_column'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:849:in `block in method_missing'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:in `block in say_with_time'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:818:in `say_with_time'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:838:in `method_missing'
/home/ubuntu/workspace/jobs/db/migrate/20171116145743_add_name_to_messages.rb:3:in `change'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:792:in `exec_migration'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:776:in `block (2 levels) in migrate'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:775:in `block in migrate'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:408:in `with_connection'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:774:in `migrate'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:953:in `migrate'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1230:in `block in execute_migration_in_transaction'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1298:in `block in ddl_transaction'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `block in transaction'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/transaction.rb:194:in `block in within_new_transaction'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/transaction.rb:191:in `within_new_transaction'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/abstract/database_statements.rb:235:in `transaction'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/transactions.rb:210:in `transaction'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1298:in `ddl_transaction'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1229:in `execute_migration_in_transaction'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1201:in `block in migrate_without_lock'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1200:in `each'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1200:in `migrate_without_lock'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1150:in `migrate'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:1007:in `up'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/migration.rb:985:in `migrate'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/tasks/database_tasks.rb:171:in `migrate'
/usr/local/rvm/gems/ruby-2.4.0/gems/activerecord-5.1.4/lib/active_record/railties/databases.rake:58:in `block (2 levels) in <top (required)>'
bin/rails:3:in `load'
bin/rails:3:in `<main>'
Tasks: TOP => db:migrate

エラー文の全文を記載しようと思ったのですが文字数の制限に引っかかってしまったので一部省略させて頂いています。
不足箇所がありましたらご指摘して頂けると助かります。

回答の方、よろしくお願いいたします。

Comments

[退会済みユーザー]

タグ java は不要だと思うが

[退会済みユーザー]

必要の無いタグは削除してください

Answer 1

no such table: messagesと書いていますので、messagesテーブルがありません。
先にcreate tableのマイグレーションを実行しましょう。

Comments

[Syota]

回答して頂いてありがとうございます！
tableのマイグレーションを実行してみます！！