Actions
Defect #1134
closed![Author: Anonymous](/images/anonymous.png?1679302129)
Search for target version of "none" fails
Start date:
2008-04-29
Due date:
% Done:
0%
Estimated time:
Resolution:
Fixed
Affected version:
Description
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' ...
Updated by Jean-Philippe Lang over 16 years ago
- Status changed from New to Closed
- Target version set to 0.7.1
- Resolution set to Fixed
Fixed in r1379.
Actions