Skip to content

NoMethodError in query_patch for agile/charts #18

@jza34

Description

@jza34

Hi,
I get an error 500 while opening redmine agile charts like: https://<mydomain>/agile/charts

Started GET "/agile/charts?utf8=%E2%9C%93&search=&set_filter=1&f%5B%5D=&f%5B%5D=status_id&op%5Bstatus_id%5D=%3D&f_status%5B%5D=1&f_status%5B%5D=35&f_status%5B%5D=36&f_status%5B%5D=38&f_status%5B%5D=47&f_status%5B%5D=56&f_status%5B%5D=19&f_status%5B%5D=49&f_status%5B%5D=20&f_status%5B%5D=74&f_status%5B%5D=21&f_status%5B%5D=22&f_status%5B%5D=15&f_status%5B%5D=30&f_status%5B%5D=16&f_status%5B%5D=57&f_status%5B%5D=32&f_status%5B%5D=33&f_status%5B%5D=34&f_status%5B%5D=50&f_status%5B%5D=2&f_status%5B%5D=3&f_status%5B%5D=4&f_status%5B%5D=10&f_status%5B%5D=11&f_status%5B%5D=12&f_status%5B%5D=13&f_status%5B%5D=24&f_status%5B%5D=27&f_status%5B%5D=28&f_status%5B%5D=29&f_status%5B%5D=43&f_status%5B%5D=44&f_status%5B%5D=45&f_status%5B%5D=46&f_status%5B%5D=51&f_status%5B%5D=53&f_status%5B%5D=58&f_status%5B%5D=59&f_status%5B%5D=61&f_status%5B%5D=62&f_status%5B%5D=65&f_status%5B%5D=70&f_status%5B%5D=67&f_status%5B%5D=78&c%5B%5D=tracker" for 192.168.4.200 at 2021-10-15 17:00:23 +0200
Processing by AgileChartsController#show as HTML
  Parameters: {"utf8"=>"✓", "search"=>"", "set_filter"=>"1", "f"=>["", "status_id"], "op"=>{"status_id"=>"="}, "f_status"=>["1", "35", "36", "38", "47", "56", "19", "49", "20", "74", "21", "22", "15", "30", "16", "57", "32", "33", "34", "50", "2", "3", "4", "10", "11", "12", "13", "24", "27", "28", "29", "43", "44", "45", "46", "51", "53", "58", "59", "61", "62", "65", "70", "67", "78"], "c"=>["tracker"]}
  Current user: lamy (id=330)
Completed 500 Internal Server Error in 110ms (ActiveRecord: 18.1ms)
  
NoMethodError (undefined method `type' for nil:NilClass):
  
plugins/redmine_datetime_custom_field/lib/redmine_datetime_custom_field/query_patch.rb:68:in `date_clause'
app/models/query.rb:1445:in `relative_date_clause'
app/models/query.rb:1225:in `sql_for_field'
plugins/redmine_agile/app/models/agile_charts_query.rb:147:in `build_chart_period_statement'
plugins/redmine_agile/app/models/agile_charts_query.rb:130:in `chart_period_statement'
plugins/redmine_agile/app/models/agile_charts_query.rb:124:in `chart_period'
plugins/redmine_agile/app/models/agile_charts_query.rb:62:in `date_from'
plugins/redmine_agile/app/controllers/agile_charts_controller.rb:119:in `retrieve_charts_query'
plugins/redmine_agile/app/controllers/agile_charts_controller.rb:51:in `show'
plugins/redmine_per_project_formatting/lib/redmine_per_project_formatting/application_controller_patch.rb:24:in `block in change_text_formatting'
plugins/redmine_per_project_formatting/lib/redmine_per_project_formatting/setting_patch.rb:19:in `within_text_formatting'
plugins/redmine_per_project_formatting/lib/redmine_per_project_formatting/application_controller_patch.rb:23:in `change_text_formatting'
lib/redmine/sudo_mode.rb:65:in `sudo_mode'

I cloned the master branch but no success...

My redmine version is:

Environment:
  Redmine version                4.1.1.stable
  Ruby version                   2.6.6-p146 (2020-03-31) [x86_64-linux]
  Rails version                  5.2.4.2
  Environment                    production
  Database adapter               Mysql2
  Mailer queue                   ActiveJob::QueueAdapters::AsyncAdapter
  Mailer delivery                smtp
SCM:
  Subversion                     1.7.14
  Git                            1.8.3.1
  Filesystem                     
Redmine plugins:
  issue_recurring                1.6
  redmine_agile                  1.5.4
  redmine_base_deface            1.5.3
  redmine_checklists             3.1.18
  redmine_datetime_custom_field  3.3.0
  redmine_ics_export             4.0.1.dev
  redmine_issue_templates        1.1.0
  redmine_messenger              1.0.8-master
  redmine_openid_connect         0.9.4
  redmine_per_project_formatting 0.1.0

Any advice?

Thanks a lot

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions