r-labs » Work Time

redmine_work_time-0.2.10 で
ログイン後、Redmine 右上の「工数」をクリックするとInternal errorが発生します。

redmine_work_time-0.2.8 では発生しません。

• CentOS 6
• ruby-1.9.3-p392
• Redmine 2.2.2 及び 2.3.0

Started GET "/222/work_time/index" for 192.168.56.1 at 2013-03-24 11:54:49 +0900
Processing by WorkTimeController#index as HTML
  Current user: admin (id=1)
Completed 500 Internal Server Error in 22ms

ActiveRecord::StatementInvalid (SQLite3::SQLException: no such column: FALSE: SELECT "issues".* FROM "issues" INNER JOIN issue_statuses ist on ist.id = issues.status_id 
WHERE (1 = 1
                         and ((issues.author_id = 1
                           and issues.created_on >= '2013-03-24 00:00:00.000000'
                           and issues.created_on < '2013-03-25 00:00:00.000000')
                           or (issues.assigned_to_id = 1
                           and issues.start_date < '2013-03-25 00:00:00.000000'
                           and ist.is_closed IS FALSE)
                           or (exists (select 1 from journals
                                       where journals.journalized_id = issues.id
                                         and journals.journalized_type = 'Issue'
                                         and journals.user_id = 1
                                         and journals.created_on >= '2013-03-24 00:00:00.000000'
                                         and journals.created_on < '2013-03-25 00:00:00.000000'))))):
  sqlite3 (1.3.7) lib/sqlite3/database.rb:91:in `initialize'
  sqlite3 (1.3.7) lib/sqlite3/database.rb:91:in `new'
  sqlite3 (1.3.7) lib/sqlite3/database.rb:91:in `prepare'
  activerecord (3.2.11) lib/active_record/connection_adapters/sqlite_adapter.rb:246:in `block in exec_query'
  activerecord (3.2.11) lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
  activesupport (3.2.11) lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  activerecord (3.2.11) lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
  activerecord (3.2.11) lib/active_record/connection_adapters/sqlite_adapter.rb:242:in `exec_query'
  activerecord (3.2.11) lib/active_record/connection_adapters/sqlite_adapter.rb:467:in `select'
  activerecord (3.2.11) lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all'
  activerecord (3.2.11) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `block in select_all'
  activerecord (3.2.11) lib/active_record/connection_adapters/abstract/query_cache.rb:75:in `cache_sql'
  activerecord (3.2.11) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all'
  activerecord (3.2.11) lib/active_record/querying.rb:38:in `block in find_by_sql'
  activerecord (3.2.11) lib/active_record/explain.rb:40:in `logging_query_plan'
  activerecord (3.2.11) lib/active_record/querying.rb:37:in `find_by_sql'
  activerecord (3.2.11) lib/active_record/relation.rb:174:in `block in exec_queries'
  activerecord (3.2.11) lib/active_record/identity_map.rb:72:in `without'
  activerecord (3.2.11) lib/active_record/relation.rb:173:in `exec_queries'
  activerecord (3.2.11) lib/active_record/relation.rb:160:in `block in to_a'
  activerecord (3.2.11) lib/active_record/explain.rb:40:in `logging_query_plan'
  activerecord (3.2.11) lib/active_record/relation.rb:159:in `to_a'
  activerecord (3.2.11) lib/active_record/relation/finder_methods.rb:159:in `all'
  activerecord (3.2.11) lib/active_record/relation/finder_methods.rb:105:in `find'
  activerecord (3.2.11) lib/active_record/relation/finder_methods.rb:101:in `find'
  activerecord (3.2.11) lib/active_record/querying.rb:5:in `find'
  plugins/redmine_work_time/app/controllers/work_time_controller.rb:1062:in `make_pack'
  plugins/redmine_work_time/app/controllers/work_time_controller.rb:19:in `index'
  actionpack (3.2.11) lib/action_controller/metal/implicit_render.rb:4:in `send_action'
  actionpack (3.2.11) lib/abstract_controller/base.rb:167:in `process_action'
  actionpack (3.2.11) lib/action_controller/metal/rendering.rb:10:in `process_action'
  actionpack (3.2.11) lib/abstract_controller/callbacks.rb:18:in `block in process_action'
  activesupport (3.2.11) lib/active_support/callbacks.rb:458:in `_run__92399033__process_action__857334319__callbacks'
  activesupport (3.2.11) lib/active_support/callbacks.rb:405:in `__run_callback'
  activesupport (3.2.11) lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks'
  activesupport (3.2.11) lib/active_support/callbacks.rb:81:in `run_callbacks'
  actionpack (3.2.11) lib/abstract_controller/callbacks.rb:17:in `process_action'
  actionpack (3.2.11) lib/action_controller/metal/rescue.rb:29:in `process_action'
  actionpack (3.2.11) lib/action_controller/metal/instrumentation.rb:30:in `block in process_action'
  activesupport (3.2.11) lib/active_support/notifications.rb:123:in `block in instrument'
  activesupport (3.2.11) lib/active_support/notifications/instrumenter.rb:20:in `instrument'
  activesupport (3.2.11) lib/active_support/notifications.rb:123:in `instrument'
  actionpack (3.2.11) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
  actionpack (3.2.11) lib/action_controller/metal/params_wrapper.rb:207:in `process_action'
  activerecord (3.2.11) lib/active_record/railties/controller_runtime.rb:18:in `process_action'
  actionpack (3.2.11) lib/abstract_controller/base.rb:121:in `process'
  actionpack (3.2.11) lib/abstract_controller/rendering.rb:45:in `process'
  actionpack (3.2.11) lib/action_controller/metal.rb:203:in `dispatch'
  actionpack (3.2.11) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
  actionpack (3.2.11) lib/action_controller/metal.rb:246:in `block in action'
  actionpack (3.2.11) lib/action_dispatch/routing/route_set.rb:73:in `call'
  actionpack (3.2.11) lib/action_dispatch/routing/route_set.rb:73:in `dispatch'
  actionpack (3.2.11) lib/action_dispatch/routing/route_set.rb:36:in `call'
  journey (1.0.4) lib/journey/router.rb:68:in `block in call'
  journey (1.0.4) lib/journey/router.rb:56:in `each'