Skip to content

Instantly share code, notes, and snippets.

@oguzcanhuner
Last active September 16, 2015 13:59
Show Gist options
  • Save oguzcanhuner/4f4a8e4672e387b83f49 to your computer and use it in GitHub Desktop.
Save oguzcanhuner/4f4a8e4672e387b83f49 to your computer and use it in GitHub Desktop.
PG::UndefinedColumn: ERROR: column "printhouse_sla" of relation "spree_stock_locations" does not exist
LINE 1: UPDATE "spree_stock_locations" SET "printhouse_sla" = 2 WHER...
^
: UPDATE "spree_stock_locations" SET "printhouse_sla" = 2 WHERE "spree_stock_locations"."id" = $1/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:641:in `prepare'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:641:in `prepare_statement'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:600:in `exec_cache'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:589:in `execute_and_clear'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:173:in `exec_delete'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:114:in `update'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/relation.rb:345:in `update_all'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/persistence.rb:299:in `update_columns'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/persistence.rb:273:in `update_column'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:46:in `block (2 levels) in up'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:45:in `each'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:45:in `block in up'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/relation/delegation.rb:46:in `each'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/relation/delegation.rb:46:in `each'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:41:in `up'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:608:in `exec_migration'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:589:in `block (2 levels) in migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:588:in `block in migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:587:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:765:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:995:in `block in execute_migration_in_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:1041:in `block in ddl_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/transactions.rb:220:in `transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:1041:in `ddl_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:994:in `execute_migration_in_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:956:in `block in migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:952:in `each'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:952:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:820:in `up'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:798:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/Users/Huner/.rvm/gems/ruby-2.1.6/bin/ruby_executable_hooks:15:in `eval'
/Users/Huner/.rvm/gems/ruby-2.1.6/bin/ruby_executable_hooks:15:in `<main>'
ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column "printhouse_sla" of relation "spree_stock_locations" does not exist
LINE 1: UPDATE "spree_stock_locations" SET "printhouse_sla" = 2 WHER...
^
: UPDATE "spree_stock_locations" SET "printhouse_sla" = 2 WHERE "spree_stock_locations"."id" = $1
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:641:in `prepare'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:641:in `prepare_statement'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:600:in `exec_cache'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:589:in `execute_and_clear'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:173:in `exec_delete'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:114:in `update'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/relation.rb:345:in `update_all'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/persistence.rb:299:in `update_columns'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/persistence.rb:273:in `update_column'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:46:in `block (2 levels) in up'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:45:in `each'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:45:in `block in up'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/relation/delegation.rb:46:in `each'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/relation/delegation.rb:46:in `each'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:41:in `up'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:608:in `exec_migration'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:589:in `block (2 levels) in migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:588:in `block in migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:587:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:765:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:995:in `block in execute_migration_in_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:1041:in `block in ddl_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/transactions.rb:220:in `transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:1041:in `ddl_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:994:in `execute_migration_in_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:956:in `block in migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:952:in `each'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:952:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:820:in `up'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:798:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/Users/Huner/.rvm/gems/ruby-2.1.6/bin/ruby_executable_hooks:15:in `eval'
/Users/Huner/.rvm/gems/ruby-2.1.6/bin/ruby_executable_hooks:15:in `<main>'
PG::UndefinedColumn: ERROR: column "printhouse_sla" of relation "spree_stock_locations" does not exist
LINE 1: UPDATE "spree_stock_locations" SET "printhouse_sla" = 2 WHER...
^
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:641:in `prepare'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:641:in `prepare_statement'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:600:in `exec_cache'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql_adapter.rb:589:in `execute_and_clear'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/postgresql/database_statements.rb:173:in `exec_delete'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:114:in `update'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/relation.rb:345:in `update_all'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/persistence.rb:299:in `update_columns'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/persistence.rb:273:in `update_column'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:46:in `block (2 levels) in up'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:45:in `each'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:45:in `block in up'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/relation/delegation.rb:46:in `each'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/relation/delegation.rb:46:in `each'
/Users/Huner/work/lostmyname/eagle/db/migrate/20150721110511_update_stock_locations.rb:41:in `up'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:608:in `exec_migration'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:589:in `block (2 levels) in migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:588:in `block in migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in `with_connection'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:587:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:765:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:995:in `block in execute_migration_in_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:1041:in `block in ddl_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/transactions.rb:220:in `transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:1041:in `ddl_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:994:in `execute_migration_in_transaction'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:956:in `block in migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:952:in `each'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:952:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:820:in `up'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/migration.rb:798:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/tasks/database_tasks.rb:137:in `migrate'
/Users/Huner/.rvm/gems/ruby-2.1.6/gems/activerecord-4.2.4/lib/active_record/railties/databases.rake:44:in `block (2 levels) in <top (required)>'
/Users/Huner/.rvm/gems/ruby-2.1.6/bin/ruby_executable_hooks:15:in `eval'
/Users/Huner/.rvm/gems/ruby-2.1.6/bin/ruby_executable_hooks:15:in `<main>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment