open activity tab occured 500 Error

[archonwang]

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:in find_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_REFERER : http://192.168.1.41/projects/zmss/pivottables
  • 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 : #PivottablesController:0x007f8d756f1e40
  • action_dispatch.backtrace_cleaner : #Rails::BacktraceCleaner:0x000000048dff00
  • action_dispatch.cookies : #ActionDispatch::Cookies::CookieJar:0x007f8d5416fc90
  • 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:0x000000047bdf78
  • action_dispatch.logger : #ActiveSupport::Logger:0x00000004eaf4f8
  • 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 : #ActionDispatch::Routing::RouteSet:0x00000004d32d00
  • 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:0x007f8d54125b18
  • rack.errors : #IO:0x000000010f5590
  • rack.input : #StringIO:0x007f8d54126d60
  • 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 : #ActionDispatch::Request::Session:0x007f8d756f3c90
  • rack.session.options : #ActionDispatch::Request::Session::Options:0x007f8d756f3c40
  • 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:in block (2 levels) in events'
lib/redmine/activity/fetcher.rb:90:in each' lib/redmine/activity/fetcher.rb:90:in block in events'
lib/redmine/activity/fetcher.rb:89:in each' lib/redmine/activity/fetcher.rb:89:in events'
plugins/redmine_pivot_table/app/controllers/pivottables_controller.rb:51:in index' lib/redmine/sudo_mode.rb:63:in sudo_mode'