Project

General

Profile

redmine 2.2.0 - crash selecting "Issues" Tab on a project

Added by Marco Nobler about 11 years ago

My redmine installation (Bitnami Redmine 2.2.0 stack) crashes when I select “issues” tab for a specific project (attiv001): it logs as follows

Started GET "/redmine/projects/attiv001/issues" for 10.173.139.40 at 2013-01-23 12:47:51 +0000
Processing by IssuesController#index as HTML
Parameters: {"project_id"=>"attiv001"}
Current user: 37509390 (id=32)
Completed 500 Internal Server Error in 345ms

NoMethodError (undefined method `[]' for nil:NilClass):
app/helpers/queries_helper.rb:166:in `build_query_from_params'
app/helpers/queries_helper.rb:134:in `retrieve_
query'
app/controllers/issues_controller.rb:56:in `index'

so it crashes on the following instruction on queries_helper.rb:
@query.available_filters.keys.each do |field|

trying to debug I inserted log instructions in queries_helper.rb and query.rb:

------ queries_helper.rb
def build_query_from_params
if params[:fields] || params[:f]
@query.filters = {}
@query.add_filters(params[:fields] || params[:f], params[:operators] || params[:op], params[:values] || params[:v])
else
Rails.logger.warn "query: #{@query.inspect}"
Rails.logger.warn "params: #{params}"
@query.available_filters.keys.each do |field|
Rails.logger.warn "field: #{field}"
@query.add_short_filter(field, params[field]) if params[field]
end
end
@query.group_by = params[:group_by] || (params[:query] && params[:query][:group_by])
@query.column_names = params[:c] || (params[:query] && params[:query][:column_names])
end
--------

--- query.rb
def available_filters
. . . . . .
Rails.logger.warn "available_filters.keys: #{@available_filters.keys.inspect}"
@available_filters
end
--------------

This is the output:

Started GET "/redmine/projects/attiv001/issues" for 10.173.139.40 at 2013-01-23 14:31:32 +0000
Processing by IssuesController#index as HTML
Parameters: {"project_id"=>"attiv001"}
Current user: 37509390 (id=32)
query: #<Query id: nil, project_id: 33, name: "_", filters: {"status_id"=>{:operator=>"o", :values=>[""]}}, user_id: 0, is_public: false, column_names: nil, sort_criteria: [], group_by: nil>
params: {"action"=>"index", "controller"=>"issues", "project_id"=>"attiv001"}
available_filters.keys: ["status_id", "tracker_id", "priority_id", "subject", "created_on", "updated_on", "start_date", "relates", "duplicates", "duplicated", "blocks", "blocked", "precedes", "follows", "copied_to", "copied_from", "author_id", "member_of_group", "assigned_to_role", "watcher_id", "cf_6", "cf_11", "cf_19", "cf_2", "cf_17", "cf_18", "cf_3", "cf_4", "cf_20", "cf_1", "cf_36", "cf_45", "cf_5", "cf_23", "cf_9", "cf_24", "cf_15", "cf_37", "cf_44", "is_private"]
Completed 500 Internal Server Error in 321ms

NoMethodError (undefined method `[]' for nil:NilClass):
app/helpers/queries_helper.rb:171:in `build_query_from_params'
app/helpers/queries_helper.rb:136:in `retrieve_query'
app/controllers/issues_controller.rb:56:in `index'

I cannot figure out why it crashes, to me seems that "available_filters.key" is correctly populated.

Can anyone help me to inspect this problem? Is it a database problem or what?

Thanks a lot
Marco

P.S. This is the log for a “good” project:

Started GET "/redmine/projects/ct001/issues" for 10.173.139.40 at 2013-01-23 14:30:20 +0000
Processing by IssuesController#index as HTML
Parameters: {"project_id"=>"ct001"}
Current user: 37509390 (id=32)
query: #<Query id: nil, project_id: 41, name: "_", filters: {"status_id"=>{:operator=>"o", :values=>[""]}}, user_id: 0, is_public: false, column_names: nil, sort_criteria: [], group_by: nil>
params: {"action"=>"index", "controller"=>"issues", "project_id"=>"ct001"}
available_filters.keys: ["status_id", "tracker_id", "priority_id", "subject", "created_on", "updated_on", "start_date", "relates", "duplicates", "duplicated", "blocks", "blocked", "precedes", "follows", "copied_to", "copied_from", "assigned_to_id", "author_id", "member_of_group", "assigned_to_role", "watcher_id", "category_id", "fixed_version_id", "cf_6", "cf_11", "cf_19", "cf_2", "cf_17", "cf_18", "cf_3", "cf_4", "cf_20", "cf_1", "cf_36", "cf_45", "cf_5", "cf_23", "cf_9", "cf_24", "cf_15", "cf_37", "cf_44", "is_private"]
field: status_id
field: tracker_id
field: priority_id
field: subject
field: created_on
field: updated_on
field: start_date
field: relates
field: duplicates
field: duplicated
field: blocks
field: blocked
field: precedes
field: follows
field: copied_to
field: copied_from
field: assigned_to_id
field: author_id
field: member_of_group
field: assigned_to_role
field: watcher_id
field: category_id
field: fixed_version_id
field: cf_6
field: cf_11
field: cf_19
field: cf_2
field: cf_17
field: cf_18
field: cf_3
field: cf_4
field: cf_20
field: cf_1
field: cf_36
field: cf_45
field: cf_5
field: cf_23
field: cf_9
field: cf_24
field: cf_15
field: cf_37
field: cf_44
field: is_private
Rendered queries/_filters.html.erb (39.9ms)
Rendered queries/_columns.html.erb (6.2ms)
Rendered issues/_list.html.erb (231.1ms)
Rendered issues/_sidebar.html.erb (8.5ms)
Rendered issues/index.html.erb within layouts/base (311.9ms)
Completed 200 OK in 1187ms (Views: 329.1ms | ActiveRecord: 29.6ms)