Project

General

Profile

Defect #1426

open redmine_work_time occured 500 error

Added by Steven Wong almost 4 years ago. Updated almost 4 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'

#1

Updated by Tomohisa Kusukawa almost 4 years ago

  • Status changed from 新規（New） to 担当（Assigned）
  • Assignee set to Tomohisa Kusukawa
  • Target version set to 0.3.3

Thank you for your report.

#2

Updated by Steven Wong almost 4 years ago

please check Defect #1425， thanks

#3

Updated by Anonymous almost 4 years ago

  • Status changed from 担当（Assigned） to 解決（Resolved）
  • % Done changed from 0 to 100

更新履歴 commit:6f860cdbeefe で適用されました。

#4

Updated by Tomohisa Kusukawa almost 4 years ago

  • Assignee changed from Tomohisa Kusukawa to Steven Wong

I fixed this problem in commit:6f860cdbeefe .
Would you please check the defect fixes.

#5

Updated by Tomohisa Kusukawa almost 4 years ago

  • Status changed from 解決（Resolved） to 終了（Closed）

I released WorkTime0.3.3 with this fixes.
Thank you.

Also available in: Atom PDF