I'm having the same issue with the fix posted above by Jakub.

Started GET "/redmine/queries/2/edit" for 192.32.0.146 at 2013-05-15 15:26:42 +0000
Processing by QueriesController#edit as HTML
  Parameters: {"id"=>"2"}
  Current user: avanino (id=1)
  Rendered queries/_filters.html.erb (30.3ms)
  Rendered queries/_columns.html.erb (99.0ms)
  Rendered plugins/redmine_smart_issues_sort/app/views/queries/_form.html.erb (146.2ms)
  Rendered queries/edit.html.erb within layouts/base (148.3ms)
Completed 500 Internal Server Error in 160ms

ActionView::Template::Error (undefined local variable or method `tag_name' for #<#<Class:0x007f06c8e9d3d0>:0x007f06c8ea4f40>):
    17:     <td>
    18:       <%= label_tag "selected_columns", l(:description_selected_columns) %>
    19:       <br />
    20:       <%= select_tag tag_name,
    21:               options_for_select(query_selected_inline_columns_options(query)),
    22:               :id => 'selected_columns', :multiple => true, :size => 10, :style => "width:150px",
    23:               :ondblclick => "moveOptions(this.form.selected_columns, this.form.available_columns);" %>
  app/views/queries/_columns.html.erb:20:in `_app_views_queries__columns_html_erb__2774146173728988389_69833559840520'
  app/views/queries/edit.html.erb:4:in `block in _app_views_queries_edit_html_erb___2958167760804875963_69833558672460'
  app/views/queries/edit.html.erb:3:in `_app_views_queries_edit_html_erb___2958167760804875963_69833558672460'

1. And wrote:

Andrey, I'll publish fixed plugin at GitHub soon. Wait a while, please.

I'm still waiting for plugin fix. Did you forgot about it?

Hi, this is great plugin, but it does not work for 2.3 version. Pretty please, can this be fixed? Thank you very much!

sorry, was in wrong thread...

Hi all,
I prepared a patch for 2.3.
Please report if it is full functional

That patch doesn't seem to be working for me.

root@mayerredmine:/opt/bitnami/apps/redmine/htdocs/plugins/redmine_smart_issues_sort# patch -i redmine_smart_issues_sort-2.3.patch 
can't find file to patch at input line 5
Perhaps you should have used the -p or --strip option?
The text leading up to this was:
--------------------------
|diff --git a/plugins/redmine_smart_issues_sort/lib/issues_helper_patch.rb b/plugins/redmine_smart_issues_sort/lib/issues_helper_patch.rb
|index f3b07fb..2bcea2d 100644
|--- a/plugins/redmine_smart_issues_sort/lib/issues_helper_patch.rb
|+++ b/plugins/redmine_smart_issues_sort/lib/issues_helper_patch.rb
--------------------------

Yes, that was just a diff from the installation path. Probably it would work if you cd into /opt/bitnami/apps/redmine/htdocs

In any case here is the stripped one

I tried from htdocs as well and got the same error. I'm going to try the stripped patch you just put up.

Just tried again.

From htdocs:
root@mayerredmine:/opt/bitnami/apps/redmine/htdocs# patch -i redmine_smart_issues_sort-2.3.patch         
can't find file to patch at input line 5
Perhaps you should have used the -p or --strip option?
The text leading up to this was:
--------------------------
|diff --git a/lib/issues_helper_patch.rb b/lib/issues_helper_patch.rb
|index f3b07fb..2bcea2d 100644
|--- a/lib/issues_helper_patch.rb
|+++ b/lib/issues_helper_patch.rb
--------------------------
File to patch: 

From the smart issues plugin dir:
root@mayerredmine:/opt/bitnami/apps/redmine/htdocs/plugins/redmine_smart_issues_sort# patch -i redmine_smart_issues_sort-2.3.patch         
can't find file to patch at input line 5
Perhaps you should have used the -p or --strip option?
The text leading up to this was:
--------------------------
|diff --git a/lib/issues_helper_patch.rb b/lib/issues_helper_patch.rb
|index f3b07fb..2bcea2d 100644
|--- a/lib/issues_helper_patch.rb
|+++ b/lib/issues_helper_patch.rb
--------------------------
File to patch: 

From the Plugins Dir:
root@mayerredmine:/opt/bitnami/apps/redmine/htdocs/plugins# patch -i redmine_smart_issues_sort-2.3.patch 
can't find file to patch at input line 5
Perhaps you should have used the -p or --strip option?
The text leading up to this was:
--------------------------
|diff --git a/lib/issues_helper_patch.rb b/lib/issues_helper_patch.rb
|index f3b07fb..2bcea2d 100644
|--- a/lib/issues_helper_patch.rb
|+++ b/lib/issues_helper_patch.rb
--------------------------
File to patch:

OK, so I couldn't get that patch working at all, however I did open the patch file and manually add the changes into each of the required files. So far everything looks good.

Use
patch -p1 -i redmine_smart_issues_sort-2.3.patch

from the plugins/redmine_smart_issues_sort folder

Not specifying any -p flag would try to search files in flatten folder

Hi guyz. Last fixes here: https://github.com/logical-and/redmine_smart_issues_sort

I found the trouble in plugin.

1. In some cases when I try to see issues in project with many issues link, plugin fails with error "Stack overflow" in production.log. Thi problem disappear after check box " By default sort by parent issue first " in plugin configuration was unchecked.
2. Issue filtering, fields set changing and grouping does not work. When I try to change set of fields, and click "Apply", the default set of fields appear in issues view.
Environment info

Environment:
  Redmine version                2.3.2.stable
  Ruby version                   1.9.3-p448 (2013-06-27) [i686-linux]
  Rails version                  3.2.13
  Environment                    production
  Database adapter               Mysql2
Redmine plugins:
  redmine_plugin_views_revisions 0.0.1
  redmine_smart_issues_sort      0.3.1
  redmine_theme_changer          0.1.0
  redmine_xls_export             0.2.1.t3

a new issue found

when I used the issue list to save my query, I click [save] button and 500 error

could anyone solve it. Thanks.

the error informaiton is

Started GET "/redmine/projects/mmmp/queries/new?utf8=%E2%9C%93&set_filter=1&f%5B%5D=status_id&op%5Bstatus_id%5D=o&f%5B%5D=&selected_columns%5B%5D=tracker&selected_columns%5B%5D=subject&selected_columns%5B%5D=status&selected_columns%5B%5D=assigned_to&selected_columns%5B%5D=updated_on&selected_columns%5B%5D=fixed_version&group_by=" for 127.0.0.1 at 2013-08-26 16:11:33 +0800
Processing by QueriesController#new as HTML
  Parameters: {"utf8"=>"?", "set_filter"=>"1", "f"=>["status_id", ""], "op"=>{"status_id"=>"o"}, "selected_columns"=>["tracker", "subject", "status", "assigned_to", "updated_on", "fixed_version"], "group_by"=>"", "project_id"=>"mmmp"}
  Current user: wanghui (id=3)
  Rendered plugins/redmine_smart_issues_sort/app/views/queries/_form.html.erb (0.0ms)
  Rendered queries/new.html.erb within layouts/base (0.0ms)
Completed 500 Internal Server Error in 47ms

ActionView::Template::Error (undefined method `category' for #<IssueQuery:0x2b8bb20>):
    8: <%# VVK start %>
    9: <p>
    10:   <label for="query_category"><%=l(:field_category)%></label>
    11:   <%= text_field 'query', 'category', :size => "80" %>
    12: </p>
    13: <div id="query_categories_choices" class="autocomplete">
    14: </div>
  app/views/queries/new.html.erb:4:in `block in _app_views_queries_new_html_erb___1038067327_26445144'
  app/views/queries/new.html.erb:3:in `_app_views_queries_new_html_erb___1038067327_26445144'

I solved some compatibility problems with the Redmine 2.3.2.

Thanks Imre, I added your patch to repo. Anyone can get the updated version right here: https://github.com/logical-and/redmine_smart_issues_sort

Good work!
Issue filtering and field configuring is working now!
But, I have one problem.
So, plugin works correctly in all my projects, except one.
Tehe are about 170 issues in this project. And when I try to view a list of them - error 500 code occures.
Full message test in browser

Internal error

An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.

If you are the Redmine administrator, check your log files for details about the error.

Back

In production log I see next messages

Started GET "/projects/kis-distrfs/issues?utf8=%E2%9C%93&set_filter=1&f%5B%5D=status_id&op%5Bstatus_id%5D=o&f%5B%5D=&c%5B%5D=tracker&c%5B%5D=status&c%5B%5D=priority&c%5B%5D=subject&c%5B%5D=assigned_to&c%5B%5D=updated_on&c%5B%5D=due_date&group_by=" for 192.168.247.149 at 2013-09-02 20:38:04 +0800
Processing by IssuesController#index as HTML
  Parameters: {"utf8"=>"вњ“", "set_filter"=>"1", "f"=>["status_id", ""], "op"=>{"status_id"=>"o"}, "c"=>["tracker", "status", "priority", "subject", "assigned_to", "updated_on", "due_date"], "group_by"=>"", "project_id"=>"kis-distrfs"}
  Current user: krot (id=3)
Completed 500 Internal Server Error in 651ms

SystemStackError (stack level too deep):
  activesupport (3.2.13) lib/active_support/callbacks.rb:409

If I uncheck "Sort by parent first" checkbox in plugin configuration - all works.
Do you have some ideas? How to solve this problem&

Steven Wong wrote:

a new issue found

when I used the issue list to save my query, I click [save] button and 500 error

could anyone solve it. Thanks.

the error informaiton is

[...ActionView::Template::Error (undefined method `category' for #<IssueQuery:0x2b8bb20>):...]

We are also running into this error. Using Redmine 2.3.2, Redmine plugin views revisions plugin is installed, and we are using current GitHub checkout of the smart issues sort plugin. Any ideas on how to fix this, or is a workaround existing?

Kind regards,
Daniel

We using the trunk version ea86379cd0 without any problems.
Thank you for your work!

Environment:
Redmine version 2.3.3.stable
Ruby version 1.9.3-p448 (2013-06-27) [x86_64-linux]
Rails version 3.2.13
Environment production
Database adapter Mysql2
Redmine plugins:
redmine_default_columns 0.1.1
redmine_plugin_views_revisions 0.0.1
redmine_smart_issues_sort 0.3.1
redmine_taskjuggler 0.1.0
status_button 0.1.0

I tried several redmine version (2.0, 2.2, 2.3) with the plugin redmine_smart_issues_sort 0.3.1, also encounters 500 Internal Server Error. and the below stack error show in log file. when "By default sort by parent issue first" is enabled. and issue status filter change to all or closed. Actually, we've got more than 20K issues in total and 17K closed status. However, I removed most of closed issues and leave around 3K records there. everything goes fine. Would you please help to solve it? this is a blocking issue for our upgrade.

SystemStackError (stack level too deep):
activesupport (3.2.6) lib/active_support/callbacks.rb:409

with 2.3 fix that your pushed to github in 2 months ago. the problem still encountered.

Hi,
This plugin works in our redmine 2.3 but it works slowly. this plugin increased issue list time from 2 sec. to 5.5 sec. in my project.
i get this times from log. when I remove the plugin, this time back to 2 sec. again.
there are 150 open and 1200 closed issues in that project.
I do not want to give up this plugin. Does anyone have a solution to decrease this time?

Environment:
Redmine version 2.3.3.stable
Ruby version 1.9.3-p448 (2013-06-27) [x86_64-linux]
Rails version 3.2.13
Environment production
Database adapter Mysql2
Redmine plugins:
author 0.1.0
autowatch 0.1.0
due_date_reminder 0.3.2
extended_fields 0.2.2
periodictask 2.0.0
redmine_assets_plugin 0.0.1
redmine_banner 0.0.9
redmine_category_tree 0.0.3
redmine_changeauthor 1.0.0
redmine_contacts 3.2.5-pro
redmine_contacts_helpdesk 2.2.5-pro
redmine_dmsf 1.4.6 stable
redmine_extended_watchers 0.0.4
redmine_favourite_projects 0.6.3
redmine_gemavatar 1.0.3
redmine_ics_export 2.0.0.dev
redmine_information 1.0.2
redmine_inline_attach_screenshot 0.4.6
redmine_inline_note_images_plugin 0.0.1
redmine_issue_checklist 2.0.5
redmine_ldap_sync 2.0.2
redmine_login_audit 0.1.1
redmine_logs 0.0.5y
redmine_reorder_links_arbitrary 0.0.7
redmine_stealth 0.6.0
redmine_textilizable_custom_fields 0.0.1
redmine_theme_changer 0.1.0
redmine_wiki_extensions 0.6.4
role_shift 0.1.0b
sidebar_hide 0.0.4
under_construction 0.0.1
wiking 0.0.4

Best Regards,

It thows the following error with redmine 2.4.2: (redmine_smart_issues_sort version: 0.3.1)

ActionView::Template::Error (undefined method `is_public' for #<IssueQuery:0x45a6260>):
17:
18: <% if User.current.admin? || User.current.allowed_to?(:manage_public_queries, Herve Harster) >
19: <p><label for="query_is_public"><=l(:field_is_public)%></label>
20: <%= check_box 'query', 'is_public',
21: :onchange => (User.current.admin? ? nil : 'if (this.checked) {$("#query_is_for_all").removeAttr("checked"); $("#query_is_for_all").attr("disabled", true);} else {$("#query_is_for_all").removeAttr("disabled");}') ></p>
22:
23: < end %>
app/views/queries/new.html.erb:4:in `block in app_views_queries_new_html_erb_116586891_42293064'
app/views/queries/new.html.erb:3:in `_app_views_queries_new_html_erb__116586891_42293064'

I managed to install the plugin okay without any of the issues seen above.

However I dont think it's working as expected. When sorting by priority I see the following:

http://i.imgur.com/goqjHj8.png

Ie I have a low priority task, then a parent/hierarchy, and then the remaining normal and low tasks. Is priority not honoured if sorting by parent is enabled?

We got the same issue with redmine 2.4.5, when saving or editing the custom queries

ActionView::Template::Error (undefined method `is_public' for #<IssueQuery:0x89887>):
18: <% if User.current.admin? || User.current.allowed_to?(:manage_public_queries, Herve Harster) >
19: <p><label for="query_is_public"><=l(:field_is_public)%></label>
20: <%= check_box 'query', 'is_public',
21: :onchange => (User.current.admin? ? nil : 'if (this.checked) {$("#query_is_for_all").removeAttr("checked"); $("#query_is_for_all").attr("disabled", true);} else {$("#query_is_for_all").removeAttr("disabled");}') ></p>
22:
23: < end %>
app/views/queries/new.html.erb:4:in `block in app_views_queries_new_html_erb__98788_687687'
app/views/queries/new.html.erb:3:in `_app_views_queries_new_html_erb___2411066153653_700'