search

deecay / redmine_pivot_table

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

open activity tab occured 500 Error #26

Open archonwang opened 7 years ago

archonwang commented 7 years ago

open activity tab occured 500 Error, my environment is 

Environment:
  Redmine version                3.3.1.stable.15949
  Ruby version                   2.2.4-p230 (2015-12-16) [x86_64-linux]
  Rails version                  4.2.7.1
  Environment                    production
  Database adapter               Mysql2

error tracing log is

A NoMethodError occurred in pivottables#index:

undefined method where' for #<Hash:0x007f8d54fa68b8> lib/plugins/acts_as_activity_provider/lib/acts_as_activity_provider.rb:59:infind_events'

Request:

  • URL : http://192.168.1.41/projects/zmss/pivottables?table=activity
    • HTTP Method: GET
    • IP address : 192.168.60.238
    • Parameters : {"table"=>"activity", "controller"=>"pivottables", "action"=>"index", "project_id"=>"zmss"}
    • Timestamp : 2016-11-11 03:30:06 UTC
    • Server : jira
    • Rails root : /opt/redmine-3.3
    • Process: 27643

Session:

  • session id: "b5c987869e581585a1268bb160683f10"
  • data: {"session_id"=>"b5c987869e581585a1268bb160683f10", "user_id"=>8, "tk"=>"60645f1453769d5cd2827f8839d1cd4027e866d8", "_csrf_token"=>"Y8gVMHLDxNswdzpnw+69KeG3XQUs3RyS829OonSdIiM=", "recent_projects"=>[5, 2], "query"=> {:project_id=>5, :filters=>{"status_id"=>{:operator=>"o", :values=>[""]}}, :group_by=>"parent", :column_names=>nil, :totalable_names=>[:estimated_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,en;q=0.6,ja;q=0.4
  • HTTP_CONNECTION : keep-alive
  • HTTP_COOKIE : autologin=2af2af03f0555279f2545e5901c0ddff9217f087; _redmine_session=M3Bya0ZZV3NuSXYxTFREL3UxZ2lBdm5tbk10RG1QT1IyYmRUNy9TUzBNam1xaHlSNHE5d29GViszZVA5SXhKWGI1Y3dqNXZvSTRjTkFNUmk4QU81TERoUjZCakxBWTZiSE9XNTRIR0pSYmcvY2paWXpQMTJGU0gxZ0EvOW1idS8zN0cyayttK3FYUUR4ZzhMR1B1RlBLVCtXWTAyK0lncXdtc3Raa01JODVjbjY4ZEdQN2VXWlNraDhacSsxbGJzcUJHWVh2aXA4a2xpSXV4Q0QrQlZjUk9DcUdHZkl2dzRRZlVoY2xIeFQwUTNWOExmOGFCZVREYlZLMFI1bFVrU3JoV1A2cEZCOGlwYm9TZDNFZHE5ekhVVGFlY3BTWEFlMkgxU2hMcVVoK25USC9aL2ZxVFc2dDhiSXY4L21yRWlKb0NRS3hzSXRWWTV1N2FyNGhLcmtieVlicCtId05IaG0wNDhVRzB1UHpHVnMwN01lRCt1MDhVRkc5ZE9LWGhZem1vc3hxWXUvaXk4NGI2Q1NkaG82VU1DZDdXQ1grUmp5WThQajNGSHBGSmhxRlQ4VFNwMlNZcEo1cXdWKzBlVWJKZ1AxbHRxditORjFXb0o3QUpUSFkyeHVrdWhRUjhVeThnTFdhMjNYejlaVk1iNUoyaG1Cbmx4Vkp2dUJVci8yYUI1NENLaGNPN0Y4Yy9LRXV2TklZcUlCdE1EZUVXYlhZUTBoemVyWWpDcEt5OE1XenhXekREZ1dmcjdHSkhCNlhDREZUc3VLaHkwMmFBQ2VLK1BDZz09LS1ZTUlRTXFLYXozQnQ3bk1ES2pMOFFnPT0%3D--e7fc229b471acfedef94e7cffa896758030488df
  • HTTP_HOST : 192.168.1.41
  • HTTP_UPGRADE_INSECURE_REQUESTS : 1
  • HTTP_USER_AGENT : Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.87 Safari/537.36
  • HTTP_VERSION : HTTP/1.1
  • ORIGINAL_FULLPATH : /projects/zmss/pivottables?table=activity
  • ORIGINAL_SCRIPT_NAME :
  • PATH_INFO : /projects/zmss/pivottables
  • QUERY_STRING : table=activity
  • REMOTE_ADDR : 192.168.60.238
  • REQUEST_METHOD : GET
  • REQUEST_PATH : /projects/zmss/pivottables
  • REQUEST_URI : /projects/zmss/pivottables?table=activity
  • ROUTES_40474240_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 : #
  • action_dispatch.backtrace_cleaner : #
  • action_dispatch.cookies : #
  • 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 : #
  • action_dispatch.logger : #
  • action_dispatch.parameter_filter : [:password]
  • action_dispatch.redirect_filter : []
  • action_dispatch.remote_ip : 192.168.60.238
  • action_dispatch.request.content_type :
  • action_dispatch.request.formats : [#<Mime::Type:0x00000002a642b0 @synonyms=["application/xhtml+xml"], @symbol=:html, @string="text/html", @hash=-37992071380862222>]
  • action_dispatch.request.parameters : {"table"=>"activity", "controller"=>"pivottables", "action"=>"index", "project_id"=>"zmss"}
  • action_dispatch.request.path_parameters : {:controller=>"pivottables", :action=>"index", :project_id=>"zmss"}
  • action_dispatch.request.query_parameters : {"table"=>"activity"}
  • action_dispatch.request.request_parameters : {}
  • action_dispatch.request.unsigned_session_cookie: {"session_id"=>"b5c987869e581585a1268bb160683f10", "user_id"=>8, "tk"=>"60645f1453769d5cd2827f8839d1cd4027e866d8", "_csrf_token"=>"Y8gVMHLDxNswdzpnw+69KeG3XQUs3RyS829OonSdIiM=", "recent_projects"=>[5, 2], "query"=>{:project_id=>5, :filters=>{"status_id"=>{:operator=>"o", :values=>[""]}}, :group_by=>"parent", :column_names=>nil, :totalable_names=>[:estimated_hours]}, "issues_index_sort"=>"id:desc"}
  • action_dispatch.request_id : 5f6e66cc-b01b-4584-9fc6-40b3b49a781e
  • action_dispatch.routes : #
  • 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 : #
  • rack.errors : #
  • rack.input : #
  • rack.multiprocess : false
  • rack.multithread : true
  • rack.request.cookie_hash : {"autologin"=>"2af2af03f0555279f2545e5901c0ddff9217f087", "_redmine_session"=>"M3Bya0ZZV3NuSXYxTFREL3UxZ2lBdm5tbk10RG1QT1IyYmRUNy9TUzBNam1xaHlSNHE5d29GViszZVA5SXhKWGI1Y3dqNXZvSTRjTkFNUmk4QU81TERoUjZCakxBWTZiSE9XNTRIR0pSYmcvY2paWXpQMTJGU0gxZ0EvOW1idS8zN0cyayttK3FYUUR4ZzhMR1B1RlBLVCtXWTAyK0lncXdtc3Raa01JODVjbjY4ZEdQN2VXWlNraDhacSsxbGJzcUJHWVh2aXA4a2xpSXV4Q0QrQlZjUk9DcUdHZkl2dzRRZlVoY2xIeFQwUTNWOExmOGFCZVREYlZLMFI1bFVrU3JoV1A2cEZCOGlwYm9TZDNFZHE5ekhVVGFlY3BTWEFlMkgxU2hMcVVoK25USC9aL2ZxVFc2dDhiSXY4L21yRWlKb0NRS3hzSXRWWTV1N2FyNGhLcmtieVlicCtId05IaG0wNDhVRzB1UHpHVnMwN01lRCt1MDhVRkc5ZE9LWGhZem1vc3hxWXUvaXk4NGI2Q1NkaG82VU1DZDdXQ1grUmp5WThQajNGSHBGSmhxRlQ4VFNwMlNZcEo1cXdWKzBlVWJKZ1AxbHRxditORjFXb0o3QUpUSFkyeHVrdWhRUjhVeThnTFdhMjNYejlaVk1iNUoyaG1Cbmx4Vkp2dUJVci8yYUI1NENLaGNPN0Y4Yy9LRXV2TklZcUlCdE1EZUVXYlhZUTBoemVyWWpDcEt5OE1XenhXekREZ1dmcjdHSkhCNlhDREZUc3VLaHkwMmFBQ2VLK1BDZz09LS1ZTUlRTXFLYXozQnQ3bk1ES2pMOFFnPT0=--e7fc229b471acfedef94e7cffa896758030488df"}
  • rack.request.cookie_string : autologin=2af2af03f0555279f2545e5901c0ddff9217f087; _redmine_session=M3Bya0ZZV3NuSXYxTFREL3UxZ2lBdm5tbk10RG1QT1IyYmRUNy9TUzBNam1xaHlSNHE5d29GViszZVA5SXhKWGI1Y3dqNXZvSTRjTkFNUmk4QU81TERoUjZCakxBWTZiSE9XNTRIR0pSYmcvY2paWXpQMTJGU0gxZ0EvOW1idS8zN0cyayttK3FYUUR4ZzhMR1B1RlBLVCtXWTAyK0lncXdtc3Raa01JODVjbjY4ZEdQN2VXWlNraDhacSsxbGJzcUJHWVh2aXA4a2xpSXV4Q0QrQlZjUk9DcUdHZkl2dzRRZlVoY2xIeFQwUTNWOExmOGFCZVREYlZLMFI1bFVrU3JoV1A2cEZCOGlwYm9TZDNFZHE5ekhVVGFlY3BTWEFlMkgxU2hMcVVoK25USC9aL2ZxVFc2dDhiSXY4L21yRWlKb0NRS3hzSXRWWTV1N2FyNGhLcmtieVlicCtId05IaG0wNDhVRzB1UHpHVnMwN01lRCt1MDhVRkc5ZE9LWGhZem1vc3hxWXUvaXk4NGI2Q1NkaG82VU1DZDdXQ1grUmp5WThQajNGSHBGSmhxRlQ4VFNwMlNZcEo1cXdWKzBlVWJKZ1AxbHRxditORjFXb0o3QUpUSFkyeHVrdWhRUjhVeThnTFdhMjNYejlaVk1iNUoyaG1Cbmx4Vkp2dUJVci8yYUI1NENLaGNPN0Y4Yy9LRXV2TklZcUlCdE1EZUVXYlhZUTBoemVyWWpDcEt5OE1XenhXekREZ1dmcjdHSkhCNlhDREZUc3VLaHkwMmFBQ2VLK1BDZz09LS1ZTUlRTXFLYXozQnQ3bk1ES2pMOFFnPT0%3D--e7fc229b471acfedef94e7cffa896758030488df
  • rack.request.query_hash : {"table"=>"activity"}
  • rack.request.query_string : table=activity
  • rack.run_once : false
  • rack.session : #
  • rack.session.options : #
  • rack.url_scheme : http
  • rack.version : [1, 0]

Backtrace:

lib/plugins/acts_as_activity_provider/lib/acts_as_activity_provider.rb:59:in find_events' lib/redmine/activity/fetcher.rb:91:inblock (2 levels) in events' lib/redmine/activity/fetcher.rb:90:in each' lib/redmine/activity/fetcher.rb:90:inblock in events' lib/redmine/activity/fetcher.rb:89:in each' lib/redmine/activity/fetcher.rb:89:inevents' plugins/redmine_pivot_table/app/controllers/pivottables_controller.rb:51:in index' lib/redmine/sudo_mode.rb:63:insudo_mode'