Jobpositions bugs

[karmatr0n]

A ActiveRecord::StatementInvalid occurred in jobpositions#create:

PGError: ERROR: null value in column "start_date" violates not-null constraint
: INSERT INTO "jobpositions" ("contracttype_id", "created_on", "descr", "end_date", "institution_id", "jobpositioncategory_id", "modified_by_id", "place_of_origin", "registered_by_id", "start_date", "updated_on", "user_id") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) RETURNING "id"
activerecord (3.1.3) lib/active_record/connection_adapters/postgresql_adapter.rb:1034:in `get_last_result'

---

Request:

• URL : https://salva.fisica.unam.mx/jobpositions
• IP address: 201.124.30.171
• Parameters: {"utf8"=>"✓", "authenticity_token"=>"9gGT4wgVSLSwx7xNgp6NdT5wEa4nnNEP0a72u9xqnPM=", "filter"=>{"jobpositiontype_id"=>""}, "jobposition"=>{"contracttype_id"=>"5", "institution_id"=>"30", "start_date"=>"1959", "end_date"=>"1963", "user_adscription_attributes"=>{"adscription_id"=>"1", "descr"=>"Ayudante de Investigador M.T.", "id"=>"", "jobposition_id"=>""}}, "commit"=>"Guardar", "action"=>"create", "controller"=>"jobpositions"}
• Rails root: /home/deployer/apps/salva

---

Session:

• session id: [FILTERED]
• data: {"warden.user.user.key"=>["User", [161], nil],
  "warden.user.user.session"=>{"last_request_at"=>2012-02-11 04:37:33 UTC},
  "_csrf_token"=>"9gGT4wgVSLSwx7xNgp6NdT5wEa4nnNEP0a72u9xqnPM="}

---

Environment:

• CONTENT_LENGTH : 534
• CONTENT_TYPE : application/x-www-form-urlencoded
• DOCUMENT_ROOT : /home/deployer/apps/salva/public
• HTTPS : on
• HTTP_ACCEPT : text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
• HTTP_ACCEPT_CHARSET : ISO-8859-1,utf-8;q=0.7,*;q=0.7
• HTTP_ACCEPT_ENCODING : gzip, deflate
• HTTP_ACCEPT_LANGUAGE : es-MX,es;q=0.8,en-us;q=0.5,en;q=0.3
• HTTP_CONNECTION : keep-alive
• HTTP_COOKIE : NREUM=s=1328935209357&r=103396&p=86893; _salva_session=4eb6fff992e0dc1cdced56eded937a06
• HTTP_HOST : salva.fisica.unam.mx
• HTTP_REFERER : https://salva.fisica.unam.mx/jobpositions/new
• HTTP_USER_AGENT : Mozilla/5.0 (Windows NT 6.1; rv:9.0.1) Gecko/20100101 Firefox/9.0.1
• PASSENGER_APP_SPAWNER_IDLE_TIME : -1
• PASSENGER_APP_TYPE : rack
• PASSENGER_CONNECT_PASSWORD : [FILTERED]
• PASSENGER_DEBUGGER : false
• PASSENGER_ENVIRONMENT : production
• PASSENGER_FRAMEWORK_SPAWNER_IDLE_TIME : -1
• PASSENGER_FRIENDLY_ERROR_PAGES : true
• PASSENGER_GROUP :
• PASSENGER_MAX_REQUESTS : 0
• PASSENGER_MIN_INSTANCES : 1
• PASSENGER_SHOW_VERSION_IN_HEADER : true
• PASSENGER_SPAWN_METHOD : :smart
• PASSENGER_USER :
• PASSENGER_USE_GLOBAL_QUEUE : true
• PATH_INFO : /jobpositions
• QUERY_STRING :
• REMOTE_ADDR : 201.124.30.171
• REMOTE_PORT : 59554
• REQUEST_METHOD : POST
• REQUEST_URI : /jobpositions
• SCGI : 1
• SCRIPT_NAME :
• SERVER_ADDR : 132.248.7.50
• SERVER_NAME : salva.fisica.unam.mx
• SERVER_PORT : 443
• SERVER_PROTOCOL : HTTP/1.1
• SERVER_SOFTWARE : nginx/1.0.10
• UNION_STATION_SUPPORT : false
• _ : _
• action_controller.instance : jobpositions#create
• action_dispatch.parameter_filter : [:password, /RAW_POST_DATA/, /RAW_POST_DATA/]
• action_dispatch.remote_ip : 201.124.30.171
• action_dispatch.request.content_type : application/x-www-form-urlencoded
• action_dispatch.request.formats : [text/html]
• action_dispatch.request.parameters : {"utf8"=>"✓", "authenticity_token"=>"9gGT4wgVSLSwx7xNgp6NdT5wEa4nnNEP0a72u9xqnPM=", "filter"=>{"jobpositiontype_id"=>""}, "jobposition"=>{"contracttype_id"=>"5", "institution_id"=>"30", "start_date"=>"1959", "end_date"=>"1963", "user_adscription_attributes"=>{"adscription_id"=>"1", "descr"=>"Ayudante de Investigador M.T.", "id"=>"", "jobposition_id"=>""}}, "commit"=>"Guardar", "action"=>"create", "controller"=>"jobpositions"}
• action_dispatch.request.path_parameters : {:action=>"create", :controller=>"jobpositions"}
• action_dispatch.request.query_parameters : {}
• action_dispatch.request.request_parameters: {"utf8"=>"✓", "authenticity_token"=>"9gGT4wgVSLSwx7xNgp6NdT5wEa4nnNEP0a72u9xqnPM=", "filter"=>{"jobpositiontype_id"=>""}, "jobposition"=>{"contracttype_id"=>"5", "institution_id"=>"30", "start_date"=>"1959", "end_date"=>"1963", "user_adscription_attributes"=>{"adscription_id"=>"1", "descr"=>"Ayudante de Investigador M.T.", "id"=>"", "jobposition_id"=>""}}, "commit"=>"Guardar"}
• action_dispatch.routes : #ActionDispatch::Routing::RouteSet:0x9bc8be0
• action_dispatch.secret_token : 52d737e54b7c19af1c06c7101e405f842645b5c9446acd9cfa70bbdebf6aada443bb35460a5af20e3f93d567e59999fd6bd1d78ccc865b961c84318b4ebbf308
• action_dispatch.show_exceptions : true
• exception_notifier.options : {:sender_address=>"salva@fisica.unam.mx", :exception_recipients=>"alex@fisica.unam.mx", :email_prefix=>"[SALVA - Exception notification] ", :sections=>["request", "session", "environment", "backtrace"], :ignore_exceptions=>[ActiveRecord::RecordNotFound, AbstractController::ActionNotFound, ActionController::RoutingError]}
• rack-cache.allow_reload : false
• rack-cache.allow_revalidate : false
• rack-cache.cache_key : Rack::Cache::Key
• rack-cache.default_ttl : 0
• rack-cache.entitystore : rails:/
• rack-cache.metastore : rails:/
• rack-cache.private_headers : ["Authorization", "Cookie"]
• rack-cache.storage : #Rack::Cache::Storage:0xa6401cc
• rack-cache.use_native_ttl : false
• rack-cache.verbose : true
• rack.errors : #IO:0x8631d40
• rack.input : #PhusionPassenger::Utils::RewindableInput:0xc155b9c
• rack.multiprocess : true
• rack.multithread : false
• rack.request.cookie_hash : {"NREUM"=>"s=1328935209357&r=103396&p=86893", "_salva_session"=>"4eb6fff992e0dc1cdced56eded937a06"}
• rack.request.cookie_string : NREUM=s=1328935209357&r=103396&p=86893; _salva_session=4eb6fff992e0dc1cdced56eded937a06
• rack.request.form_hash : {"utf8"=>"✓", "authenticity_token"=>"9gGT4wgVSLSwx7xNgp6NdT5wEa4nnNEP0a72u9xqnPM=", "filter"=>{"jobpositiontype_id"=>""}, "jobposition"=>{"contracttype_id"=>"5", "institution_id"=>"30", "start_date"=>"1959", "end_date"=>"1963", "user_adscription_attributes"=>{"adscription_id"=>"1", "descr"=>"Ayudante de Investigador M.T.", "id"=>"", "jobposition_id"=>""}}, "commit"=>"Guardar"}
• rack.request.form_input : #PhusionPassenger::Utils::RewindableInput:0xc155b9c
• rack.request.form_vars : utf8=%E2%9C%93&authenticity_token=9gGT4wgVSLSwx7xNgp6NdT5wEa4nnNEP0a72u9xqnPM%3D&filter%5Bjobpositiontype_id%5D=&jobposition%5Bcontracttype_id%5D=5&jobposition%5Binstitution_id%5D=30&jobposition%5Bstart_date%5D=1959&jobposition%5Bend_date%5D=1963&jobposition%5Buser_adscription_attributes%5D%5Badscription_id%5D=1&jobposition%5Buser_adscription_attributes%5D%5Bdescr%5D=Ayudante+de+Investigador+M.T.&jobposition%5Buser_adscription_attributes%5D%5Bid%5D=&jobposition%5Buser_adscription_attributes%5D%5Bjobposition_id%5D=&commit=Guardar
• rack.request.query_hash : {}
• rack.request.query_string :
• rack.run_once : false
• rack.session : {"warden.user.user.key"=>["User", [161], nil], "warden.user.user.session"=>{"last_request_at"=>2012-02-11 04:37:33 UTC}, "_csrf_token"=>"9gGT4wgVSLSwx7xNgp6NdT5wEa4nnNEP0a72u9xqnPM="}
• rack.session.options : {:key=>"_salva_session", :path=>"/", :domain=>nil, :expire_after=>1800 seconds, :secure=>false, :httponly=>true, :defer=>false, :renew=>false, :memcache_server=>["127.0.0.1:11211"], :namespace=>"sessions", :id=>"4eb6fff992e0dc1cdced56eded937a06"}
• rack.url_scheme : https
• rack.version : [1, 0]
• warden : Warden::Proxy:101424240 @config={:default_scope=>:user, :scope_defaults=>{}, :default_strategies=>{:user=>[:ldap_authenticatable], :academic=>[:ldap_authenticatable]}, :intercept_401=>false, :failure_app=>#Devise::Delegator:0xb35fa24}