Actions
Defect #1215
closedwork_time 0.2.10 Internal error on sqlite3
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'
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をダウンロードできます。
Updated by NAITOH Jun over 11 years ago
修正ありがとうございます。
1215を試してみたところ、Redmine 2.2.2 及び 2.3.0 (sqlite3)で Internal error の発生はなくなりちゃんと動作しております。
問題なさそうです。
Updated by Tomohisa Kusukawa over 11 years ago
- % Done changed from 0 to 100
commit:d6e9eea37ae2 にてdefaultにマージしましたので、
ステータスをクローズにします。
Updated by Tomohisa Kusukawa over 11 years ago
- Status changed from 担当(Assigned) to 終了(Closed)
Actions