restream / redmine_my_page_queries Goto Github PK

~ git clone git://github.com/Undev/redmine_my_page_queries.git

~rake redmine:plugins:migrate RAILS_ENV=production
Migrating redmine_my_page_queries (MyPage custom queries)...

I restarted redmine as well

Environment:
Redmine version 2.5.0.devel
Ruby version 2.1.1-p76 (2014-02-24) [i686-linux]
Rails version 3.2.17
Environment production
Database adapter Mysql2
SCM:
Git 1.8.3.2
Filesystem
Redmine plugins:
no plugin installed

I'd like to have split blocks at the top, full width in middle and more split bloack at the bottom.

Is this doable for a novice?
I've found the layouts but obviously there would be some other adjustments that need to be made.

if I add "order by" or "group by" clauses to my query, in my page I see issues of only 1 project

Hey,
we are using now redmine and we want to use this time tracker also but always when i want to open the reports site from the top menu there comes an "500 Internal Error". I know the actually version is not supported for redmine 2.5.1 but i hope you can help me to fix this error. In my log file stand already this:

Started GET "/" for 80.67.31.143 at Wed Jun 18 14:42:58 +0200 2014
Processing by WelcomeController#index as HTML
Current user: user123 (id=5)
Rendered welcome/index.html.erb within layouts/base (236.5ms)
Rendered plugins/redmine_time_tracker/app/views/time_trackers/_assets.html.erb (33.8ms)
Completed 200 OK in 795.6ms (Views: 280.0ms | ActiveRecord: 245.7ms)
Started GET "/tt_menu_switcher/index" for 80.67.31.143 at Wed Jun 18 14:43:04 +0200 2014
Processing by TtMenuSwitcherController#index as HTML
Current user: user123 (id=5)
Redirected to https://mysite.com/tt_overview
Completed 302 Found in 24.3ms (ActiveRecord: 2.7ms)
Started GET "/tt_overview" for 80.67.31.143 at Wed Jun 18 14:43:04 +0200 2014
Processing by TtOverviewController#index as HTML
Current user: user123 (id=5)
Completed 500 Internal Server Error in 582.8ms

NoMethodError (undefined method flat_map' for #<Array:0xa547e99c>): app/models/query.rb:331:inavailable_filters'
app/models/query.rb:220:in `build_from_params'

I have no plan about ruby and i don't know what i can do to fix this error.
Hope you can help me sap :)

Best Regards

My environment is Windows 2008 R2 / Ruby 1.8.7 / Rails 3.2.13 / Redmine 2.3.2 / Thin 1.5.1.

This is the first time I've tried a Redmine plugin so maybe I've missed some setup. I downloaded the ZIP from github and extracted the contents inside the plugins folder, then started Redmine from the command line.

When adding a custom query, the "view all issues", page size options and "extended view" links don't work for me.

View all issues goes to http://localhost:3000/issues?query_id=163927404 when it should go to http://localhost:3000/issues?query_id=90, therefore Redmine displays a 404.

The others briefly display a Loading indicator but nothing happens. The command line output also shows a 404 for those. For example, here's the output when clicking on "Extended view":

Started PUT "/my/update_query_block/163927404?query%5Bcompact_view%5D=false" for
127.0.0.1 at Wed Jul 31 11:35:27 +0100 2013
Processing by MyController#update_query_block as JS
Parameters: {"query_id"=>"163927404", "query"=>{"compact_view"=>"false"}}
←[1m←[36m (3.0ms)←[0m ←[1mEXEC sp_executesql N'SELECT MAX([settings].[updated
on]) AS max_id FROM [settings]'←[0m
←[1m←[35mUser Load (2.0ms)←[0m EXEC sp_executesql N'SELECT TOP (1) [users].*
FROM [users] WHERE [users].[type] IN (N''User'', N''AnonymousUser'') AND [users]
.[status] = 1 AND [users].[id] = @0', N'@0 int', @0 = 18 [["id", 18]]
Current user: richardm (id=18)
←[1m←[36mSQL (71.0ms)←[0m ←[1mEXEC sp_executesql N'SELECT [queries].[id] AS t
0_r0, [queries].[project_id] AS t0_r1, [queries].[name] AS t0_r2, [queries].[fil
ters] AS t0_r3, [queries].[user_id] AS t0_r4, [queries].[is_public] AS t0_r5, [q
ueries].[column_names] AS t0_r6, [queries].[sort_criteria] AS t0_r7, [queries].[
group_by] AS t0_r8, [queries].[type] AS t0_r9, [projects].[id] AS t1_r0, [projec
ts].[name] AS t1_r1, [projects].[description] AS t1_r2, [projects].[homepage] AS
t1_r3, [projects].[is_public] AS t1_r4, [projects].[parent_id] AS t1_r5, [proje
cts].[created_on] AS t1_r6, [projects].[updated_on] AS t1_r7, [projects].[identi
fier] AS t1_r8, [projects].[status] AS t1_r9, [projects].[lft] AS t1_r10, [proje
cts].[rgt] AS t1_r11, [projects].[inherit_members] AS t1_r12 FROM [queries] LEFT
OUTER JOIN [projects] ON [projects].[id] = [queries].[project_id] WHERE [querie
s].[type] IN (N''IssueQuery'') AND ((queries.project_id IS NULL OR (projects.sta
tus <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE
em.name=''issue_tracking''))) AND (queries.is_public = 1 OR queries.user_id = 18
)) AND (queries.user_id = 18) ORDER BY queries.name ASC'←[0m
←[1m←[35mSQL (11.0ms)←[0m EXEC sp_executesql N'SELECT [queries].[id] AS t0_r0
, [queries].[project_id] AS t0_r1, [queries].[name] AS t0_r2, [queries].[filters
] AS t0_r3, [queries].[user_id] AS t0_r4, [queries].[is_public] AS t0_r5, [queri
es].[column_names] AS t0_r6, [queries].[sort_criteria] AS t0_r7, [queries].[grou
p_by] AS t0_r8, [queries].[type] AS t0_r9, [projects].[id] AS t1_r0, [projects].
[name] AS t1_r1, [projects].[description] AS t1_r2, [projects].[homepage] AS t1
r3, [projects].[is_public] AS t1_r4, [projects].[parent_id] AS t1_r5, [projects]
.[created_on] AS t1_r6, [projects].[updated_on] AS t1_r7, [projects].[identifier
] AS t1_r8, [projects].[status] AS t1_r9, [projects].[lft] AS t1_r10, [projects]
.[rgt] AS t1_r11, [projects].[inherit_members] AS t1_r12 FROM [queries] LEFT OUT
ER JOIN [projects] ON [projects].[id] = [queries].[project_id] WHERE [queries].[
type] IN (N''IssueQuery'') AND ((queries.project_id IS NULL OR (projects.status
<> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.n
ame=''issue_tracking''))) AND (queries.is_public = 1 OR queries.user_id = 18)) A
ND (queries.user_id <> 18) ORDER BY queries.name ASC'
Rendered common/error.html.erb (1.0ms)
Completed 404 Not Found in 122ms (Views: 8.0ms | ActiveRecord: 87.0ms)

Hi there, I installed this plugin and immediately after I noticed that my reports are broken. I get an 500 server error when requesting a page like this:

[redmine host]/projects/[project name]/time_entries/report?utf8=%E2%9C%93&f%5B%5D=spent_on&op%5Bspent_on%5D=*&f%5B%5D=&columns=month&criteria%5B%5D=cf_9

I have a problem with this query:

ActiveRecord::StatementInvalid (Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS , tyear AS tyear, tmonth AS tmonth, tweek AS tweek, spent_on AS spent_on FROM' at line 1:
SELECT SUM(`time_entries`.`hours`) AS sum_hours,  AS , tyear AS tyear, tmonth AS tmonth, tweek AS tweek, spent_on AS spent_on FROM `time_entries` LEFT OUTER JOIN `projects` ON `projects`.`id` = `time_entries`.`project_id` LEFT OUTER JOIN `enumerations` ON `enumerations`.`id` = `time_entries`.`activity_id` AND `enumerations`.`type` IN ('TimeEntryActivity') LEFT OUTER JOIN `issues` ON `issues`.`id` = `time_entries`.`issue_id` LEFT OUTER JOIN custom_values cf_9 ON cf_9.customized_type = 'Issue' AND cf_9.customized_id = issues.id AND cf_9.custom_field_id = 9 AND (((1=1) AND (issues.tracker_id IN (SELECT tracker_id FROM custom_fields_trackers WHERE custom_field_id = 9)) AND (EXISTS (SELECT 1 FROM custom_fields ifa WHERE ifa.is_for_all = 1 AND ifa.id = 9) OR issues.project_id IN (SELECT project_id FROM custom_fields_projects WHERE custom_field_id = 9)))) AND cf_9.value <> '' AND cf_9.id = (SELECT max(cf_9_2.id) FROM custom_values cf_9_2 WHERE cf_9_2.customized_type = cf_9.customized_type AND cf_9_2.customized_id = cf_9.customized_id AND cf_9_2.custom_field_id = cf_9.custom_field_id) WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='time_tracking')) AND ((time_entries.spent_on IS NOT NULL) AND projects.id IN (37,25,5,26,7,8,12,17,14,13,16,27,29,2,31,24,22,23,9,35,32,34,33,38,21,4,3)) GROUP BY tyear, tmonth, tweek, spent_on):

So the problem is with this part:

SELECT SUM(time_entries.hours) AS sum_hours, * AS ,* tyear AS tyear,

Gems:

Using rake (10.1.1) 
Using i18n (0.6.9) 
Using multi_json (1.9.2) 
Using activesupport (3.2.17) 
Using builder (3.0.0) 
Using activemodel (3.2.17) 
Using erubis (2.7.0) 
Using journey (1.0.4) 
Using rack (1.4.5) 
Using rack-cache (1.2) 
Using rack-test (0.6.2) 
Using hike (1.2.3) 
Using tilt (1.4.1) 
Using sprockets (2.2.2) 
Using actionpack (3.2.17) 
Using mime-types (1.25.1) 
Using polyglot (0.3.4) 
Using treetop (1.4.15) 
Using mail (2.5.4) 
Using actionmailer (3.2.17) 
Using arel (3.0.3) 
Using tzinfo (0.3.39) 
Using activerecord (3.2.17) 
Using activeresource (3.2.17) 
Using awesome_nested_set (2.1.6) 
Using bundler (1.3.0) 
Using coderay (1.1.0) 
Using daemons (1.1.9) 
Using eventmachine (1.0.3) 
Using fastercsv (1.5.5) 
Using rack-ssl (1.3.4) 
Using json (1.8.1) 
Using rdoc (3.12.2) 
Using thor (0.19.1) 
Using railties (3.2.17) 
Using jquery-rails (2.0.3) 
Using metaclass (0.0.4) 
Using mocha (1.0.0) 
Using mysql (2.8.1) 
Using net-ldap (0.3.1) 
Using pg (0.17.1) 
Using ruby-openid (2.3.0) 
Using rack-openid (1.4.2) 
Using rails (3.2.17) 
Using redcarpet (2.3.0) 
Using rmagick (2.13.2) 
Using shoulda-context (1.0.2) 
Using shoulda-matchers (1.4.1) 
Using shoulda (3.3.2) 
Using sqlite3 (1.3.9) 
Using thin (1.6.2) 
Using yard (0.8.7.4) 

# ruby -v
ruby 1.8.7 (2010-08-16 patchlevel 302) [x86_64-linux]

I suspect the version bump from 2.5.0 to 2.5.1 might cause this bug, but there might be other factors too.
Immediately before I installed this plugin, I had to upgrade my redmine from 2.2.3 (IIRC) to the newest, 2.5.1. Before upgrading I had to remove a previous, unsupported and obsolete plugin. So it is possible that the removal of the plugin caused this issue, although I'm not sure about it. This is all I can tell you, bacause unfortunately I did not carry out these modifications personally.

Using the latest revision I now get an error which prevents My Page loading at all.

Rendered plugins/redmine_my_page_queries/app/views/my/page.html.erb within lay
outs/base (159.0ms)
Completed 500 Internal Server Error in 608ms

ActionView::Template::Error (undefined method visible' for #<Class:0x138e4990>) : 19: <% @blocks['left'].each do |b| 20: next unless block_exists?(@user, b) %> 21: <div class="mypage-box"> 22: <%= render_block(@user, b) %> 23: </div> 24: <% end if @blocks['left'] %> 25: </div> activerecord (3.2.13) lib/active_record/dynamic_matchers.rb:55:inmethod_missing'
plugins/redmine_my_page_queries/lib/my_page_queries/patches/user_patch.rb:26:in visible_queries_scope' plugins/redmine_my_page_queries/lib/my_page_queries/patches/user_patch.rb:17:inmy_visible_queries'
plugins/redmine_my_page_queries/lib/my_page_queries/patches/user_patch.rb:13:in visible_queries' plugins/redmine_my_page_queries/lib/my_page_queries/patches/user_patch.rb:9:indetect_query'
plugins/redmine_my_page_queries/app/helpers/my_page_queries_helper.rb:12:in query_from_block' plugins/redmine_my_page_queries/app/helpers/my_page_queries_helper.rb:16:inrender_block'
plugins/redmine_my_page_queries/app/views/my/page.html.erb:22:in _plugins_redmine_my_page_queries_app_views_my_page_html_erb___942574665_165005172' plugins/redmine_my_page_queries/app/views/my/page.html.erb:19:ineach'
plugins/redmine_my_page_queries/app/views/my/page.html.erb:19:in `_plugins_redmine_my_page_queries_app_views_my_page_html_erb___942574665_165005172'

I have tried adding back the reference to "require 'project'" as suggested by mattiasa but I still get the same problem.

My environment is Windows 2008 R2 / Ruby 1.8.7 / Rails 3.2.13 / Redmine 2.3.2 / Thin 1.5.1.

I added custom common query to personal page and got 500 error. Plugin version is 2.0.4
This is the part of redmine log:

ActionView::Template::Error (undefined method `inline_columns' for #<Query:0x7bad010>):
    13:                       :onclick => 'toggleIssuesSelection(this); return false;',
    14:                       :title => "#{l(:button_check_all)}/#{l(:button_uncheck_all)}" %>
    15:         </th>
    16:         <th>#</th>
    17:         <% query.inline_columns.each do |column| %>
    18:           <th><%= column.caption %></th>
    19:         <% end %>
  activemodel (3.2.8) lib/active_model/attribute_methods.rb:407:in `method_missing'
  activerecord (3.2.8) lib/active_record/attribute_methods.rb:149:in `method_missing'
  plugins/redmine_my_page_queries/app/views/my/_query_block.html.erb:16:in `_plugins_redmine_my_page_queries_app_views_my__query_block_html_erb___162338595_63144684' 

Hi,
Great plugin. One issue. During project removing I have Internal error:
Completed 500 Internal Server Error in 60ms

SystemStackError (stack level too deep):
app/models/project.rb:298:in base_reload' app/models/project.rb:301:inbase_reload'
app/models/project.rb:301:in reload' lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:485:inreload_nested_set'
lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:444:in destroy_descendants' lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:426:inin_tenacious_transaction'
lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:443:in destroy_descendants' app/controllers/projects_controller.rb:236:indestroy'

After removing plugin I can remove project.
regards
j

Someone can help me to install this plugin in Redmine 5.1.1. Performing migration on Redmine2.3.4 to Redmine 5.1.1.

can not support 3.4.2.stable .
pls fix it.

Hi, after installing redmine_my_page_queries i can no longer create new projects.

Exception i'm getting is:

Completed 500 Internal Server Error in 457ms

SystemStackError (stack level too deep):
app/models/project.rb:289:in base_reload' app/models/project.rb:301:inbase_reload'
app/models/project.rb:301:in reload' lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:485:inreload_nested_set'
lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:494:in move_to' lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:426:inin_tenacious_transaction'
lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:492:in move_to' lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:491:inmove_to'
lib/plugins/awesome_nested_set/lib/awesome_nested_set/awesome_nested_set.rb:351:in move_to_left_of' app/models/project.rb:1010:inset_or_update_position_under'
app/models/project.rb:1000:in update_position_under_parent' app/controllers/projects_controller.rb:83:increate'

there are no other plugins installed, removing plugin solves this problem, but i'm missing functionality :/

Hi,

I wanted to ask if there are plans to make this plugin compatible for redmine v3.x?

Thank you very much.

Thanks for your useful plugin.

The only issue I've found is "sorting", when I create a filter with custom sorting, in "my page" it will be available without defined sort.

Thanks again.

Good morning,

I have not found the license; I may have missed it. Please provide a pointer to the license.

If you do not yet have a license file, please add one.

Thank you.

--
ClaudeM223

Redmine version: 2.3.1.stable.11930
Redmine My Page Queries version: 2.0.1

When I open "my page" an server error 500 shows up.

This is what my log says:

Processing by MyController#page as HTML
  Current user: user (id=21)
  Rendered plugins/redmine_my_page_queries/app/views/my/page.html.erb within layouts/base (244.9ms)
Completed 500 Internal Server Error in 803ms

ActionView::Template::Error (undefined method `visible' for #<Class:0x00000003919120>):
    17:   <% @blocks['left'].each do |b|
    18:     next unless block_exists?(@user, b)  %>
    19:   <div class="mypage-box">
    20:     <%= render_block(@user, b) %>
    21:   </div>
    22:   <% end if @blocks['left'] %>
    23: </div>
  activerecord (3.2.13) lib/active_record/dynamic_matchers.rb:55:in `method_missing'
  plugins/redmine_my_page_queries/lib/my_page_queries/patches/user_patch.rb:17:in `my_visible_queries'
  plugins/redmine_my_page_queries/lib/my_page_queries/patches/user_patch.rb:13:in `visible_queries'
  plugins/redmine_my_page_queries/lib/my_page_queries/patches/user_patch.rb:9:in `detect_query'
  plugins/redmine_my_page_queries/app/helpers/my_page_queries_helper.rb:12:in `query_from_block'
  plugins/redmine_my_page_queries/app/helpers/my_page_queries_helper.rb:16:in `render_block'
  plugins/redmine_my_page_queries/app/views/my/page.html.erb:20:in `block in _plugins_redmine_my_page_queries_app_views_my_page_html_erb___735397782064148978_10029540'
  plugins/redmine_my_page_queries/app/views/my/page.html.erb:17:in `each'
  plugins/redmine_my_page_queries/app/views/my/page.html.erb:17:in `_plugins_redmine_my_page_queries_app_views_my_page_html_erb___735397782064148978_10029540'
  actionpack (3.2.13) lib/action_view/template.rb:145:in `block in render'
  activesupport (3.2.13) lib/active_support/notifications.rb:125:in `instrument'
  actionpack (3.2.13) lib/action_view/template.rb:143:in `render'

Hi, im having the following error when installing de plugin

/Bitnami/redmine-2.5.0-0/ruby/lib/ruby/gems/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:317:in `rescue in depend_on': Missing helper file helpers/my_page_queries_helper.rb (LoadError) from C:/Bitnami/redmine-2.5.0-0/ruby/lib/ruby/gems/1.9.1/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:312:in depend_on'

It goes on, let me know if you need all the string.

Im running redmine 2.5.0.0 from the Bitnami Redmine Stack build in windows server.

Hello!
This plugin doesn't work with following configuration (copied from redmine/admin):

Environment:
Redmine version 2.4.1.stable
Ruby version 2.0.0-p353 (2013-11-22) [i386-mingw32]
Rails version 3.2.15
Environment production
Database adapter Mysql2
SCM:
Subversion 1.7.0
Filesystem
Redmine plugins:
redmine_my_page_queries 2.0.9

Initially queries are in the select, but after adding, there's no new block on a page, but query disappears from select list.