{"action":"created","issue":{"url":"https://api.github.com/repos/Loriowar/redmine_issues_tree/issues/32","repository_url":"https://api.github.com/repos/Loriowar/redmine_issues_tree","labels_url":"https://api.github.com/repos/Loriowar/redmine_issues_tree/issues/32/labels{/name}","comments_url":"https://api.github.com/repos/Loriowar/redmine_issues_tree/issues/32/comments","events_url":"https://api.github.com/repos/Loriowar/redmine_issues_tree/issues/32/events","html_url":"https://github.com/Loriowar/redmine_issues_tree/issues/32","id":156812601,"number":32,"title":"500 error when trying to group issues by status in plain view mode.","user":{"login":"hbfontana","id":19576286,"avatar_url":"https://avatars.githubusercontent.com/u/19576286?v=3","gravatar_id":"","url":"https://api.github.com/users/hbfontana","html_url":"https://github.com/hbfontana","followers_url":"https://api.github.com/users/hbfontana/followers","following_url":"https://api.github.com/users/hbfontana/following{/other_user}","gists_url":"https://api.github.com/users/hbfontana/gists{/gist_id}","starred_url":"https://api.github.com/users/hbfontana/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hbfontana/subscriptions","organizations_url":"https://api.github.com/users/hbfontana/orgs","repos_url":"https://api.github.com/users/hbfontana/repos","events_url":"https://api.github.com/users/hbfontana/events{/privacy}","received_events_url":"https://api.github.com/users/hbfontana/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-05-25T17:57:40Z","updated_at":"2016-06-05T16:21:08Z","closed_at":null,"body":"Hi there! Your plugin is being really useful for us here! Thank you!\r\n\r\nOn the other hand, we started to notice  an error when trying to use the \"Group By\" dropdown after installing the plugin. The error occurs only when we select \"Status\" as the criteria for grouping tasks/issues.  The message displayed on the screen is: \"An error occurred while executing the query and has been logged. Please report this error to your Redmine administrator.\"\r\n\r\n**The error logged in production.log file is the following :** \r\n\r\n> Started GET \"/redmine/projects/lab-ld/issues\" for 10.1.210.2 at 2016-05-25 14:51:49 -0300\r\n> Processing by IssuesController#index as HTML\r\n>   Parameters: {\"project_id\"=>\"lab-ld\"}\r\n>   Current user: admin (id=1)\r\n>   Rendered plugins/redmine_issues_tree/app/views/issues_trees/_issues_index_header_tags.html.haml (1.2ms)\r\n>   Rendered plugins/redmine_issues_tree/app/views/issues_trees/_link_to_tree_view.html.haml (1.4ms)\r\n>   Rendered queries/_filters.html.erb (249.6ms)\r\n>   Rendered queries/_columns.html.erb (3.7ms)\r\n>   Rendered issues/_list.html.erb (46.4ms)\r\n>   Rendered issues/_sidebar.html.erb (11.3ms)\r\n>   Rendered plugins/redmine_issues_tree/app/views/issues/index.html.erb within layouts/base (331.1ms)\r\n>   Rendered plugins/computed_custom_field/app/views/hooks/_base_head.html.erb (0.4ms)\r\n>   Rendered plugins/progressive_projects_list/app/views/application/_progressive_sidebar.html.erb (0.1ms)\r\n>   Rendered plugins/progressive_projects_list/app/views/application/_progressive_recent_projects.html.erb (0.3ms)\r\n> Completed 200 OK in 510ms (Views: 356.1ms | ActiveRecord: 34.0ms)\r\n> Started GET \"/redmine/projects/lab-ld/issues?utf8=%E2%9C%93&set_filter=1&f%5B%5D=&c%5B%5D=tracker&c%5B%5D=subject&c%5B%5D=assigned_to&c%5B%5D=status&c%5B%5D=$\r\n> Processing by IssuesController#index as HTML\r\n>   Parameters: {\"utf8\"=>\"✓\", \"set_filter\"=>\"1\", \"f\"=>[\"\"], \"c\"=>[\"tracker\", \"subject\", \"assigned_to\", \"status\", \"done_ratio\", \"due_date\"], \"group_by\"=>\"status$\r\n>   Current user: admin (id=1)\r\n> Query::StatementInvalid: Mysql2::Error: Unknown column 'FALSE' in 'order clause': SELECT  `issues`.`id` AS t0_r0, `issues`.`tracker_id` AS t0_r1, `issues`.`p$\r\n>   Rendered common/error.html.erb within layouts/base (0.3ms)\r\n>   Rendered plugins/computed_custom_field/app/views/hooks/_base_head.html.erb (0.3ms)\r\n>   Rendered plugins/progressive_projects_list/app/views/application/_progressive_sidebar.html.erb (0.1ms)\r\n>   Rendered plugins/progressive_projects_list/app/views/application/_progressive_recent_projects.html.erb (0.2ms)\r\n> Completed 500 Internal Server Error in 83ms (Views: 31.2ms | ActiveRecord: 11.3ms)\r\n\r\nAs you can see, we have other plugins installed, but we started no notice this after installing \"Redmine Issues Tree\" plugin.\r\n\r\n**More information:**\r\n\r\n> Environment:\r\n>   Redmine version                3.1.4.stable\r\n>   Ruby version                   2.0.0-p598 (2014-11-13) [x86_64-linux]\r\n>   Rails version                  4.2.5.2\r\n>   Environment                    production\r\n>   Database adapter               Mysql2\r\n> SCM:\r\n>   Subversion                     1.7.14\r\n>   Git                            1.8.3.1\r\n>   Filesystem                     \r\n> Redmine plugins:\r\n>   computed_custom_field          0.0.6\r\n>   progressive_projects_list      2.0.1\r\n>   redmine_checklists             3.1.3\r\n>   redmine_dashboard              2.7.0\r\n>   redmine_issue_completion       0.0.2\r\n>   redmine_issues_tree            0.0.7\r\n>   redmine_mentions               0.0.1\r\n>   redmine_my_page_queries        2.1.6\r\n>   subtask_columns                0.0.3\r\n\r\n\r\nWe hope you have some time to take a look on this. Sorry for my english. Thanks in advance!"},"comment":{"url":"https://api.github.com/repos/Loriowar/redmine_issues_tree/issues/comments/223822194","html_url":"https://github.com/Loriowar/redmine_issues_tree/issues/32#issuecomment-223822194","issue_url":"https://api.github.com/repos/Loriowar/redmine_issues_tree/issues/32","id":223822194,"user":{"login":"Loriowar","id":2118479,"avatar_url":"https://avatars.githubusercontent.com/u/2118479?v=3","gravatar_id":"","url":"https://api.github.com/users/Loriowar","html_url":"https://github.com/Loriowar","followers_url":"https://api.github.com/users/Loriowar/followers","following_url":"https://api.github.com/users/Loriowar/following{/other_user}","gists_url":"https://api.github.com/users/Loriowar/gists{/gist_id}","starred_url":"https://api.github.com/users/Loriowar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Loriowar/subscriptions","organizations_url":"https://api.github.com/users/Loriowar/orgs","repos_url":"https://api.github.com/users/Loriowar/repos","events_url":"https://api.github.com/users/Loriowar/events{/privacy}","received_events_url":"https://api.github.com/users/Loriowar/received_events","type":"User","site_admin":false},"created_at":"2016-06-05T16:21:08Z","updated_at":"2016-06-05T16:21:08Z","body":"Hi! First of all, are you use branch of issues_tree plugin with name corresponding to your Redmine version? I.e. are you install plugin from branch `3.1.0` for your Redmine `3.1.4`? If no - most likely this is a source of the problem. If yes - let me know, I try to find incompatibility with a plugins from your list."}}
{"actor":{"display_login":"Loriowar"}}