NullVoxPopuli / aeonvera

A generic registration system aimed towards swing dance events (mirrored from gitlab)
https://aeonvera.com
GNU Affero General Public License v3.0
15 stars 1 forks source link

RegisterController#create (ActiveRecord::StatementInvalid) "PG::NotNullViolation: ERROR: null value in column "transportation_capacity" violates not-null constraint DETAIL: Failing row contains (260, t, f, null, f, t, , ["","","",""], ["","","",""], No Preference, , 1079, EventAttendance, 20, Event, null, 2015-09-16 16:08:27.414298, 2015-09-16 16:08:27.414298). : INSERT INTO "housing_requests" ("preferred_gender_to_house_with", "need_transportation", "transportation_capacity", "allergic_to_smoke", "other_allergies", "notes", "requested_roommates", "unwanted_roommates", "host_id", "host_type", "attendance_type", "attendance_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) RETURNING "id"" #405

Closed NullVoxPopuli closed 8 years ago

NullVoxPopuli commented 8 years ago
ExceptionPG::NotNullViolation: ERROR: null value in column "transportation_capacity" violates not-null constraint DETAIL: Failing row contains (260, t, f, null, f, t, , ["","","",""], ["","","",""], No Preference, , 1079, EventAttendance, 20, Event, null, 2015-09-16 16:08:27.414298, 2015-09-16 16:08:27.414298). : INSERT INTO "housing_requests" ("preferred_gender_to_house_with", "need_transportation", "transportation_capacity", "allergic_to_smoke", "other_allergies", "notes", "requested_roommates", "unwanted_roommates", "host_id", "host_type", "attendance_type", "attendance_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) RETURNING "id"
Last OccurrenceSeptember 16, 2015 12:08:27 -0400
Count1

Stack Trace

[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:606:in `exec_prepared'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:606:in `block in exec_cache'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:473:in `block in log'
[bundle].../gems/activesupport-4.2.3/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:467:in `log'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:605:in `exec_cache'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql_adapter.rb:589:in `execute_and_clear'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/postgresql/database_statements.rb:192:in `exec_insert'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:108:in `insert'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `insert'
[bundle].../gems/activerecord-4.2.3/lib/active_record/relation.rb:64:in `insert'
[bundle].../gems/activerecord-4.2.3/lib/active_record/persistence.rb:524:in `_create_record'
[bundle].../gems/activerecord-4.2.3/lib/active_record/counter_cache.rb:139:in `_create_record'
[bundle].../gems/activerecord-4.2.3/lib/active_record/locking/optimistic.rb:75:in `_create_record'
[bundle].../gems/activerecord-4.2.3/lib/active_record/attribute_methods/dirty.rb:132:in `_create_record'
[bundle].../gems/activerecord-4.2.3/lib/active_record/callbacks.rb:306:in `block in _create_record'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:84:in `run_callbacks'
[bundle].../gems/activerecord-4.2.3/lib/active_record/callbacks.rb:306:in `_create_record'
[bundle].../gems/activerecord-4.2.3/lib/active_record/timestamp.rb:57:in `_create_record'
[bundle].../gems/activerecord-4.2.3/lib/active_record/persistence.rb:504:in `create_or_update'
[bundle].../gems/activerecord-4.2.3/lib/active_record/callbacks.rb:302:in `block in create_or_update'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:115:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:115:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:553:in `block (2 levels) in compile'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:503:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:503:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:88:in `run_callbacks'
[bundle].../gems/activerecord-4.2.3/lib/active_record/callbacks.rb:302:in `create_or_update'
[bundle].../gems/activerecord-4.2.3/lib/active_record/persistence.rb:120:in `save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/validations.rb:37:in `save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/attribute_methods/dirty.rb:21:in `save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:286:in `block (2 levels) in save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:351:in `block in with_transaction_returning_status'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:211:in `transaction'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:220:in `transaction'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:348:in `with_transaction_returning_status'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:286:in `block in save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:301:in `rollback_active_record_state!'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:285:in `save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/autosave_association.rb:413:in `save_has_one_association'
[bundle].../gems/activerecord-4.2.3/lib/active_record/autosave_association.rb:189:in `block in add_autosave_association_callbacks'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:430:in `block in make_lambda'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:226:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:226:in `block in halting_and_conditional'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:504:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:504:in `block in call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:504:in `each'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:504:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:88:in `run_callbacks'
[bundle].../gems/activerecord-4.2.3/lib/active_record/callbacks.rb:306:in `_create_record'
[bundle].../gems/activerecord-4.2.3/lib/active_record/timestamp.rb:57:in `_create_record'
[bundle].../gems/activerecord-4.2.3/lib/active_record/persistence.rb:504:in `create_or_update'
[bundle].../gems/activerecord-4.2.3/lib/active_record/callbacks.rb:302:in `block in create_or_update'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:115:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:115:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:553:in `block (2 levels) in compile'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:503:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:503:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:88:in `run_callbacks'
[bundle].../gems/activerecord-4.2.3/lib/active_record/callbacks.rb:302:in `create_or_update'
[bundle].../gems/activerecord-4.2.3/lib/active_record/persistence.rb:120:in `save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/validations.rb:37:in `save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/attribute_methods/dirty.rb:21:in `save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:286:in `block (2 levels) in save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:351:in `block in with_transaction_returning_status'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `block in transaction'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/transaction.rb:184:in `within_new_transaction'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:213:in `transaction'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:220:in `transaction'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:348:in `with_transaction_returning_status'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:286:in `block in save'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:301:in `rollback_active_record_state!'
[bundle].../gems/activerecord-4.2.3/lib/active_record/transactions.rb:285:in `save'
[app].../app/controllers/register_controller.rb:266:in `apply_discounts'
[app].../app/controllers/register_controller.rb:48:in `create'
[bundle].../gems/actionpack-4.2.3/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
[bundle].../gems/actionpack-4.2.3/lib/abstract_controller/base.rb:198:in `process_action'
[bundle].../gems/actionpack-4.2.3/lib/action_controller/metal/rendering.rb:10:in `process_action'
[bundle].../gems/actionpack-4.2.3/lib/abstract_controller/callbacks.rb:20:in `block in process_action'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:115:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:115:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:553:in `block (2 levels) in compile'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:503:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:503:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:88:in `run_callbacks'
[bundle].../gems/actionpack-4.2.3/lib/abstract_controller/callbacks.rb:19:in `process_action'
[bundle].../gems/actionpack-4.2.3/lib/action_controller/metal/rescue.rb:29:in `process_action'
[bundle].../gems/actionpack-4.2.3/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action'
[bundle].../gems/activesupport-4.2.3/lib/active_support/notifications.rb:164:in `block in instrument'
[bundle].../gems/activesupport-4.2.3/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
[bundle].../gems/activesupport-4.2.3/lib/active_support/notifications.rb:164:in `instrument'
[bundle].../gems/actionpack-4.2.3/lib/action_controller/metal/instrumentation.rb:30:in `process_action'
[bundle].../gems/actionpack-4.2.3/lib/action_controller/metal/params_wrapper.rb:250:in `process_action'
[bundle].../gems/activerecord-4.2.3/lib/active_record/railties/controller_runtime.rb:18:in `process_action'
[bundle].../gems/actionpack-4.2.3/lib/abstract_controller/base.rb:137:in `process'
[bundle].../gems/actionview-4.2.3/lib/action_view/rendering.rb:30:in `process'
[bundle].../gems/actionpack-4.2.3/lib/action_controller/metal.rb:196:in `dispatch'
[bundle].../gems/actionpack-4.2.3/lib/action_controller/metal/rack_delegation.rb:13:in `dispatch'
[bundle].../gems/actionpack-4.2.3/lib/action_controller/metal.rb:237:in `block in action'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/routing/route_set.rb:76:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/routing/route_set.rb:76:in `dispatch'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/routing/route_set.rb:45:in `serve'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/routing/mapper.rb:49:in `serve'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/journey/router.rb:43:in `block in serve'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/journey/router.rb:30:in `each'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/journey/router.rb:30:in `serve'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/routing/route_set.rb:821:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/recurring_select-1.3.1/app/middleware/recurring_select_middleware.rb:24:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/omniauth-1.2.2/lib/omniauth/strategy.rb:186:in `call!'
[bundle].../gems/omniauth-1.2.2/lib/omniauth/strategy.rb:164:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/omniauth-1.2.2/lib/omniauth/builder.rb:59:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/rack/agent_hooks.rb:30:in `traced_call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/rack/browser_monitoring.rb:23:in `traced_call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/party_foul-1.5.5/lib/party_foul/middleware.rb:8:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/warden-1.2.3/lib/warden/manager.rb:35:in `block in call'
[bundle].../gems/warden-1.2.3/lib/warden/manager.rb:34:in `catch'
[bundle].../gems/warden-1.2.3/lib/warden/manager.rb:34:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/rack-1.6.4/lib/rack/etag.rb:24:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/rack-1.6.4/lib/rack/conditionalget.rb:38:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/rack-1.6.4/lib/rack/head.rb:13:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/params_parser.rb:27:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/flash.rb:260:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/rack-1.6.4/lib/rack/session/abstract/id.rb:225:in `context'
[bundle].../gems/rack-1.6.4/lib/rack/session/abstract/id.rb:220:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/cookies.rb:560:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/activerecord-4.2.3/lib/active_record/query_cache.rb:36:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:653:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/callbacks.rb:29:in `block in call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/callbacks.rb:84:in `run_callbacks'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/callbacks.rb:27:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/remote_ip.rb:78:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/debug_exceptions.rb:17:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/show_exceptions.rb:30:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/railties-4.2.3/lib/rails/rack/logger.rb:38:in `call_app'
[bundle].../gems/railties-4.2.3/lib/rails/rack/logger.rb:20:in `block in call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/tagged_logging.rb:68:in `block in tagged'
[bundle].../gems/activesupport-4.2.3/lib/active_support/tagged_logging.rb:26:in `tagged'
[bundle].../gems/activesupport-4.2.3/lib/active_support/tagged_logging.rb:68:in `tagged'
[bundle].../gems/railties-4.2.3/lib/rails/rack/logger.rb:20:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/request_store-1.1.0/lib/request_store/middleware.rb:8:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/request_id.rb:21:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/rack-1.6.4/lib/rack/methodoverride.rb:22:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/rack-1.6.4/lib/rack/runtime.rb:18:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/activesupport-4.2.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/static.rb:116:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/rack-1.6.4/lib/rack/sendfile.rb:113:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/actionpack-4.2.3/lib/action_dispatch/middleware/ssl.rb:24:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/rack-cors-0.4.0/lib/rack/cors.rb:80:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/railties-4.2.3/lib/rails/engine.rb:518:in `call'
[bundle].../gems/railties-4.2.3/lib/rails/application.rb:165:in `call'
[bundle].../gems/newrelic_rpm-3.11.2.286/lib/new_relic/agent/instrumentation/middleware_tracing.rb:67:in `call'
[bundle].../gems/rack-1.6.4/lib/rack/content_length.rb:15:in `call'
[bundle].../gems/puma-2.11.2/lib/puma/server.rb:507:in `handle_request'
[bundle].../gems/puma-2.11.2/lib/puma/server.rb:375:in `process_client'
[bundle].../gems/puma-2.11.2/lib/puma/server.rb:262:in `block in run'
[bundle].../gems/puma-2.11.2/lib/puma/thread_pool.rb:104:in `call'
[bundle].../gems/puma-2.11.2/lib/puma/thread_pool.rb:104:in `block in spawn_thread'

Fingerprint: d8f2625748ca2abcfc4c8239621621f321fc835b

NullVoxPopuli commented 8 years ago

handled in ember