Rails: PG::UndefinedTable: ERROR: relation “…” does not exist

by

So the issue is happening because CreateOrganizations migration is being run before CreateActioncodes is executed.

CreateActioncodes is to be run first thereby ensuring that the action codes table exists.

The order in which migrations are run is based on the time stamp of the migration – as indicated in the name of the file. 20141014183645_create_users.rb will run before 20141014205756_add_index_to_users_email.rb as the timestamp of the second one – 20141014205756 is after that of the first one – 20141014183645.

Make sure the time-stamps of the CreateOrganizations migration is after that of CreateActioncodes migration.

Either you could manually change the timestamp in the file names. Or delete these migration files, and create them in the correct order.

More Related Contents:

  1. Add a reference column migration in Rails 4
  2. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  3. New data not persisting to Rails array column on Postgres
  4. Rails Migrations: tried to change the type of column from string to integer
  5. An error occurred while installing pg (0.17.1), and Bundler cannot continue
  6. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  7. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  8. How is attr_accessible used in Rails 4?
  9. Getting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails
  10. PG::ConnectionBad – could not connect to server: Connection refused
  11. Disable ActiveRecord for Rails 4
  12. ActiveRecord OR query Hash notation
  13. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  14. rescue_from ActionController::RoutingError in Rails 4
  15. Rails 4: before_filter vs. before_action
  16. Saving enum from select in Rails 4.1
  17. Rails 4 image-path, image-url and asset-url no longer work in SCSS files
  18. Rails 4: organize rails models in sub path without namespacing models?
  19. docker postgres with initial data is not persisted over commits
  20. Rails 4 nested attributes and has_many :through associaton in a form
  21. Can I write PostgreSQL functions on Ruby on Rails?
  22. Form Submit button only works after reload
  23. Rails naming convention for join table
  24. PostgreSQL: FATAL – Peer authentication failed for user (PG::ConnectionBad)
  25. Store the day of the week and time?
  26. ActionMailer not sending mail in development Rails 4
  27. strong parameters permit all attributes for nested attributes
  28. Changing the default date and time format in Rails 4
  29. How to integrate a Wrap Bootstrap theme into an Rails application?
  30. Specifying column name in a “references” migration

Leave a Comment