Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
MYSQL Error
samuelcolonsmbp:biller samuelcolon$ rake db:migrate
== 20140607212454 RemoveOldTables: migrating ==================================
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Table 'biller_development.customers' doesn't exist: SELECT `customers`.* FROM `customers`/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:301:in `query'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:301:in `block in execute'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:373:in `block in log'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activesupport-4.1.0/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:367:in `log'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:301:in `execute'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/mysql2_adapter.rb:232:in `exec_query'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/mysql2_adapter.rb:240:in `select'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:31:in `select_all'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:69:in `select_all'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/querying.rb:39:in `find_by_sql'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/relation.rb:603:in `exec_queries'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/relation.rb:487:in `load'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/relation.rb:231:in `to_a'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/relation/delegation.rb:46:in `each'
/Users/samuelcolon/workspace/biller/db/migrate/20140607212454_remove_old_tables.rb:3:in `up'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:598:in `exec_migration'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:579:in `block (2 levels) in migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:578:in `block in migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:577:in `migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:752:in `migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:992:in `block in execute_migration_in_transaction'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:1040:in `ddl_transaction'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:991:in `execute_migration_in_transaction'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:953:in `block in migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:949:in `each'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:949:in `migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:807:in `up'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:785:in `migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
ActiveRecord::StatementInvalid: Mysql2::Error: Table 'biller_development.customers' doesn't exist: SELECT `customers`.* FROM `customers`
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:301:in `query'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:301:in `block in execute'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:373:in `block in log'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activesupport-4.1.0/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:367:in `log'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:301:in `execute'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/mysql2_adapter.rb:228:in `execute'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/mysql2_adapter.rb:232:in `exec_query'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/mysql2_adapter.rb:240:in `select'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:31:in `select_all'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:69:in `select_all'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/querying.rb:39:in `find_by_sql'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/relation.rb:603:in `exec_queries'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/relation.rb:487:in `load'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/relation.rb:231:in `to_a'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/relation/delegation.rb:46:in `each'
/Users/samuelcolon/workspace/biller/db/migrate/20140607212454_remove_old_tables.rb:3:in `up'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:598:in `exec_migration'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:579:in `block (2 levels) in migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:578:in `block in migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:577:in `migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:752:in `migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:992:in `block in execute_migration_in_transaction'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:1040:in `ddl_transaction'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:991:in `execute_migration_in_transaction'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:953:in `block in migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:949:in `each'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:949:in `migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:807:in `up'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/migration.rb:785:in `migrate'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/railties/databases.rake:34:in `block (2 levels) in <top (required)>'
Mysql2::Error: Table 'biller_development.customers' doesn't exist
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:301:in `query'
/Users/samuelcolon/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:301:in `block in e
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment