deecay / redmine_pivot_table

This Redmine plugin allows you to generate pivot table for issue analysis.
MIT License
52 stars 38 forks source link

conflict with redmine_issue_tree_view #38

Open archonwang opened 7 years ago

archonwang commented 7 years ago

@deecay , please check it.

redmine_issues_tree_view https://github.com/charleneChen/redmine_issues_tree_view.git

open the main page with 500 error

A NoMethodError occurred in pivottables#index:

  undefined method `count' for nil:NilClass
  plugins/redmine_issues_tree_view/lib/issue_query_patch.rb:15:in `issues'

-------------------------------
Request:
-------------------------------

* URL : http://192.168.1.41/projects/zmss/pivottables
  * HTTP Method: GET
  * IP address : 192.168.20.253
  * Parameters : {"controller"=>"pivottables", "action"=>"index", "project_id"=>"zmss"}
  * Timestamp  : 2017-04-12 07:13:03 UTC
  * Server : jira
  * Rails root : /opt/redmine-3.3
  * Process: 15640

-------------------------------
Session:
-------------------------------

  * session id: "af98c45b4071f4925f92cc319bdda242"
  * data: {"session_id"=>"af98c45b4071f4925f92cc319bdda242",
   "user_id"=>34,
   "tk"=>"e50c5be5962c96c2072e7c1202235d7e0601ae1e",
   "sudo_timestamp"=>1491956723,
   "_csrf_token"=>"UONMnRPLSLhAlAZFlz+vO5napOjpRtg1ZWd6oq2aGAE=",
   "recent_projects"=>[5, 37, 13],
   "query"=>
    {:project_id=>5,
     :filters=>
      {"status_id"=>{:operator=>"o", :values=>[""]},
       "fixed_version_id"=>{:operator=>"*", :values=>[""]}},
     :group_by=>"parent",
     :column_names=>nil,
     :totalable_names=>[:estimated_hours, :spent_hours]},
   "issues_index_sort"=>"id:desc"}

-------------------------------
Environment:
-------------------------------

  * GATEWAY_INTERFACE                              : CGI/1.2
  * HTTP_ACCEPT                                    : text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
  * HTTP_ACCEPT_ENCODING                           : gzip, deflate, sdch
  * HTTP_ACCEPT_LANGUAGE                           : zh-CN,zh;q=0.8
  * HTTP_CONNECTION                                : keep-alive
  * HTTP_COOKIE                                    : _redmine_session=NjkxeWdCeFBNb1lQYi9udGFSeWJwTHdsR2NBdnlqc3p6ektmRld6OGQvMzBqTjVoNm0vTUgzWm5WWkZOZVRoMDRmUHBaUXoyMDVuQlFncFk3aWdpNkJRSE56Wi91UW94WTFlSnVDWUp6V3VOb2xITXF2a0xLZkduMGo2Nm1tY1Vvdk9BQkxDdWF5Q1dUSlFKbHlPWWVXdCtqSURRZDV2NmMrYTF6S2RieGc1TzBpSzN2OEd3aXdNSmd0elowaE05cFFMTjV0TEhJclVUdi9pcnczSitJQmdzeGFFYTdSdFFaOTBLZW1WUU5qNTJNeEo0bGdEaytOU2lkN01SRm8vOGhTQXB3SDRobnBEN1BkNldzaDJudzNyQXFTbkkxTEJPaEFIYWJRMnNIN3JUSS9rSDgzcTk4dW05NzRBeFBrTWRXWmp1UjRQUGxVeDFTOERpdDBqVkFiSVNJQktZYzdPWEpoVjhrekpNejdoeXA5bVNnVWYwSU9KRkp0cXdNVDJKTVc3RDR0VlE5TVBydk90T2I4OGI4QVJJejhhY2c4Y1h1ZENMMk9EL0VuUHVMaFFXU0ZTOVM5cmIzMUF6emRxdXhVNEViM3M4OWVmMkRxVkRwNXc0NkY0MVpQaGRBN0xZOUJLaG10MnNBZmlQT0xJRmhWM1V6TGd3NDV1NHBFRlRTMlhGT1NxSFdOODRwMmdCdDU3SWNMeDFYV2VmZzdGckRzTXlEb2x4QnNxSUN1b2FmMjE5QnpLK3gxM1k1aDNuRitMMzk2THpLNFQ2cDAxeG01N2kvYTJtVEFMRWhpUmZaekJXOG1xMndJOWhJNjFVcnk2VXBoNU40MzdmLzFabkd2ZmgxUWwwaXR1c0xKTDJROGprTDdCdFdnTTZuZTlPRGRLYmlMUTlLWHQyQklKNzVjV2NsVCtraktYckV4Ni8tLXpKY3RybmlsSUxKYXZnNG1JS1o2Q3c9PQ%3D%3D--f7f5ce0e47ac47100559c0ebccca0e9dd3e02dce
  * HTTP_HOST                                      : 192.168.1.41
* HTTP_REFERER : http://192.168.1.41/projects/zmss/activity
  * HTTP_UPGRADE_INSECURE_REQUESTS                 : 1
  * HTTP_USER_AGENT                                : Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
  * HTTP_VERSION                                   : HTTP/1.1
  * ORIGINAL_FULLPATH                              : /projects/zmss/pivottables
  * ORIGINAL_SCRIPT_NAME                           :
  * PATH_INFO                                      : /projects/zmss/pivottables
  * QUERY_STRING                                   :
  * REMOTE_ADDR                                    : 192.168.20.253
  * REQUEST_METHOD                                 : GET
  * REQUEST_PATH                                   : /projects/zmss/pivottables
  * REQUEST_URI                                    : /projects/zmss/pivottables
  * ROUTES_15794000_SCRIPT_NAME                    :
  * SCRIPT_NAME                                    :
  * SERVER_NAME                                    : 192.168.1.41
  * SERVER_PORT                                    : 80
  * SERVER_PROTOCOL                                : HTTP/1.1
  * SERVER_SOFTWARE                                : thin 1.7.0 codename Dunder Mifflin
  * action_controller.instance                     : #<PivottablesController:0x007f52203b3228>
  * action_dispatch.backtrace_cleaner              : #<Rails::BacktraceCleaner:0x00000004cf4028>
  * action_dispatch.cookies                        : #<ActionDispatch::Cookies::CookieJar:0x007f52203add78>
  * action_dispatch.cookies_digest                 :
  * action_dispatch.cookies_serializer             :
  * action_dispatch.encrypted_cookie_salt          : encrypted cookie
  * action_dispatch.encrypted_signed_cookie_salt   : signed encrypted cookie
  * action_dispatch.http_auth_salt                 : http authentication
  * action_dispatch.key_generator                  : #<ActiveSupport::CachingKeyGenerator:0x00000003151b68>
  * action_dispatch.logger                         : #<ActiveSupport::Logger:0x00000001df71a8>
  * action_dispatch.parameter_filter               : [:password]
  * action_dispatch.redirect_filter                : []
  * action_dispatch.remote_ip                      : 192.168.20.253
  * action_dispatch.request.content_type           :
  * action_dispatch.request.formats                : [#<Mime::Type:0x0000000436eff8 @synonyms=["application/xhtml+xml"], @symbol=:html, @string="text/html", @hash=-2935462450235946996>]
  * action_dispatch.request.parameters             : {"controller"=>"pivottables", "action"=>"index", "project_id"=>"zmss"}
  * action_dispatch.request.path_parameters        : {:controller=>"pivottables", :action=>"index", :project_id=>"zmss"}
  * action_dispatch.request.query_parameters       : {}
  * action_dispatch.request.request_parameters     : {}
  * action_dispatch.request.unsigned_session_cookie: {"session_id"=>"af98c45b4071f4925f92cc319bdda242", "user_id"=>34, "tk"=>"e50c5be5962c96c2072e7c1202235d7e0601ae1e", "sudo_timestamp"=>1491956723, "_csrf_token"=>"UONMnRPLSLhAlAZFlz+vO5napOjpRtg1ZWd6oq2aGAE=", "recent_projects"=>[5, 37, 13], "query"=>{:project_id=>5, :filters=>{"status_id"=>{:operator=>"o", :values=>[""]}, "fixed_version_id"=>{:operator=>"*", :values=>[""]}}, :group_by=>"parent", :column_names=>nil, :totalable_names=>[:estimated_hours, :spent_hours]}, "issues_index_sort"=>"id:desc"}
  * action_dispatch.request_id                     : bdc7d1d6-387c-4a66-9880-4daa66046cc1
  * action_dispatch.routes                         : #<ActionDispatch::Routing::RouteSet:0x00000001e1fea0>
  * action_dispatch.secret_key_base                : 59dda17a42803617f96151518b9aeecb94e132c6f140123f1982e1c8ae15d0103ffa854c4d8b0019
  * action_dispatch.secret_token                   :
  * action_dispatch.show_detailed_exceptions       : false
  * action_dispatch.show_exceptions                : true
  * action_dispatch.signed_cookie_salt             : signed cookie
  * async.callback                                 : #<Method: Thin::Connection#post_process>
  * async.close                                    : #<EventMachine::DefaultDeferrable:0x007f51e4211730>
  * rack.errors                                    : #<IO:0x000000006f95a0>
  * rack.input                                     : #<StringIO:0x007f51e4212798>
  * rack.multiprocess                              : false
  * rack.multithread                               : true
  * rack.request.cookie_hash                       : {"_redmine_session"=>"NjkxeWdCeFBNb1lQYi9udGFSeWJwTHdsR2NBdnlqc3p6ektmRld6OGQvMzBqTjVoNm0vTUgzWm5WWkZOZVRoMDRmUHBaUXoyMDVuQlFncFk3aWdpNkJRSE56Wi91UW94WTFlSnVDWUp6V3VOb2xITXF2a0xLZkduMGo2Nm1tY1Vvdk9BQkxDdWF5Q1dUSlFKbHlPWWVXdCtqSURRZDV2NmMrYTF6S2RieGc1TzBpSzN2OEd3aXdNSmd0elowaE05cFFMTjV0TEhJclVUdi9pcnczSitJQmdzeGFFYTdSdFFaOTBLZW1WUU5qNTJNeEo0bGdEaytOU2lkN01SRm8vOGhTQXB3SDRobnBEN1BkNldzaDJudzNyQXFTbkkxTEJPaEFIYWJRMnNIN3JUSS9rSDgzcTk4dW05NzRBeFBrTWRXWmp1UjRQUGxVeDFTOERpdDBqVkFiSVNJQktZYzdPWEpoVjhrekpNejdoeXA5bVNnVWYwSU9KRkp0cXdNVDJKTVc3RDR0VlE5TVBydk90T2I4OGI4QVJJejhhY2c4Y1h1ZENMMk9EL0VuUHVMaFFXU0ZTOVM5cmIzMUF6emRxdXhVNEViM3M4OWVmMkRxVkRwNXc0NkY0MVpQaGRBN0xZOUJLaG10MnNBZmlQT0xJRmhWM1V6TGd3NDV1NHBFRlRTMlhGT1NxSFdOODRwMmdCdDU3SWNMeDFYV2VmZzdGckRzTXlEb2x4QnNxSUN1b2FmMjE5QnpLK3gxM1k1aDNuRitMMzk2THpLNFQ2cDAxeG01N2kvYTJtVEFMRWhpUmZaekJXOG1xMndJOWhJNjFVcnk2VXBoNU40MzdmLzFabkd2ZmgxUWwwaXR1c0xKTDJROGprTDdCdFdnTTZuZTlPRGRLYmlMUTlLWHQyQklKNzVjV2NsVCtraktYckV4Ni8tLXpKY3RybmlsSUxKYXZnNG1JS1o2Q3c9PQ==--f7f5ce0e47ac47100559c0ebccca0e9dd3e02dce"}
  * rack.request.cookie_string                     : _redmine_session=NjkxeWdCeFBNb1lQYi9udGFSeWJwTHdsR2NBdnlqc3p6ektmRld6OGQvMzBqTjVoNm0vTUgzWm5WWkZOZVRoMDRmUHBaUXoyMDVuQlFncFk3aWdpNkJRSE56Wi91UW94WTFlSnVDWUp6V3VOb2xITXF2a0xLZkduMGo2Nm1tY1Vvdk9BQkxDdWF5Q1dUSlFKbHlPWWVXdCtqSURRZDV2NmMrYTF6S2RieGc1TzBpSzN2OEd3aXdNSmd0elowaE05cFFMTjV0TEhJclVUdi9pcnczSitJQmdzeGFFYTdSdFFaOTBLZW1WUU5qNTJNeEo0bGdEaytOU2lkN01SRm8vOGhTQXB3SDRobnBEN1BkNldzaDJudzNyQXFTbkkxTEJPaEFIYWJRMnNIN3JUSS9rSDgzcTk4dW05NzRBeFBrTWRXWmp1UjRQUGxVeDFTOERpdDBqVkFiSVNJQktZYzdPWEpoVjhrekpNejdoeXA5bVNnVWYwSU9KRkp0cXdNVDJKTVc3RDR0VlE5TVBydk90T2I4OGI4QVJJejhhY2c4Y1h1ZENMMk9EL0VuUHVMaFFXU0ZTOVM5cmIzMUF6emRxdXhVNEViM3M4OWVmMkRxVkRwNXc0NkY0MVpQaGRBN0xZOUJLaG10MnNBZmlQT0xJRmhWM1V6TGd3NDV1NHBFRlRTMlhGT1NxSFdOODRwMmdCdDU3SWNMeDFYV2VmZzdGckRzTXlEb2x4QnNxSUN1b2FmMjE5QnpLK3gxM1k1aDNuRitMMzk2THpLNFQ2cDAxeG01N2kvYTJtVEFMRWhpUmZaekJXOG1xMndJOWhJNjFVcnk2VXBoNU40MzdmLzFabkd2ZmgxUWwwaXR1c0xKTDJROGprTDdCdFdnTTZuZTlPRGRLYmlMUTlLWHQyQklKNzVjV2NsVCtraktYckV4Ni8tLXpKY3RybmlsSUxKYXZnNG1JS1o2Q3c9PQ%3D%3D--f7f5ce0e47ac47100559c0ebccca0e9dd3e02dce
  * rack.request.query_hash                        : {}
  * rack.request.query_string                      :
  * rack.run_once                                  : false
  * rack.session                                   : #<ActionDispatch::Request::Session:0x007f51e443fdb8>
  * rack.session.options                           : #<ActionDispatch::Request::Session::Options:0x007f51e443fd68>
  * rack.url_scheme                                : http
  * rack.version                                   : [1, 0]

-------------------------------
Backtrace:
-------------------------------

  plugins/redmine_issues_tree_view/lib/issue_query_patch.rb:15:in `issues'
  plugins/redmine_pivot_table/app/controllers/pivottables_controller.rb:64:in `index'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'