Skip to content

Instantly share code, notes, and snippets.

@carlcrott
Created November 16, 2012 01:22
Show Gist options
  • Save carlcrott/4083056 to your computer and use it in GitHub Desktop.
Save carlcrott/4083056 to your computer and use it in GitHub Desktop.
== AddMissingIndexes: migrating ==============================================
-- add_index(:citations, :user_id)
-> 0.6124s
-- add_index(:dbfiles, :created_user_id)
rake aborted!
An error has occurred, all later migrations canceled:
Mysql2::Error: Key column 'created_user_id' doesn't exist in table: CREATE INDEX `index_dbfiles_on_created_user_id` ON `dbfiles` (`created_user_id`)
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activesupport-3.2.9/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/connection_adapters/mysql2_adapter.rb:211:in `execute'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/schema_statements.rb:352:in `add_index'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:466:in `block in method_missing'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:438:in `block in say_with_time'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:438:in `say_with_time'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:458:in `method_missing'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:334:in `method_missing'
/home/thrive/rails_projects/ghgvc/db/migrate/20120725152632_add_missing_indexes.rb:6:in `up'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:370:in `up'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:410:in `block in migrate'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in `with_connection'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:389:in `migrate'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:528:in `migrate'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:720:in `block (2 levels) in migrate'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:777:in `call'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:777:in `ddl_transaction'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:719:in `block in migrate'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:700:in `each'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:700:in `migrate'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:570:in `up'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/migration.rb:551:in `migrate'
/home/thrive/.rvm/gems/ruby-1.9.3-p125@ghgvc/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:179:in `block (2 levels) in <top (required)>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
thrive@thrive-laptop:~/rails_projects/ghgvc$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment