Skip to content

Instantly share code, notes, and snippets.

@bsylvain
Last active December 11, 2015 17:28
Show Gist options
  • Save bsylvain/4634791 to your computer and use it in GitHub Desktop.
Save bsylvain/4634791 to your computer and use it in GitHub Desktop.
the migration
class AddInvoiceDateToContrat < ActiveRecord::Migration
def change
add_column :contrats, :invoice_date, :date
end
end
Mysql2::Error: Unknown column 'invoice_date' in 'order clause': SELECT `contrats`.* FROM `contrats` WHERE (automatic = true) ORDER BY invoice_date DESC LIMIT 1
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:243:in `query'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:243:in `block in execute'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:243:in `execute'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:211:in `execute'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:215:in `exec_query'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:224:in `select'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/querying.rb:38:in `block in find_by_sql'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/explain.rb:40:in `logging_query_plan'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/querying.rb:37:in `find_by_sql'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/relation.rb:171:in `exec_queries'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/relation.rb:160:in `block in to_a'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/explain.rb:33:in `logging_query_plan'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/relation.rb:159:in `to_a'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/relation/finder_methods.rb:378:in `find_first'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activerecord-3.2.6/lib/active_record/relation/finder_methods.rb:122:in `first'
/home/sylario/ruby/place_de_marche/app/models/contrat.rb:15:in `<class:Contrat>'
/home/sylario/ruby/place_de_marche/app/models/contrat.rb:2:in `<top (required)>'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:469:in `load'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:469:in `block in load_file'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:639:in `new_constants_in'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:468:in `load_file'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:353:in `require_or_load'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:502:in `load_missing_constant'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:192:in `block in const_missing'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:190:in `each'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:190:in `const_missing'
/home/sylario/ruby/place_de_marche/app/admin/contrat.rb:1:in `<top (required)>'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:245:in `load'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:245:in `block in load'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:236:in `load_dependency'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:245:in `load'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activeadmin-0.5.0/lib/active_admin/application.rb:182:in `block in load!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activeadmin-0.5.0/lib/active_admin/application.rb:182:in `each'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activeadmin-0.5.0/lib/active_admin/application.rb:182:in `load!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activeadmin-0.5.0/lib/active_admin/application.rb:205:in `routes'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activeadmin-0.5.0/lib/active_admin.rb:79:in `routes'
/home/sylario/ruby/place_de_marche/config/routes.rb:3:in `block in <top (required)>'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/actionpack-3.2.6/lib/action_dispatch/routing/route_set.rb:282:in `instance_exec'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/actionpack-3.2.6/lib/action_dispatch/routing/route_set.rb:282:in `eval_block'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/actionpack-3.2.6/lib/action_dispatch/routing/route_set.rb:260:in `draw'
/home/sylario/ruby/place_de_marche/config/routes.rb:1:in `<top (required)>'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:245:in `load'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:245:in `block in load'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:236:in `load_dependency'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:245:in `load'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/application/routes_reloader.rb:40:in `block in load_paths'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/application/routes_reloader.rb:40:in `each'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/application/routes_reloader.rb:40:in `load_paths'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/application/routes_reloader.rb:16:in `reload!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/application.rb:108:in `reload_routes!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activeadmin-0.5.0/lib/active_admin/reloader.rb:34:in `reload!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activeadmin-0.5.0/lib/active_admin/reloader.rb:61:in `block in attach!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/callbacks.rb:429:in `_run__644705876__prepare__606623776__callbacks'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/callbacks.rb:405:in `__run_callback'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/callbacks.rb:385:in `_run_prepare_callbacks'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/callbacks.rb:81:in `run_callbacks'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/actionpack-3.2.6/lib/action_dispatch/middleware/reloader.rb:74:in `prepare!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/actionpack-3.2.6/lib/action_dispatch/middleware/reloader.rb:48:in `prepare!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/application/finisher.rb:47:in `block in <module:Finisher>'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/initializable.rb:30:in `instance_exec'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/initializable.rb:30:in `run'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/initializable.rb:55:in `block in run_initializers'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/initializable.rb:54:in `each'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/initializable.rb:54:in `run_initializers'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/application.rb:136:in `initialize!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/railtie/configurable.rb:30:in `method_missing'
/home/sylario/ruby/place_de_marche/config/environment.rb:5:in `<top (required)>'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:251:in `require'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:251:in `block in require'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:236:in `load_dependency'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/activesupport-3.2.6/lib/active_support/dependencies.rb:251:in `require'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/application.rb:103:in `require_environment!'
/usr/local/rvm/gems/ruby-1.9.2-p136/gems/railties-3.2.6/lib/rails/application.rb:292:in `block (2 levels) in initialize_tasks'
Tasks: TOP => db:migrate => environment
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment