Project

General

Profile

Actions

Defect #1215

closed

work_time 0.2.10 Internal error on sqlite3

Added by NAITOH Jun over 11 years ago. Updated over 11 years ago.

Status:
終了(Closed)
Priority:
通常(Normal)
Target version:
Start date:
03/24/2013
Due date:
% Done:

100%

Estimated time:

Description

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'
Actions #1

Updated by Tomohisa Kusukawa over 11 years ago

  • Status changed from 新規(New) to 担当(Assigned)
  • Assignee set to Tomohisa Kusukawa
  • Target version set to 0.2.11

ご連絡、ありがとうございます。

sqlite3を扱ったことがなく確認できていないのですが、
Redmine本体のコードに習って修正してみましたので
ご確認頂けると助かります。

Mercurialを使っているようであれば、
https://bitbucket.org/kusu/redmine_work_time
からPullして commit:57deca3316e2 にUpdate

Zipをダウンロードされているのであれば、
https://bitbucket.org/kusu/redmine_work_time/downloads
のBranchesタブから
1215のzipをダウンロードできます。

Actions #2

Updated by NAITOH Jun over 11 years ago

修正ありがとうございます。
1215を試してみたところ、Redmine 2.2.2 及び 2.3.0 (sqlite3)で Internal error の発生はなくなりちゃんと動作しております。

問題なさそうです。:)

Actions #3

Updated by Tomohisa Kusukawa over 11 years ago

早速の確認、ありがとうございます!

Actions #4

Updated by Tomohisa Kusukawa over 11 years ago

  • % Done changed from 0 to 100

commit:d6e9eea37ae2 にてdefaultにマージしましたので、
ステータスをクローズにします。

Actions #5

Updated by Tomohisa Kusukawa over 11 years ago

  • Status changed from 担当(Assigned) to 終了(Closed)
Actions

Also available in: Atom PDF