Redmine

Hi,

Bulk editing issues does not work if some of the parts are left as "(no change)". For example, the stacktrace
at the end of this message occurs when the priority is left as "(no change)" (running under Postgresql 8.2
by the way). Also, it appears as though the form is submitting the actual value "(No change)" for
"assigned_to_id" rather than empty string or null.

------------8<---------------------------

Processing ProjectsController#bulk_edit_issues (for 192.168.1.217 at 2007-10-23 13:20:34) [POST]
Session ID: ea3e7933d33757439deab94650b7339a
Parameters: {"start_date"=>"", "commit"=>"Apply",
"action"=>"bulk_edit_issues", "priority_id"=>"",
"id"=>"1", "notes"=>"", "controller"=>"projects",
"fixed_version_id"=>"", "category_id"=>"",
"issue_ids"=>["376"], "done_ratio"=>"", "due_date"=>"",
"assigned_to_id"=>"(No change)", "status_id"=>"12"}

ActiveRecord::StatementInvalid (RuntimeError: ERROR C22P02 Minvalid input syntax for integer: "" Fnumutils.c
L54 Rpg_atoi: SELECT * FROM enumerations WHERE (enumerations."id" = '') LIMIT 1):
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract_adapter.rb:128:in `log'
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/postgresql_adapter.rb:152:in
`execute'
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/postgresql_adapter.rb:433:in
`select'
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in
`select_all'
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:427:in `find_by_sql'
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:997:in `find_every'
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:991:in `find_initial'
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1204:in `send'
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1204:in `method_missing'
/var/lib/gems/1.8/gems/activesupport-1.4.2/lib/active_support/deprecation.rb:44:in `silence'
/var/lib/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1204:in `method_missing'
/app/controllers/projects_controller.rb:343:in `bulk_edit_issues'
/var/lib/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/base.rb:1095:in `send'