seems to break with 1.1.3

[wrivas]

will destroy (error 500) my/page when adding custom query. only way to restore is to copy db from backup.

here is the log :

Processing MyController#page (for 192.168.xxxxx at 2011-06-04 02:53:59) [GET]
Parameters: {"action"=>"page", "controller"=>"my"}
Rendering template within layouts/base
Rendering my/page

ActionView::TemplateError (Couldn't find Query with ID=5) on line #34 of vendor/plugins/redmine_my_page_queries/app/views/my/blocks/_issues_custom_query_1.rhtml:
31: rescue ActiveRecord::RecordNotFound
32: @user.pref[:others][:custom_query1][:id]=5
33: @user.pref.save
34: @query = Query.find(@user.pref[:others][:custom_query1][:id].to_i)
35: end
36: custom_issues = @query.issues(:include => [:assigned_to, :tracker, :priority, :category, :fixed_version],
37: :limit => @user.pref[:others][:custom_query1][:limit] )

/usr/lib/ruby/1.8/active_record/base.rb:1620:in `find_one'
/usr/lib/ruby/1.8/active_record/base.rb:1603:in `find_from_ids'
/usr/lib/ruby/1.8/active_record/base.rb:620:in `find'
vendor/plugins/redmine_my_page_queries/app/views/my/blocks/_issues_custom_query_1.rhtml:34:in `_run_rhtml_vendor47plugins47redmine_my_page_queries47app47views47my47blocks47_issues_custom_query_146rhtml_locals_issues_custom_query_1_object_user'
/usr/lib/ruby/1.8/action_view/renderable.rb:34:in `send'
/usr/lib/ruby/1.8/action_view/renderable.rb:34:in `render'
/usr/lib/ruby/1.8/action_view/base.rb:306:in `with_template'
/usr/lib/ruby/1.8/action_view/renderable.rb:30:in `render'
/usr/lib/ruby/1.8/action_view/renderable_partial.rb:20:in `render'
/usr/lib/ruby/1.8/action_controller/benchmarking.rb:30:in `benchmark'
/usr/lib/ruby/1.8/action_view/renderable_partial.rb:19:in `render'
/usr/lib/ruby/1.8/action_view/template.rb:205:in `render_template'
/usr/lib/ruby/1.8/action_view/renderable_partial.rb:44:in `render_partial'
/usr/lib/ruby/1.8/action_view/partials.rb:184:in `render_partial'
/usr/lib/ruby/1.8/action_view/base.rb:267:in `render'
app/views/my/page.rhtml:11:in `_run_rhtml_app47views47my47page46rhtml'
app/views/my/page.rhtml:8:in `each'
app/views/my/page.rhtml:8:in `_run_rhtml_app47views47my47page46rhtml'
/usr/lib/ruby/1.8/action_view/renderable.rb:34:in `send'
/usr/lib/ruby/1.8/action_view/renderable.rb:34:in `render'
/usr/lib/ruby/1.8/action_view/base.rb:306:in `with_template'
/usr/lib/ruby/1.8/action_view/renderable.rb:30:in `render'
/usr/lib/ruby/1.8/action_view/template.rb:205:in `render_template'
/usr/lib/ruby/1.8/action_view/base.rb:265:in `render'
/usr/lib/ruby/1.8/action_view/base.rb:348:in `_render_with_layout'
/usr/lib/ruby/1.8/action_view/base.rb:262:in `render'
/usr/lib/ruby/1.8/action_controller/base.rb:1252:in `render_for_file'
/usr/lib/ruby/1.8/action_controller/base.rb:936:in `render_without_benchmark'
/usr/lib/ruby/1.8/action_controller/benchmarking.rb:51:in `render'
/usr/lib/ruby/1.8/action_controller/benchmarking.rb:51:in `render'
/usr/lib/ruby/1.8/action_controller/base.rb:1328:in `default_render'
/usr/lib/ruby/1.8/action_controller/base.rb:1334:in `perform_action_without_filters'
/usr/lib/ruby/1.8/action_controller/filters.rb:617:in `call_filters'
/usr/lib/ruby/1.8/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/usr/lib/ruby/1.8/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/usr/lib/ruby/1.8/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/usr/lib/ruby/1.8/action_controller/rescue.rb:160:in `perform_action_without_flash'
/usr/lib/ruby/1.8/action_controller/flash.rb:151:in `perform_action'
/usr/lib/ruby/1.8/action_controller/base.rb:532:in `send'
/usr/lib/ruby/1.8/action_controller/base.rb:532:in `process_without_filters'
/usr/lib/ruby/1.8/action_controller/filters.rb:606:in `process'
/usr/lib/ruby/1.8/action_controller/base.rb:391:in `process'
/usr/lib/ruby/1.8/action_controller/base.rb:386:in `call'
/usr/lib/ruby/1.8/action_controller/routing/route_set.rb:438:in `call'
/usr/lib/ruby/1.8/action_controller/dispatcher.rb:87:in `dispatch'
/usr/lib/ruby/1.8/action_controller/dispatcher.rb:121:in `_call'
/usr/lib/ruby/1.8/action_controller/dispatcher.rb:130:in `build_middleware_stack'
/usr/lib/ruby/1.8/active_record/query_cache.rb:29:in `call'
/usr/lib/ruby/1.8/active_record/query_cache.rb:29:in `call'
/usr/lib/ruby/1.8/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/usr/lib/ruby/1.8/active_record/query_cache.rb:9:in `cache'
/usr/lib/ruby/1.8/active_record/query_cache.rb:28:in `call'
/usr/lib/ruby/1.8/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
/usr/lib/ruby/1.8/action_controller/string_coercion.rb:25:in `call'
/usr/lib/ruby/1.8/rack/head.rb:9:in `call'
/usr/lib/ruby/1.8/rack/methodoverride.rb:24:in `call'
/usr/lib/ruby/1.8/action_controller/params_parser.rb:15:in `call'
/usr/lib/ruby/1.8/action_controller/session/cookie_store.rb:99:in `call'
/usr/lib/ruby/1.8/action_controller/failsafe.rb:26:in `call'
/usr/lib/ruby/1.8/rack/lock.rb:11:in `call'
/usr/lib/ruby/1.8/rack/lock.rb:11:in `synchronize'
/usr/lib/ruby/1.8/rack/lock.rb:11:in `call'
/usr/lib/ruby/1.8/action_controller/dispatcher.rb:106:in `call'
/usr/lib/ruby/1.8/rack/content_length.rb:13:in `call'
/usr/lib/ruby/1.8/rack/handler/fastcgi.rb:57:in `serve'
public/dispatch.fcgi:24

Rendering /usr/share/redmine/public/500.html (500 Internal Server Error)

tested on debian squeeze, redmine pulled from unstable with dependencies.

[akzhan]

Try to use this plugin from my fork. it should be not fail anymore.

[shadowpanther]

Actually, when you are adding new custom issue block, this block's query id is set to 5. You don't have query with id=5 in your installation, so it fails. You can go to user_preferences table and edit your user's others field, so custom query has existing query id. Or, you can delete custom query line from your home page layout.