Defect #1426: open redmine_work_time occured 500 error - Work Time - r-labs

Defect #1426

open redmine_work_time occured 500 error

Added by Steven Wong over 2 years ago. Updated over 2 years ago.

Status:

終了（Closed）

Priority:

通常（Normal）

Assignee:

Steven Wong

Target version:

0.3.3

Start date:

08/15/2016

Due date:

% Done:

100%

Estimated time:

Description

my environment

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

error log

Started GET "/work_time/show/demo" for 192.168.60.238 at 2016-08-15 19:36:07 +0800
Processing by WorkTimeController#show as HTML
  Parameters: {"id"=>"demo"}
  Current user: hui.wang (id=8)
Completed 500 Internal Server Error in 25ms (ActiveRecord: 8.4ms)
  Rendered /usr/local/rvm/gems/ruby-2.2.4@newgemset/gems/exception_notification-4.2.1/lib/exception_notifier/views/exception_notifier/_request.text.erb (0.3ms)
  Rendered /usr/local/rvm/gems/ruby-2.2.4@newgemset/gems/exception_notification-4.2.1/lib/exception_notifier/views/exception_notifier/_title.text.erb (0.2ms)
  Rendered /usr/local/rvm/gems/ruby-2.2.4@newgemset/gems/exception_notification-4.2.1/lib/exception_notifier/views/exception_notifier/_session.text.erb (1.3ms)
  Rendered /usr/local/rvm/gems/ruby-2.2.4@newgemset/gems/exception_notification-4.2.1/lib/exception_notifier/views/exception_notifier/_title.text.erb (0.1ms)
  Rendered /usr/local/rvm/gems/ruby-2.2.4@newgemset/gems/exception_notification-4.2.1/lib/exception_notifier/views/exception_notifier/_environment.text.erb (2.0ms)
  Rendered /usr/local/rvm/gems/ruby-2.2.4@newgemset/gems/exception_notification-4.2.1/lib/exception_notifier/views/exception_notifier/_title.text.erb (0.1ms)
  Rendered /usr/local/rvm/gems/ruby-2.2.4@newgemset/gems/exception_notification-4.2.1/lib/exception_notifier/views/exception_notifier/_backtrace.text.erb (0.1ms)
  Rendered /usr/local/rvm/gems/ruby-2.2.4@newgemset/gems/exception_notification-4.2.1/lib/exception_notifier/views/exception_notifier/_title.text.erb (0.1ms)
  Rendered /usr/local/rvm/gems/ruby-2.2.4@newgemset/gems/exception_notification-4.2.1/lib/exception_notifier/views/exception_notifier/exception_notification.text.erb (11.9ms)

ActiveRecord::StatementInvalid (Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':conditions=>["parent_id = 5486"]}) FROM `issues`' at line 1: SELECT COUNT({:conditions=>["parent_id = 5486"]}) FROM `issues`):
  plugins/redmine_work_time/app/controllers/work_time_controller.rb:1366:in `make_pack_issue'
  plugins/redmine_work_time/app/controllers/work_time_controller.rb:1215:in `block in make_pack'
  plugins/redmine_work_time/app/controllers/work_time_controller.rb:1207:in `make_pack'
  plugins/redmine_work_time/app/controllers/work_time_controller.rb:42:in `show'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'