Redmine

Searching issues for a target version of "none" produces the following error on Postgresql 8.3. This is due to the ...issues.fixed_version_id = '' ... clause even though it is an integer.

Processing IssuesController#index (for 192.168.1.114 at 2008-04-29 09:58:42) [POST]
  Session ID: 42a5b844b024196b4e990c6fd7fd18df
  Parameters: {"project_id"=>"equella", "set_filter"=>"1", "fields"=>["status_id", "fixed_version_id"], "action"=>"index", "operators"=>{"cf_2"=>"=",
               "start_date"=>"<t+", "created_on"=>">t-", "cf_3"=>"=", "cf_4"=>"=", "updated_on"=>">t-", "priority_id"=>"=", "subject"=>"~",
               "fixed_version_id"=>"!*", "tracker_id"=>"=", "done_ratio"=>"=", "due_date"=>"<t+", "assigned_to_id"=>"=", "author_id"=>"=", "status_id"=>"=",
               "cf_1"=>"="}, "controller"=>"issues", "values"=>{"cf_2"=>[""], "start_date"=>[""], "created_on"=>[""], "cf_3"=>["2.x"], "cf_4"=>["Activity
                Assembler"], "updated_on"=>[""], "priority_id"=>["3"], "subject"=>[""], "fixed_version_id"=>["4"], "tracker_id"=>["1"], "done_ratio"=>[""],
               "due_date"=>[""], "assigned_to_id"=>["me"], "author_id"=>["me"], "status_id"=>["12"], "cf_1"=>["ADFA"]}, "add_filter_select"=>""}

ActiveRecord::StatementInvalid (RuntimeError: ERROR     C22P02  Minvalid input syntax for integer: ""   Fnumutils.c     L54     Rpg_atoi: SELECT count(DISTINCT
issues.id) AS count_all FROM issues  LEFT OUTER JOIN issue_statuses ON issue_statuses.id = issues.status_id  LEFT OUTER JOIN projects ON projects.id =
issues.project_id   WHERE (issues.project_id = 1 AND (issues.fixed_version_id IS NULL OR issues.fixed_version_id = '') AND (issues.status_id IN ('12'))) ):
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:150:in `log'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:407:in `execute'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:782:in `select_raw'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:769:in `select'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/query_cache.rb:74:in `cache_sql'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/calculations.rb:208:in `execute_simple_calculation'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/calculations.rb:123:in `calculate'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/calculations.rb:119:in `catch'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/calculations.rb:119:in `calculate'
    /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/calculations.rb:46:in `count'
    /app/controllers/issues_controller.rb:59:in `index'
    ...