nanego / redmine_multiprojects_issue Goto Github PK

View Code? Open in Web Editor NEW

57.0 17.0 29.0 684 KB

A Redmine plugin which allows you to specify several projects per issue

Home Page: http://www.redmine.org/plugins/redmine_multiprojects_issue

License: MIT License

Ruby 77.85% HTML 10.99% JavaScript 9.41% CSS 1.75%

redmine redmine-plugin

redmine_multiprojects_issue's Introduction

Redmine Multiprojects Issue plugin

This redmine plugin allows you to specify more than one project per issue.

Cross-projects issues appear in all related projects. They can be viewed by every users who have enough permission on at least one related project, but can be updated only by users who have enough permissions on the main project (the project used to create the issue).

Do not forget to add the "View multi-projects issues" permission to authorized roles.

Screenshots

Installation

This plugin has been tested with Redmine 2.3.0+.

Compatibility with older Redmine versions:

for Redmine versions up to 3.2.x, release v0.2 must be used.
for Redmine version 3.3 & 3.4, please use this release v3.4.6
for Redmine version 4.0 & 4.1, use this release v4.1.2
for Redmine version 4.2.x, use this release v4.2.7

With Redmine 5.0+, use the current master branch. See below for specific instructions.

Please apply general instructions for plugins here.

Note that this plugin depends on:

redmine_base_deface which can be found here
redmine_base_stimulusjs which can be found here

These plugins must be installed first.

Then, download the source or clone the plugin and put it in the "plugins/" directory of your redmine instance. Note that this is crucial that the directory is named 'redmine_multiprojects_issue'!

Then execute:

$ bundle install
$ rake redmine:plugins

And finally restart your Redmine instance.

Test status

Plugin branch	Redmine Version	Test Status
master	5.1.3
master	4.2.11
master	master

Contributing

Fork it
Create your feature branch (git checkout -b my-new-feature)
Commit your changes (git commit -am 'Add some feature')
Push to the branch (git push origin my-new-feature)
Create new Pull Request

redmine_multiprojects_issue's People

Contributors

Stargazers

Watchers

redmine_multiprojects_issue's Issues

Redmine Rest-API

Is there a support to set multiple projects in to issue through the rest api?

Error 404 - configuration of the plugin

Hello,

First thanks for this plugin, but i just install it and i don't know why , when i go on /administration/plugin/Redmine Multiple Projects per Issue plugin and then configurate.

Redmine returns me this error :

"404
La page à laquelle vous souhaitez accéder n'existe pas ou a été supprimée."
( it means the page that you would access don't exist or has been delete)

Redmine Version : 3.2

i have installed the correct release for my version and redmine_base_deface.

Best regard's

Mickael

Integration in Development Process

Hello nanego,

sorry for writing a ticket, but I've no idea to contact you otherwise. I'm trying to use your plugin and the
scrum plugin (http://www.redmine.org/plugins/scrum-plugin) together, but i missed some little things.

Maybe we can have email contact, so that I can explain my needs and hopefully you have a simple solution for me.

Thank you.

Not bug, but the depends 'redmine_base_deface' does not support 3.4+

This is not bug...
And, the depends 'redmine_base_deface' does not support 3.4+
so sad.

Why no Gemfile or requires_redmine_plugin ?

Hello,

Instead of requiring a manual installation of redmine-deface etc, why not simply add a Gemfile (maybe that won't work) or use requires_redmine_plugin in your init.rb to have the dependency automatically handled?

export to pdf

Exporting an issue list with related projects column generates a pdf but it shows this in the related project column:

#<Project::ActiveRecord_Associations_CollectionProxy:0x007f70098cd568>

This does not happen when exporting to CSV.

Problem with Redmine 4.0.3 when installed Extra Queries

I have latest released version of redmine with RM+ Extra Queries.
When i installed your extensions i receive error 500 when go to project page and issue page.

Please help.

Could it support Redmine 3.3.X?

I tested it on Redmine3.3, and found it could not loaded when I create or edit an issue? anything I have missed? Thanks.

my environment is

Environment:
Redmine version 3.3.0.stable.15823
Ruby version 2.2.4-p230 (2015-12-16) [x86_64-linux]
Rails version 4.2.7.1
Environment production
Database adapter Mysql2

when I create issues the log is

Started GET "/projects/myxdj/issues/new" for 192.168.60.238 at 2016-09-08 09:15:10 +0800
Processing by IssuesController#new as HTML
  Parameters: {"project_id"=>"myxdj"}
  Current user: hui.wang (id=8)
  Rendered plugins/redmine_issue_templates/app/views/issue_templates/_issue_select_form.html.erb (3.4ms)
  Rendered plugins/simple_author_change/app/views/issues/_simple_author_change.html.erb (2.4ms)
  Rendered issues/_form_custom_fields.html.erb (15.3ms)
  Rendered issues/_attributes.html.erb (41.8ms)
  Rendered plugins/issuestats/app/views/issuestats/_issues_add_start_datetime.html.erb (0.4ms)
  Rendered plugins/redmine_assign_grouping/app/views/hooks/_assign_grouping.html.erb (0.8ms)
  Rendered plugins/redmine_didyoumean/app/views/issues/_didyoumean_injected.html.erb (3.5ms)
  Rendered plugins/redmine_issue_checklist/app/views/issues/_checklist_form.html.erb (1.0ms)
  Rendered plugins/redmine_issue_history_filter/app/views/redmine_issue_history_filter/_redmine_issue_history_filter_partial.html.erb (0.3ms)
  Rendered plugins/redmine_workflow_enhancements/app/views/workflow_enhancements/_issue_popup.html.erb (0.4ms)
  Rendered plugins/redmine_tags/app/views/issues/_tags_form.html.erb (2.9ms)
  Rendered plugins/redmine_mentions/app/views/hooks/redmine_mentions/_edit_mentionable.html.erb (36.0ms)
  Rendered issues/_form.html.erb (193.5ms)
  Rendered attachments/_form.html.erb (3.2ms)
  Rendered issues/new.html.erb within layouts/base (204.1ms)
  Rendered plugins/advanced_roadmap_v2/app/views/hooks/_stylesheet.html.erb (0.2ms)
  Rendered plugins/quick_edit/app/views/hooks/_quick_edit_base_head.html.erb (0.1ms)
  Rendered plugins/redmine__select2/app/views/redmine__select2/_includes.html.erb (0.4ms)
  Rendered plugins/redmine_code_review/app/views/code_review/_html_header.html.erb (0.5ms)
  Rendered plugins/redmine_cut_tag/app/views/hooks/redmine_cut_tag/_includes.html.erb (0.3ms)
redmine_highlightjs2: supported browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0
  Rendered inline template (0.8ms)
  Rendered plugins/redmine_select2_inputs/app/views/select2/_metatags.html.erb (0.3ms)
  Rendered plugins/redmine_wiki_templates/app/views/wiki_templates/_html_head.html.erb (0.1ms)
  Rendered plugins/clipboard_image_paste/app/views/clipboard_image_paste/_headers.html.erb (0.5ms)
  Rendered plugins/progressive_projects_list/app/views/application/_progressive_sidebar.html.erb (0.1ms)
  Rendered plugins/progressive_projects_list/app/views/application/_progressive_recent_projects.html.erb (0.1ms)
  Rendered plugins/redmine_banner/app/views/banner/_project_body_bottom.html.erb (1.6ms)
  Rendered plugins/quick_edit/app/views/hooks/_quick_edit_base_bottom.html.erb (0.4ms)
  Rendered plugins/redmine_code_review/app/views/code_review/_body_bottom.html.erb (0.2ms)
  Rendered plugins/redmine_introductions/app/views/hooks/_view_layouts_base_body_bottom_intro.html.erb (1.4ms)
  Rendered plugins/redmine_wiki_fix_toc/app/views/wiki_fix_toc/body_bottom.html.erb (0.1ms)
  Rendered plugins/redmine_wiki_templates/app/views/wiki_templates/_body_bottom.html.erb (0.3ms)
  Rendered plugins/clipboard_image_paste/app/views/clipboard_image_paste/_add_form.html.erb (4.9ms)
Completed 200 OK in 402ms (Views: 301.7ms | ActiveRecord: 49.7ms)

redmine 3.3.1 broken

the plugin can't load the javascript for itself and css....

Latest commit 367aa63 incompatible with redmine 3.2

As per the comment on commit 367aa63 by @friend-yara, attempting to install this version of the plugin results in the following error:

sudo rake redmine:plugins
rake aborted!
NameError: undefined method `user_tracker_permission?' for class `#<Class:0x000000052a53c8>'
/usr/share/redmine/plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/issue_patch.rb:119:in `<class:Issue>'
/usr/share/redmine/plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/issue_patch.rb:3:in `<top (required)>'
/var/lib/gems/2.3.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
/var/lib/gems/2.3.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
/usr/share/redmine/plugins/redmine_multiprojects_issue/init.rb:5:in `block in <top (required)>'
/usr/share/redmine/config/environment.rb:14:in `<top (required)>'
/var/lib/gems/2.3.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
/var/lib/gems/2.3.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
/usr/share/redmine/lib/tasks/redmine.rake:52:in `block (2 levels) in <top (required)>'
Tasks: TOP => redmine:plugins:migrate => environment
(See full trace by running task with --trace)

Error to_param on install

After installing the plugin in Redmine 4.0.1 on Rails 5.2.2 and Ruby 2.5.3 using Mysql2:

bundle exec rake redmine:plugins:migrate RAILS_ENV=production

--
rake aborted!
NoMethodError: undefined method `to_prepare' for ActionDispatch::Reloader:Class Did you mean? to_param /home/redmine/live/plugins/redmine_multiprojects_issue/init.rb:3:in` <top (required)>'
/home/redmine/live/lib/redmine/plugin.rb:173:in `block in load' /home/redmine/live/lib/redmine/plugin.rb:164:in` each'
/home/redmine/live/lib/redmine/plugin.rb:164:in `load' /home/redmine/live/config/initializers/30-redmine.rb:21:in` <top (required)>'
/home/redmine/live/config/environment.rb:14:in `<top (required)>' /usr/bin/bundle:23:in` load'
/usr/bin/bundle:23:in `'
Tasks: TOP => redmine:plugins:migrate => environment
(See full trace by running task with --trace)

I found that the alias_method_chain is depreceated and have to be replaced.
I really like to use your plugin, can you fix the bug?

with kind regards,
Marcel

Access to not public projects

Hi,
I have project which is not public. To this project1 have acces User1, User2
I share with this plugin one issue to projecy2 where access have User3, User4

And now:
User3 and User4 see Issue but without activities. They couldn't comment.

How can I change this behaviour?

Best Regard,

compatibility issue: does not work with redmine_dashboard 2 plugin

I, [2023-08-18T16:36:11.509243 #1] INFO -- : Started GET "/projects/ilrdfmis/rdb/taskboard?&=1692376570918" for 1.34.74.47 at 2023-08-18 16:36:11 +0000
I, [2023-08-18T16:36:11.510586 #1] INFO -- : Processing by RdbTaskboardController#index as JS
I, [2023-08-18T16:36:11.510648 #1] INFO -- : Parameters: {""=>"1692376570918", "id"=>"ilrdfmis"}
I, [2023-08-18T16:36:11.516659 #1] INFO -- : Current user: sysadmin (id=1)
I, [2023-08-18T16:36:11.544754 #1] INFO -- : Rendered plugins/redmine_dashboard/app/views/rdb_dashboard/index.js.erb (Duration: 6.2ms | Allocations: 1534)
I, [2023-08-18T16:36:11.545006 #1] INFO -- : Completed 500 Internal Server Error in 34ms (ActiveRecord: 7.6ms | Allocations: 8417)
F, [2023-08-18T16:36:11.546818 #1] FATAL -- :
ActionView::Template::Error (Couldn't find Tracker with 'id'=6 [WHERE trackers.id IN (SELECT DISTINCT trackers.id FROM trackers INNER JOIN projects_trackers ON projects_trackers.tracker_id = trackers.id INNER JOIN projects ON projects.id = projects_trackers.project_id WHERE projects.id IN (?, ?, ?, ?, ?))]):
18: - render_rdb_menu_list [:all] do |val|
19: = link_to t("rdb_filter_tracker_#{val}"), rdb_filter_path(tracker: val)
20: - render_rdb_menu_list @board.trackers do |val|

plugins/redmine_dashboard/app/models/rdb_tracker_filter.rb:50:in title' plugins/redmine_dashboard/app/views/rdb_dashboard/taskboard/_header.html.slim:17 plugins/redmine_dashboard/app/views/rdb_dashboard/_taskboard.html.slim:3 plugins/redmine_dashboard/app/views/rdb_dashboard/index.js.erb:1 lib/redmine/sudo_mode.rb:61:in sudo_mode'

Redmine::PluginNotFound

Please help me with your plugin.
My environment:

Redmine version 2.4.4.stable
Ruby version 1.9.3-p545 (2014-02-24) [i686-linux]
Rails version 3.2.17
Environment production
Database adapter Mysql2

Running "redmine_multiprojects_issue" i have next error:

/opt/redmine-2.4.4$ rake redmine:plugins RAILS_ENV=production
rake aborted!
Redmine::PluginNotFound
/opt/redmine-2.4.4/lib/redmine/plugin.rb:107:in find' /opt/redmine-2.4.4/lib/redmine/plugin.rb:229:inrequires_redmine_plugin'
/opt/redmine-2.4.4/plugins/redmine_multiprojects_issue/init.rb:26:in block in <top (required)>' /opt/redmine-2.4.4/lib/redmine/plugin.rb:73:ininstance_eval'
/opt/redmine-2.4.4/lib/redmine/plugin.rb:73:in register' /opt/redmine-2.4.4/plugins/redmine_multiprojects_issue/init.rb:19:in<top (required)>'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/polyglot-0.3.4/lib/polyglot.rb:65:in require' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/polyglot-0.3.4/lib/polyglot.rb:65:inrequire'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in block in require' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:236:inload_dependency'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in require' /opt/redmine-2.4.4/lib/redmine/plugin.rb:133:inblock in load'
/opt/redmine-2.4.4/lib/redmine/plugin.rb:124:in each' /opt/redmine-2.4.4/lib/redmine/plugin.rb:124:inload'
/opt/redmine-2.4.4/config/initializers/30-redmine.rb:19:in <top (required)>' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:245:inload'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:245:in block in load' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:236:inload_dependency'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:245:in load' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/engine.rb:593:inblock (2 levels) in class:Engine'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/engine.rb:592:in each' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/engine.rb:592:inblock in class:Engine'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/initializable.rb:30:in instance_exec' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/initializable.rb:30:inrun'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/initializable.rb:55:in block in run_initializers' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/initializable.rb:54:ineach'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/initializable.rb:54:in run_initializers' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/application.rb:136:ininitialize!'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/railtie/configurable.rb:30:in method_missing' /opt/redmine-2.4.4/config/environment.rb:14:in<top (required)>'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/polyglot-0.3.4/lib/polyglot.rb:65:in require' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/polyglot-0.3.4/lib/polyglot.rb:65:inrequire'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in block in require' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:236:inload_dependency'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/activesupport-3.2.17/lib/active_support/dependencies.rb:251:in require' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/application.rb:103:inrequire_environment!'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/gems/railties-3.2.17/lib/rails/application.rb:305:in block (2 levels) in initialize_tasks' /opt/redmine-2.4.4/lib/tasks/redmine.rake:52:inblock (2 levels) in <top (required)>'
/usr/local/rvm/gems/ruby-1.9.3-p545@redmine/bin/ruby_executable_hooks:15:in eval' /usr/local/rvm/gems/ruby-1.9.3-p545@redmine/bin/ruby_executable_hooks:15:in

'
Tasks: TOP => redmine:plugins:migrate => environment
(See full trace by running task with --trace)

Cannot display issues of impacted projects in Gantt

Hi guys,
First of all thank you for developing this plugging. I'm now using it and everything seems to work fine except that I can't see the issues of the impacted projects in the Gantt chart. For instance I have an issue "bug gui" that is an issue owned by a project "main release". Then I want to issue to be placed as well in the project "GUI development". Therefore, I add the issue with the "related project" option. I can now see the issue in the project "GUI development". But, I don't see this issue in Gantt chart when I display the project "GUI development" Is-it normal?

Best regards,
Christopher.

500 Internal Error when accessing user profile view [Redmine 4.2.2]

When accessing user user profiles the following exception is thrown.

Started GET "/users/5" for 10.144.32.236 at 2021-09-14 20:02:34 +0100
Processing by UsersController#show as HTML
  Parameters: {"id"=>"5"}
  Current user: chris_lockwood (id=5)
Completed 500 Internal Server Error in 544ms (ActiveRecord: 386.4ms)
  
NoMethodError (undefined method `where' for #<Proc:0x000000000cb27828>
Did you mean?  when):
  
plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/acts_as_activity_provider.rb:32:in `find_events'
lib/redmine/activity/fetcher.rb:93:in `block (2 levels) in events'
lib/redmine/activity/fetcher.rb:92:in `each'
lib/redmine/activity/fetcher.rb:92:in `block in events'
lib/redmine/activity/fetcher.rb:91:in `each'
lib/redmine/activity/fetcher.rb:91:in `events'
plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/activity_fetcher_patch.rb:6:in `events'
app/controllers/users_controller.rb:95:in `block (2 levels) in show'
app/controllers/users_controller.rb:93:in `show'
lib/redmine/sudo_mode.rb:61:in `sudo_mode'

Plugin customization

I would like to buy a small customization for this plugin. I would like to track users worktime to related project instead of the main project.

Source code: https://github.com/nanego/redmine_multiprojects_issue

Could anyone send me a price quote for this?

Thanks

Projects do not appear

Hello, help me please. I click on the link Edit projects list, displays the load and nothing further happens.
Redmine

Redmine version 2.5.0.stable
Ruby version 1.9.3-p545 (2014-02-24) [x86_64-linux]
Rails version 3.2.17
Environment production
Database adapter Mysql2

Plugins compatible with redmine_agile

when use plugin redmine_agile and install redmine_multiprojects_issues,
Redmine V4.1.1, Centos8, Postgresql
Plugins list:
drwxrwxr-x. 9 redmine redmine 138 Jan 4 16:13 redmine_agile
drwxrwxr-x. 8 redmine redmine 144 Jan 4 16:13 redmine_announcements
drwxrwxr-x. 5 redmine redmine 109 Jan 4 16:13 redmine_base_deface
drwxrwxr-x. 5 redmine redmine 90 Jan 4 16:13 redmine_base_stimulusjs
drwxrwxr-x. 9 redmine redmine 119 Jan 4 16:13 redmine_checklists
drwxrwxr-x. 9 redmine redmine 138 Jan 4 16:13 redmine_contacts
drwxrwxr-x. 11 redmine redmine 4096 Jan 4 16:13 redmine_dashboard
drwxrwxr-x. 10 redmine redmine 173 Jan 4 16:13 redmine_favorite_projects
drwxrwxr-x. 14 redmine redmine 4096 Jan 4 16:13 redmine_issue_templates
drwxrwxr-x. 9 redmine redmine 158 Jan 4 16:13 redmine_multiprojects_issue
drwxrwxr-x. 9 redmine redmine 119 Jan 4 16:13 redmine_people
drwxrwxr-x. 9 redmine redmine 104 Jan 4 16:13 redmine_products
drwxrwxr-x. 9 redmine redmine 119 Jan 4 16:13 redmine_resources
drwxrwxr-x. 10 redmine redmine 4096 Jan 4 16:13 redmine_risks
drwxrwxr-x. 8 redmine redmine 141 Jan 4 16:13 redmine_status_history
drwxrwxr-x. 9 redmine redmine 119 Jan 4 16:13 redmineup_tags
drwxrwxr-x. 9 redmine redmine 172 Jan 4 16:13 redmine_work_time
drwxrwxr-x. 9 redmine redmine 119 Jan 4 16:13 redmine_zenedit
drwxrwxr-x. 8 redmine redmine 131 Jan 4 16:13 scrum
drwxrwxr-x. 11 redmine redmine 264 Jan 4 16:13 view_customize
the calendar page will crash?
log is followed:
eating scope :system. Overwriting existing method Enumeration.system.
�[1m�[36mAnonymousUser Load (0.6ms)�[0m �[1m�[34mSELECT "users".* FROM "users" WHERE "users"."type" IN ('AnonymousUser') AND "users"."lastname" = $1 LIMIT $2�[0m [["lastname", "Anonymous"], ["LIMIT", 1]]
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
�[1m�[35m (0.5ms)�[0m �[1m�[34mSELECT version FROM schema_migrations�[0m
�[1m�[35m (0.2ms)�[0m �[1m�[34mSELECT pg_try_advisory_lock(5339476299225889275)�[0m
�[1m�[35m (0.5ms)�[0m �[1m�[34mSELECT version FROM schema_migrations�[0m
Migrating to CreateIssuesProjects (1)
�[1m�[35m (0.1ms)�[0m �[1m�[35mBEGIN�[0m
�[1m�[35m (1.9ms)�[0m �[1m�[35mCREATE TABLE "issues_projects" ("issue_id" integer, "project_id" integer)�[0m
�[1m�[36mActiveRecord::SchemaMigration Create (0.3ms)�[0m �[1m�[32mINSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"�[0m [["version", "1-redmine_multiprojects_issue"]]
�[1m�[35m (0.6ms)�[0m �[1m�[35mCOMMIT�[0m
Migrating to AddUniqueIndex (2)
�[1m�[35m (0.1ms)�[0m �[1m�[35mBEGIN�[0m
�[1m�[35m (1.0ms)�[0m �[1m�[35mCREATE UNIQUE INDEX "index_issues_projects_on_issue_id_and_project_id" ON "issues_projects" ("issue_id", "project_id")�[0m
�[1m�[36mActiveRecord::SchemaMigration Create (0.2ms)�[0m �[1m�[32mINSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"�[0m [["version", "2-redmine_multiprojects_issue"]]
�[1m�[35m (0.3ms)�[0m �[1m�[35mCOMMIT�[0m
Migrating to AddAllowAnswersOnSecondaryProjectsToIssues (3)
�[1m�[35m (0.1ms)�[0m �[1m�[35mBEGIN�[0m
�[1m�[35m (11.9ms)�[0m �[1m�[35mALTER TABLE "issues" ADD "answers_on_secondary_projects" boolean DEFAULT TRUE NOT NULL�[0m
�[1m�[36mActiveRecord::SchemaMigration Create (0.3ms)�[0m �[1m�[32mINSERT INTO "schema_migrations" ("version") VALUES ($1) RETURNING "version"�[0m [["version", "3-redmine_multiprojects_issue"]]
�[1m�[35m (1.5ms)�[0m �[1m�[35mCOMMIT�[0m
�[1m�[36mActiveRecord::InternalMetadata Load (0.3ms)�[0m �[1m�[34mSELECT "ar_internal_metadata".* FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2�[0m [["key", "environment"], ["LIMIT", 1]]
�[1m�[35m (0.1ms)�[0m �[1m�[35mBEGIN�[0m
�[1m�[35m (0.1ms)�[0m �[1m�[35mCOMMIT�[0m
�[1m�[35m (0.2ms)�[0m �[1m�[34mSELECT pg_advisory_unlock(5339476299225889275)�[0m
�[1m�[35m (1.6ms)�[0m �[1m�[34mSELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC�[0m
Creating scope :sorted. Overwriting existing method Group.sorted.
Creating scope :sorted. Overwriting existing method User.sorted.
Creating scope :having_mail. Overwriting existing method User.having_mail.
Creating scope :system. Overwriting existing method Enumeration.system.
�[1m�[36mAnonymousUser Load (1.4ms)�[0m �[1m�[34mSELECT "users".* FROM "users" WHERE "users"."type" IN ('AnonymousUser') AND "users"."lastname" = $1 LIMIT $2�[0m [["lastname", "Anonymous"], ["LIMIT", 1]]
Creating scope :visible. Overwriting existing method AgileQuery.visible.
Creating scope :visible. Overwriting existing method FavoriteProjectsQuery.visible.
Creating scope :visible. Overwriting existing method PeopleQuery.visible.
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
DEPRECATION WARNING: Using a dynamic :action segment in a route is deprecated and will be removed in Rails 6.0. (called from instance_eval at /opt/redmine/config/routes.rb:370)
Started GET "/projects/test_project/issues/calendar" for 172.16.55.140 at 2021-01-04 16:59:07 +0800
Processing by CalendarsController#show as HTML
Parameters: {"project_id"=>"test_project"}
�[1m�[36mSetting Load (0.5ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "session_lifetime"], ["LIMIT", 1]]
�[1m�[36mSetting Load (0.3ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "session_timeout"], ["LIMIT", 1]]
�[1m�[36mToken Update All (1.2ms)�[0m �[1m�[33mUPDATE "tokens" SET "updated_on" = '2021-01-04 16:59:07.400726' WHERE "tokens"."user_id" = $1 AND "tokens"."value" = $2 AND "tokens"."action" = $3�[0m [["user_id", 1], ["value", "dedda96b54a3400336edb29ad78c542253832ad3"], ["action", "session"]]
�[1m�[35m (0.6ms)�[0m �[1m�[34mSELECT MAX("settings"."updated_on") FROM "settings"�[0m
�[1m�[36mUser Load (1.5ms)�[0m �[1m�[34mSELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser', 'Person') AND "users"."status" = $1 AND "users"."id" = $2 LIMIT $3�[0m [["status", 1], ["id", 1], ["LIMIT", 1]]
Current user: admin (id=1)
�[1m�[36mSetting Load (0.4ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "force_default_language_for_loggedin"], ["LIMIT", 1]]
�[1m�[36mSetting Load (0.3ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "default_language"], ["LIMIT", 1]]
�[1m�[36mProject Load (0.4ms)�[0m �[1m�[34mSELECT "projects".* FROM "projects" WHERE "projects"."identifier" = $1 LIMIT $2�[0m [["identifier", "test_project"], ["LIMIT", 1]]
�[1m�[35m (0.5ms)�[0m �[1m�[34mSELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1�[0m [["project_id", 2]]
�[1m�[36mUserPreference Load (0.5ms)�[0m �[1m�[34mSELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT $2�[0m [["user_id", 1], ["LIMIT", 1]]
�[1m�[36mSetting Load (0.3ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "start_of_week"], ["LIMIT", 1]]
�[1m�[36mTracker Load (4.6ms)�[0m �[1m�[34mSELECT DISTINCT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "projects_trackers"."tracker_id" = "trackers"."id" INNER JOIN "projects" ON "projects"."id" = "projects_trackers"."project_id" INNER JOIN "enabled_modules" ON "enabled_modules"."project_id" = "projects"."id" WHERE (projects.status <> 9) AND "enabled_modules"."name" = $1 AND (projects.lft >= 1 AND projects.rgt <= 2) AND (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) ORDER BY "trackers"."position" ASC�[0m [["name", "issue_tracking"]]
�[1m�[36mIssuePriority Load (0.5ms)�[0m �[1m�[34mSELECT "enumerations".* FROM "enumerations" WHERE "enumerations"."type" IN ('IssuePriority') ORDER BY "enumerations"."position" ASC�[0m
�[1m�[36mIssueCustomField Load (1.2ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" IN ('IssueCustomField') AND (is_for_all = TRUE OR id IN (SELECT DISTINCT cfp.custom_field_id FROM custom_fields_projects cfp WHERE cfp.project_id = 2)) AND "custom_fields"."is_filter" = $1 ORDER BY "custom_fields"."position" ASC�[0m [["is_filter", true]]
�[1m�[36mCustomField Load (0.3ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1�[0m [["is_filter", true]]
�[1m�[36mSprint Exists (0.8ms)�[0m �[1m�[34mSELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mSprint Load (0.7ms)�[0m �[1m�[34mSELECT "sprints".* FROM "sprints" WHERE "sprints"."project_id" = $1 ORDER BY sprint_start_date ASC, name ASC�[0m [["project_id", 2]]
�[1m�[36mCACHE CustomField Load (0.0ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1�[0m [["is_filter", true]]
�[1m�[36mIssueCustomField Load (0.8ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" IN ('IssueCustomField') AND (is_for_all = TRUE OR id IN (SELECT DISTINCT cfp.custom_field_id FROM custom_fields_projects cfp WHERE cfp.project_id = 2)) ORDER BY "custom_fields"."position" ASC�[0m
�[1m�[36mSetting Load (0.4ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "user_format"], ["LIMIT", 1]]
�[1m�[35m (0.4ms)�[0m �[1m�[34mSELECT "users"."id" FROM "users" WHERE "users"."type" IN ('GroupNonMember')�[0m
�[1m�[35m (1.0ms)�[0m �[1m�[34mSELECT "members"."user_id", "role_id", "members"."project_id" FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" WHERE (projects.status <> 9) AND (members.user_id = 1 OR (projects.is_public = TRUE AND members.user_id = 3))�[0m
�[1m�[36mSetting Load (0.3ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "issue_list_default_columns"], ["LIMIT", 1]]
�[1m�[35mSQL (15.2ms)�[0m �[1m�[34mSELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."subject" AS t0_r3, "issues"."description" AS t0_r4, "issues"."due_date" AS t0_r5, "issues"."category_id" AS t0_r6, "issues"."status_id" AS t0_r7, "issues"."assigned_to_id" AS t0_r8, "issues"."priority_id" AS t0_r9, "issues"."fixed_version_id" AS t0_r10, "issues"."author_id" AS t0_r11, "issues"."lock_version" AS t0_r12, "issues"."created_on" AS t0_r13, "issues"."updated_on" AS t0_r14, "issues"."start_date" AS t0_r15, "issues"."done_ratio" AS t0_r16, "issues"."estimated_hours" AS t0_r17, "issues"."parent_id" AS t0_r18, "issues"."root_id" AS t0_r19, "issues"."lft" AS t0_r20, "issues"."rgt" AS t0_r21, "issues"."is_private" AS t0_r22, "issues"."closed_on" AS t0_r23, "issues"."sprint_id" AS t0_r24, "issues"."position" AS t0_r25, "issues"."answers_on_secondary_projects" AS t0_r26, "issue_statuses"."id" AS t1_r0, "issue_statuses"."name" AS t1_r1, "issue_statuses"."is_closed" AS t1_r2, "issue_statuses"."position" AS t1_r3, "issue_statuses"."default_done_ratio" AS t1_r4, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12, "projects"."default_version_id" AS t2_r13, "projects"."default_assigned_to_id" AS t2_r14, "projects"."product_backlog_id" AS t2_r15, "trackers"."id" AS t3_r0, "trackers"."name" AS t3_r1, "trackers"."is_in_chlog" AS t3_r2, "trackers"."position" AS t3_r3, "trackers"."is_in_roadmap" AS t3_r4, "trackers"."fields_bits" AS t3_r5, "trackers"."default_status_id" AS t3_r6, "trackers"."description" AS t3_r7, "users"."id" AS t4_r0, "users"."login" AS t4_r1, "users"."hashed_password" AS t4_r2, "users"."firstname" AS t4_r3, "users"."lastname" AS t4_r4, "users"."admin" AS t4_r5, "users"."status" AS t4_r6, "users"."last_login_on" AS t4_r7, "users"."language" AS t4_r8, "users"."auth_source_id" AS t4_r9, "users"."created_on" AS t4_r10, "users"."updated_on" AS t4_r11, "users"."type" AS t4_r12, "users"."identity_url" AS t4_r13, "users"."mail_notification" AS t4_r14, "users"."salt" AS t4_r15, "users"."must_change_passwd" AS t4_r16, "users"."passwd_changed_on" AS t4_r17, "enumerations"."id" AS t5_r0, "enumerations"."name" AS t5_r1, "enumerations"."position" AS t5_r2, "enumerations"."is_default" AS t5_r3, "enumerations"."type" AS t5_r4, "enumerations"."active" AS t5_r5, "enumerations"."project_id" AS t5_r6, "enumerations"."parent_id" AS t5_r7, "enumerations"."position_name" AS t5_r8, "sprints"."id" AS t6_r0, "sprints"."name" AS t6_r1, "sprints"."description" AS t6_r2, "sprints"."sprint_start_date" AS t6_r3, "sprints"."sprint_end_date" AS t6_r4, "sprints"."user_id" AS t6_r5, "sprints"."project_id" AS t6_r6, "sprints"."created_on" AS t6_r7, "sprints"."updated_on" AS t6_r8, "sprints"."is_product_backlog" AS t6_r9, "sprints"."status" AS t6_r10, "sprints"."shared" AS t6_r11 FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_id" LEFT OUTER JOIN "trackers" ON "trackers"."id" = "issues"."tracker_id" LEFT OUTER JOIN "users" ON "users"."id" = "issues"."assigned_to_id" LEFT OUTER JOIN "enumerations" ON "enumerations"."id" = "issues"."priority_id" AND "enumerations"."type" IN ('IssuePriority') LEFT OUTER JOIN "sprints" ON "sprints"."id" = "issues"."sprint_id" WHERE (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=FALSE)) AND ((projects.id = 2) OR issues.id IN (SELECT issue_id FROM issues_projects WHERE project_id = 2))) AND (((start_date BETWEEN '2020-12-27' AND '2021-02-06') OR (due_date BETWEEN '2020-12-27' AND '2021-02-06'))) ORDER BY issues.id DESC�[0m
�[1m�[35mSQL (1.4ms)�[0m �[1m�[34mSELECT "versions"."id" AS t0_r0, "versions"."project_id" AS t0_r1, "versions"."name" AS t0_r2, "versions"."description" AS t0_r3, "versions"."effective_date" AS t0_r4, "versions"."created_on" AS t0_r5, "versions"."updated_on" AS t0_r6, "versions"."wiki_page_title" AS t0_r7, "versions"."status" AS t0_r8, "versions"."sharing" 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, "projects"."default_version_id" AS t1_r13, "projects"."default_assigned_to_id" AS t1_r14, "projects"."product_backlog_id" AS t1_r15 FROM "versions" INNER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (projects.id = 2) AND (effective_date BETWEEN '2020-12-27' AND '2021-02-06')�[0m
Rendering calendars/show.html.erb within layouts/base
�[1m�[36mTracker Load (1.6ms)�[0m �[1m�[34mSELECT DISTINCT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "projects_trackers"."tracker_id" = "trackers"."id" INNER JOIN "projects" ON "projects"."id" = "projects_trackers"."project_id" INNER JOIN "enabled_modules" ON "enabled_modules"."project_id" = "projects"."id" WHERE (projects.status <> 9) AND "enabled_modules"."name" = $1 AND (projects.lft >= 1 AND projects.rgt <= 2) ORDER BY "trackers"."position" ASC�[0m [["name", "issue_tracking"]]
�[1m�[35m (1.1ms)�[0m �[1m�[34mSELECT DISTINCT "workflows"."old_status_id", "workflows"."new_status_id" FROM "workflows" WHERE "workflows"."type" IN ('WorkflowTransition') AND "workflows"."tracker_id" IN ($1, $2, $3)�[0m [["tracker_id", 1], ["tracker_id", 2], ["tracker_id", 3]]
�[1m�[36mIssueStatus Load (0.5ms)�[0m �[1m�[34mSELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" IN ($1, $2, $3, $4, $5, $6) ORDER BY "issue_statuses"."position" ASC�[0m [["id", 4], ["id", 3], ["id", 5], ["id", 2], ["id", 6], ["id", 1]]
Rendered queries/_filters.html.erb (15.3ms)
�[1m�[36mSetting Load (0.3ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "non_working_week_days"], ["LIMIT", 1]]
�[1m�[36mGroup Load (0.8ms)�[0m �[1m�[34mSELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND "groups_users"."user_id" = $1�[0m [["user_id", 1]]
�[1m�[36mSetting Load (0.3ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "date_format"], ["LIMIT", 1]]
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "ui_theme"], ["LIMIT", 1]]
Rendered common/_calendar.html.erb (13.6ms)
Rendered plugins/redmine_agile/app/views/agile_charts/_agile_charts.html.erb (0.4ms)
Rendered plugins/redmine_issue_templates/app/views/issue_templates/_issue_template_link.html.erb (1.6ms)
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "plugin_redmineup_tags"], ["LIMIT", 1]]
Rendered plugins/redmineup_tags/app/views/issues/_tags_sidebar.html.erb (1.7ms)
�[1m�[36mIssueQuery Load (1.4ms)�[0m �[1m�[34mSELECT "queries".* FROM "queries" LEFT OUTER JOIN projects ON queries.project_id = projects.id WHERE "queries"."type" IN ('IssueQuery') AND (queries.project_id IS NULL OR (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking'))) AND (queries.visibility <> 0 OR queries.user_id = 1) AND ("queries"."project_id" = $1 OR "queries"."project_id" IS NULL) ORDER BY "queries"."name" ASC, "queries"."id" ASC�[0m [["project_id", 2]]
Rendered issues/_sidebar.html.erb (20.1ms)
Rendered calendars/show.html.erb within layouts/base (78.1ms)
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "app_title"], ["LIMIT", 1]]
Rendered plugins/redmine_contacts/app/views/common/_additional_assets.html.erb (0.9ms)
Rendered plugins/redmineup_tags/app/views/tags/_additional_assets.html.erb (0.8ms)
Rendered plugins/scrum/app/views/scrum_hooks/_head.html.erb (0.7ms)
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "plugin_view_customize"], ["LIMIT", 1]]
�[1m�[36mToken Load (0.5ms)�[0m �[1m�[34mSELECT "tokens".* FROM "tokens" WHERE "tokens"."user_id" = $1 AND (action='api') LIMIT $2�[0m [["user_id", 1], ["LIMIT", 1]]
�[1m�[36mCustomField Load (0.5ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'UserCustomField') ORDER BY "custom_fields"."position" ASC�[0m
�[1m�[36mMember Load (0.5ms)�[0m �[1m�[34mSELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND "projects"."status" != $2 AND "members"."project_id" = $3 ORDER BY "members"."id" ASC LIMIT $4�[0m [["user_id", 1], ["status", 9], ["project_id", 2], ["LIMIT", 1]]
�[1m�[36mRole Load (0.5ms)�[0m �[1m�[34mSELECT "roles".* FROM "roles" WHERE "roles"."builtin" = $1 LIMIT $2�[0m [["builtin", 1], ["LIMIT", 1]]
�[1m�[36mMember Load (0.8ms)�[0m �[1m�[34mSELECT "members".* FROM "members" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE "members"."project_id" = $1 AND "users"."type" IN ($2, $3)�[0m [["project_id", 2], ["type", "GroupAnonymous"], ["type", "GroupNonMember"]]
�[1m�[36mCustomField Load (0.5ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'ProjectCustomField') ORDER BY "custom_fields"."position" ASC�[0m
�[1m�[36mViewCustomize Load (0.6ms)�[0m �[1m�[34mSELECT "view_customizes".* FROM "view_customizes" ORDER BY "view_customizes"."id" ASC�[0m
Rendered plugins/redmine_favorite_projects/app/views/favorite_projects/_additional_assets.html.erb (0.5ms)
Rendered plugins/redmine_zenedit/app/views/zenedit/_additional_assets.html.erb (0.4ms)
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "gravatar_enabled"], ["LIMIT", 1]]
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "plugin_redmine_work_time"], ["LIMIT", 1]]
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "plugin_redmine_contacts"], ["LIMIT", 1]]
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "plugin_redmine_products"], ["LIMIT", 1]]
�[1m�[36mProject Load (0.6ms)�[0m �[1m�[34mSELECT "projects"."id", "projects"."name", "projects"."identifier", "projects"."lft", "projects"."rgt" FROM "projects" INNER JOIN "members" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND "projects"."status" != $2 AND "projects"."status" = $3�[0m [["user_id", 1], ["status", 9], ["status", 1]]
�[1m�[36mProject Load (0.4ms)�[0m �[1m�[34mSELECT "projects".* FROM "projects" WHERE 1=0 AND (projects.status <> 9)�[0m
�[1m�[36mProject Load (0.4ms)�[0m �[1m�[34mSELECT "projects".* FROM "projects" WHERE "projects"."id" IN ($1, $2)�[0m [["id", 2], ["id", 3]]
�[1m�[36mTracker Exists (0.6ms)�[0m �[1m�[34mSELECT 1 AS one FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "new_item_menu_tab"], ["LIMIT", 1]]
�[1m�[36mCACHE Tracker Exists (0.0ms)�[0m �[1m�[34mSELECT 1 AS one FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mAnnouncement Load (1.0ms)�[0m �[1m�[34mSELECT "announcements".* FROM "announcements" INNER JOIN "projects" ON "projects"."id" = "announcements"."project_id" WHERE (projects.status = 1 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='announcements')) AND "announcements"."project_id" = $1�[0m [["project_id", 2]]
�[1m�[36mVersion Exists (1.3ms)�[0m �[1m�[34mSELECT 1 AS one FROM "versions" INNER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 2 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 2 AND versions.sharing = 'tree') OR (projects.lft < 1 AND projects.rgt > 2 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 1 AND projects.rgt < 2 AND versions.sharing = 'hierarchy')))) LIMIT $1�[0m [["LIMIT", 1]]
�[1m�[36mWiki Load (0.5ms)�[0m �[1m�[34mSELECT "wikis".* FROM "wikis" WHERE "wikis"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mBoard Exists (0.4ms)�[0m �[1m�[34mSELECT 1 AS one FROM "boards" WHERE "boards"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mRepository Load (0.4ms)�[0m �[1m�[34mSELECT "repositories".* FROM "repositories" WHERE "repositories"."project_id" = $1 AND "repositories"."is_default" = $2 LIMIT $3�[0m [["project_id", 2], ["is_default", true], ["LIMIT", 1]]
�[1m�[36mSetting Load (0.2ms)�[0m �[1m�[34mSELECT "settings".* FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2�[0m [["name", "plugin_scrum"], ["LIMIT", 1]]
�[1m�[36mEnabledModule Load (0.3ms)�[0m �[1m�[34mSELECT "enabled_modules".* FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1�[0m [["project_id", 2]]
�[1m�[36mRole Load (0.3ms)�[0m �[1m�[34mSELECT "roles".* FROM "roles"�[0m
�[1m�[36mSprint Exists (0.4ms)�[0m �[1m�[34mSELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 AND "sprints"."is_product_backlog" = $2 LIMIT $3�[0m [["project_id", 2], ["is_product_backlog", true], ["LIMIT", 1]]
�[1m�[36mSprint Exists (0.4ms)�[0m �[1m�[34mSELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 AND "sprints"."is_product_backlog" = $2 LIMIT $3�[0m [["project_id", 2], ["is_product_backlog", false], ["LIMIT", 1]]
Rendered plugins/scrum/app/views/scrum_hooks/_scrum_tips.html.erb (16.6ms)
�[1m�[36mProject Load (0.5ms)�[0m �[1m�[34mSELECT "projects".* FROM "projects" WHERE (projects.lft <= 1 AND projects.rgt >= 2) ORDER BY "projects"."lft" ASC�[0m
�[1m�[36mAnnouncement Exists (1.3ms)�[0m �[1m�[34mSELECT 1 AS one FROM "announcements" LEFT OUTER JOIN projects on projects.id = announcements.project_id WHERE (projects.status = 1 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='announcements') OR (project_id IS NULL)) AND (announcements.starts_at <= now() AND announcements.ends_at >= now()) AND ("announcements"."project_id" = $1 OR "announcements"."project_id" IS NULL) AND ((projects.status = 1 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='announcements')) OR (project_id IS NULL)) LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
Rendered plugins/redmine_announcements/app/views/application/_announcements.html.erb (4.1ms)
Rendered plugins/redmine_contacts/app/views/common/_contacts_select2_data.html.erb (1.1ms)
Rendered plugins/redmineup_tags/app/views/tags/_select2_transformation_rules.html.erb (0.5ms)
�[1m�[36mCACHE ViewCustomize Load (0.0ms)�[0m �[1m�[34mSELECT "view_customizes".* FROM "view_customizes" ORDER BY "view_customizes"."id" ASC�[0m
Rendered plugins/redmine_favorite_projects/app/views/favorite_projects/_select2_transformation_rules.html.erb (0.5ms)
Rendered plugins/redmine_people/app/views/common/_people_select2_data.html.erb (0.5ms)
Rendered plugins/redmine_people/app/views/common/_layout_bottom.html.erb (4.8ms)
Rendered plugins/redmine_products/app/views/products/_select2_transformation_rules.html.erb (0.7ms)
�[1m�[35mSQL (0.8ms)�[0m �[1m�[34mSELECT "sprints"."id" AS t0_r0, "sprints"."name" AS t0_r1, "sprints"."description" AS t0_r2, "sprints"."sprint_start_date" AS t0_r3, "sprints"."sprint_end_date" AS t0_r4, "sprints"."user_id" AS t0_r5, "sprints"."project_id" AS t0_r6, "sprints"."created_on" AS t0_r7, "sprints"."updated_on" AS t0_r8, "sprints"."is_product_backlog" AS t0_r9, "sprints"."status" AS t0_r10, "sprints"."shared" AS t0_r11, "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, "projects"."default_version_id" AS t1_r13, "projects"."default_assigned_to_id" AS t1_r14, "projects"."product_backlog_id" AS t1_r15 FROM "sprints" INNER JOIN "projects" ON "projects"."id" = "sprints"."project_id" WHERE ((((projects.id = 2) OR issues.id IN (SELECT issue_id FROM issues_projects WHERE project_id = 2)))) AND "sprints"."sprint_start_date" BETWEEN $1 AND $2 AND "sprints"."is_product_backlog" = $3�[0m [["sprint_start_date", "2020-12-27"], ["sprint_start_date", "2021-02-06"], ["is_product_backlog", false]]
Completed 500 Internal Server Error in 613ms (Views: 206.1ms | ActiveRecord: 182.0ms)

ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: missing FROM-clause entry for table "issues"
LINE 1: ...rints"."project_id" WHERE ((((projects.id = 2) OR issues.id ...
^
: SELECT "sprints"."id" AS t0_r0, "sprints"."name" AS t0_r1, "sprints"."description" AS t0_r2, "sprints"."sprint_start_date" AS t0_r3, "sprints"."sprint_end_date" AS t0_r4, "sprints"."user_id" AS t0_r5, "sprints"."project_id" AS t0_r6, "sprints"."created_on" AS t0_r7, "sprints"."updated_on" AS t0_r8, "sprints"."is_product_backlog" AS t0_r9, "sprints"."status" AS t0_r10, "sprints"."shared" AS t0_r11, "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, "projects"."default_version_id" AS t1_r13, "projects"."default_assigned_to_id" AS t1_r14, "projects"."product_backlog_id" AS t1_r15 FROM "sprints" INNER JOIN "projects" ON "projects"."id" = "sprints"."project_id" WHERE ((((projects.id = 2) OR issues.id IN (SELECT issue_id FROM issues_projects WHERE project_id = 2)))) AND "sprints"."sprint_start_date" BETWEEN $1 AND $2 AND "sprints"."is_product_backlog" = $3):

plugins/scrum/lib/scrum/calendars_controller_patch.rb:35:in query_sprints' plugins/scrum/lib/scrum/calendars_controller_patch.rb:24:in add_sprints'
lib/redmine/sudo_mode.rb:65:in `sudo_mode'
Started GET "/projects/test_project/issues/calendar" for 172.16.55.140 at 2021-01-04 16:59:11 +0800
Processing by CalendarsController#show as HTML
Parameters: {"project_id"=>"test_project"}
�[1m�[36mToken Update All (1.0ms)�[0m �[1m�[33mUPDATE "tokens" SET "updated_on" = '2021-01-04 16:59:11.232391' WHERE "tokens"."user_id" = $1 AND "tokens"."value" = $2 AND "tokens"."action" = $3�[0m [["user_id", 1], ["value", "dedda96b54a3400336edb29ad78c542253832ad3"], ["action", "session"]]
�[1m�[35m (0.5ms)�[0m �[1m�[34mSELECT MAX("settings"."updated_on") FROM "settings"�[0m
�[1m�[36mUser Load (0.6ms)�[0m �[1m�[34mSELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser', 'Person') AND "users"."status" = $1 AND "users"."id" = $2 LIMIT $3�[0m [["status", 1], ["id", 1], ["LIMIT", 1]]
Current user: admin (id=1)
�[1m�[36mProject Load (0.4ms)�[0m �[1m�[34mSELECT "projects".* FROM "projects" WHERE "projects"."identifier" = $1 LIMIT $2�[0m [["identifier", "test_project"], ["LIMIT", 1]]
�[1m�[35m (0.3ms)�[0m �[1m�[34mSELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1�[0m [["project_id", 2]]
�[1m�[36mUserPreference Load (0.3ms)�[0m �[1m�[34mSELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT $2�[0m [["user_id", 1], ["LIMIT", 1]]
�[1m�[36mTracker Load (3.0ms)�[0m �[1m�[34mSELECT DISTINCT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "projects_trackers"."tracker_id" = "trackers"."id" INNER JOIN "projects" ON "projects"."id" = "projects_trackers"."project_id" INNER JOIN "enabled_modules" ON "enabled_modules"."project_id" = "projects"."id" WHERE (projects.status <> 9) AND "enabled_modules"."name" = $1 AND (projects.lft >= 1 AND projects.rgt <= 2) AND (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) ORDER BY "trackers"."position" ASC�[0m [["name", "issue_tracking"]]
�[1m�[36mIssuePriority Load (0.5ms)�[0m �[1m�[34mSELECT "enumerations".* FROM "enumerations" WHERE "enumerations"."type" IN ('IssuePriority') ORDER BY "enumerations"."position" ASC�[0m
�[1m�[36mIssueCustomField Load (0.8ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" IN ('IssueCustomField') AND (is_for_all = TRUE OR id IN (SELECT DISTINCT cfp.custom_field_id FROM custom_fields_projects cfp WHERE cfp.project_id = 2)) AND "custom_fields"."is_filter" = $1 ORDER BY "custom_fields"."position" ASC�[0m [["is_filter", true]]
�[1m�[36mCustomField Load (0.3ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1�[0m [["is_filter", true]]
�[1m�[36mSprint Exists (0.4ms)�[0m �[1m�[34mSELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mSprint Load (0.5ms)�[0m �[1m�[34mSELECT "sprints".* FROM "sprints" WHERE "sprints"."project_id" = $1 ORDER BY sprint_start_date ASC, name ASC�[0m [["project_id", 2]]
�[1m�[36mCACHE CustomField Load (0.0ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1�[0m [["is_filter", true]]
�[1m�[36mIssueCustomField Load (0.7ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" IN ('IssueCustomField') AND (is_for_all = TRUE OR id IN (SELECT DISTINCT cfp.custom_field_id FROM custom_fields_projects cfp WHERE cfp.project_id = 2)) ORDER BY "custom_fields"."position" ASC�[0m
�[1m�[35m (0.4ms)�[0m �[1m�[34mSELECT "users"."id" FROM "users" WHERE "users"."type" IN ('GroupNonMember')�[0m
�[1m�[35m (1.1ms)�[0m �[1m�[34mSELECT "members"."user_id", "role_id", "members"."project_id" FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" WHERE (projects.status <> 9) AND (members.user_id = 1 OR (projects.is_public = TRUE AND members.user_id = 3))�[0m
�[1m�[35mSQL (15.3ms)�[0m �[1m�[34mSELECT "issues"."id" AS t0_r0, "issues"."tracker_id" AS t0_r1, "issues"."project_id" AS t0_r2, "issues"."subject" AS t0_r3, "issues"."description" AS t0_r4, "issues"."due_date" AS t0_r5, "issues"."category_id" AS t0_r6, "issues"."status_id" AS t0_r7, "issues"."assigned_to_id" AS t0_r8, "issues"."priority_id" AS t0_r9, "issues"."fixed_version_id" AS t0_r10, "issues"."author_id" AS t0_r11, "issues"."lock_version" AS t0_r12, "issues"."created_on" AS t0_r13, "issues"."updated_on" AS t0_r14, "issues"."start_date" AS t0_r15, "issues"."done_ratio" AS t0_r16, "issues"."estimated_hours" AS t0_r17, "issues"."parent_id" AS t0_r18, "issues"."root_id" AS t0_r19, "issues"."lft" AS t0_r20, "issues"."rgt" AS t0_r21, "issues"."is_private" AS t0_r22, "issues"."closed_on" AS t0_r23, "issues"."sprint_id" AS t0_r24, "issues"."position" AS t0_r25, "issues"."answers_on_secondary_projects" AS t0_r26, "issue_statuses"."id" AS t1_r0, "issue_statuses"."name" AS t1_r1, "issue_statuses"."is_closed" AS t1_r2, "issue_statuses"."position" AS t1_r3, "issue_statuses"."default_done_ratio" AS t1_r4, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12, "projects"."default_version_id" AS t2_r13, "projects"."default_assigned_to_id" AS t2_r14, "projects"."product_backlog_id" AS t2_r15, "trackers"."id" AS t3_r0, "trackers"."name" AS t3_r1, "trackers"."is_in_chlog" AS t3_r2, "trackers"."position" AS t3_r3, "trackers"."is_in_roadmap" AS t3_r4, "trackers"."fields_bits" AS t3_r5, "trackers"."default_status_id" AS t3_r6, "trackers"."description" AS t3_r7, "users"."id" AS t4_r0, "users"."login" AS t4_r1, "users"."hashed_password" AS t4_r2, "users"."firstname" AS t4_r3, "users"."lastname" AS t4_r4, "users"."admin" AS t4_r5, "users"."status" AS t4_r6, "users"."last_login_on" AS t4_r7, "users"."language" AS t4_r8, "users"."auth_source_id" AS t4_r9, "users"."created_on" AS t4_r10, "users"."updated_on" AS t4_r11, "users"."type" AS t4_r12, "users"."identity_url" AS t4_r13, "users"."mail_notification" AS t4_r14, "users"."salt" AS t4_r15, "users"."must_change_passwd" AS t4_r16, "users"."passwd_changed_on" AS t4_r17, "enumerations"."id" AS t5_r0, "enumerations"."name" AS t5_r1, "enumerations"."position" AS t5_r2, "enumerations"."is_default" AS t5_r3, "enumerations"."type" AS t5_r4, "enumerations"."active" AS t5_r5, "enumerations"."project_id" AS t5_r6, "enumerations"."parent_id" AS t5_r7, "enumerations"."position_name" AS t5_r8, "sprints"."id" AS t6_r0, "sprints"."name" AS t6_r1, "sprints"."description" AS t6_r2, "sprints"."sprint_start_date" AS t6_r3, "sprints"."sprint_end_date" AS t6_r4, "sprints"."user_id" AS t6_r5, "sprints"."project_id" AS t6_r6, "sprints"."created_on" AS t6_r7, "sprints"."updated_on" AS t6_r8, "sprints"."is_product_backlog" AS t6_r9, "sprints"."status" AS t6_r10, "sprints"."shared" AS t6_r11 FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" INNER JOIN "issue_statuses" ON "issue_statuses"."id" = "issues"."status_id" LEFT OUTER JOIN "trackers" ON "trackers"."id" = "issues"."tracker_id" LEFT OUTER JOIN "users" ON "users"."id" = "issues"."assigned_to_id" LEFT OUTER JOIN "enumerations" ON "enumerations"."id" = "issues"."priority_id" AND "enumerations"."type" IN ('IssuePriority') LEFT OUTER JOIN "sprints" ON "sprints"."id" = "issues"."sprint_id" WHERE (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=FALSE)) AND ((projects.id = 2) OR issues.id IN (SELECT issue_id FROM issues_projects WHERE project_id = 2))) AND (((start_date BETWEEN '2020-12-27' AND '2021-02-06') OR (due_date BETWEEN '2020-12-27' AND '2021-02-06'))) ORDER BY issues.id DESC�[0m
�[1m�[35mSQL (0.8ms)�[0m �[1m�[34mSELECT "versions"."id" AS t0_r0, "versions"."project_id" AS t0_r1, "versions"."name" AS t0_r2, "versions"."description" AS t0_r3, "versions"."effective_date" AS t0_r4, "versions"."created_on" AS t0_r5, "versions"."updated_on" AS t0_r6, "versions"."wiki_page_title" AS t0_r7, "versions"."status" AS t0_r8, "versions"."sharing" 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, "projects"."default_version_id" AS t1_r13, "projects"."default_assigned_to_id" AS t1_r14, "projects"."product_backlog_id" AS t1_r15 FROM "versions" INNER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking')) AND (projects.id = 2) AND (effective_date BETWEEN '2020-12-27' AND '2021-02-06')�[0m
Rendering calendars/show.html.erb within layouts/base
�[1m�[36mTracker Load (1.3ms)�[0m �[1m�[34mSELECT DISTINCT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "projects_trackers"."tracker_id" = "trackers"."id" INNER JOIN "projects" ON "projects"."id" = "projects_trackers"."project_id" INNER JOIN "enabled_modules" ON "enabled_modules"."project_id" = "projects"."id" WHERE (projects.status <> 9) AND "enabled_modules"."name" = $1 AND (projects.lft >= 1 AND projects.rgt <= 2) ORDER BY "trackers"."position" ASC�[0m [["name", "issue_tracking"]]
�[1m�[35m (0.6ms)�[0m �[1m�[34mSELECT DISTINCT "workflows"."old_status_id", "workflows"."new_status_id" FROM "workflows" WHERE "workflows"."type" IN ('WorkflowTransition') AND "workflows"."tracker_id" IN ($1, $2, $3)�[0m [["tracker_id", 1], ["tracker_id", 2], ["tracker_id", 3]]
�[1m�[36mIssueStatus Load (0.4ms)�[0m �[1m�[34mSELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" IN ($1, $2, $3, $4, $5, $6) ORDER BY "issue_statuses"."position" ASC�[0m [["id", 4], ["id", 3], ["id", 5], ["id", 2], ["id", 6], ["id", 1]]
Rendered queries/_filters.html.erb (10.2ms)
�[1m�[36mGroup Load (0.7ms)�[0m �[1m�[34mSELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND "groups_users"."user_id" = $1�[0m [["user_id", 1]]
Rendered common/_calendar.html.erb (5.1ms)
Rendered plugins/redmine_agile/app/views/agile_charts/_agile_charts.html.erb (0.1ms)
Rendered plugins/redmine_issue_templates/app/views/issue_templates/_issue_template_link.html.erb (0.9ms)
Rendered plugins/redmineup_tags/app/views/issues/_tags_sidebar.html.erb (0.1ms)
�[1m�[36mIssueQuery Load (1.1ms)�[0m �[1m�[34mSELECT "queries".* FROM "queries" LEFT OUTER JOIN projects ON queries.project_id = projects.id WHERE "queries"."type" IN ('IssueQuery') AND (queries.project_id IS NULL OR (projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='issue_tracking'))) AND (queries.visibility <> 0 OR queries.user_id = 1) AND ("queries"."project_id" = $1 OR "queries"."project_id" IS NULL) ORDER BY "queries"."name" ASC, "queries"."id" ASC�[0m [["project_id", 2]]
Rendered issues/_sidebar.html.erb (4.2ms)
Rendered calendars/show.html.erb within layouts/base (22.7ms)
Rendered plugins/redmine_contacts/app/views/common/_additional_assets.html.erb (0.5ms)
Rendered plugins/redmineup_tags/app/views/tags/_additional_assets.html.erb (0.3ms)
Rendered plugins/scrum/app/views/scrum_hooks/_head.html.erb (0.2ms)
�[1m�[36mToken Load (0.5ms)�[0m �[1m�[34mSELECT "tokens".* FROM "tokens" WHERE "tokens"."user_id" = $1 AND (action='api') LIMIT $2�[0m [["user_id", 1], ["LIMIT", 1]]
�[1m�[36mCustomField Load (0.5ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'UserCustomField') ORDER BY "custom_fields"."position" ASC�[0m
�[1m�[36mMember Load (0.5ms)�[0m �[1m�[34mSELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND "projects"."status" != $2 AND "members"."project_id" = $3 ORDER BY "members"."id" ASC LIMIT $4�[0m [["user_id", 1], ["status", 9], ["project_id", 2], ["LIMIT", 1]]
�[1m�[36mRole Load (0.3ms)�[0m �[1m�[34mSELECT "roles".* FROM "roles" WHERE "roles"."builtin" = $1 LIMIT $2�[0m [["builtin", 1], ["LIMIT", 1]]
�[1m�[36mMember Load (0.8ms)�[0m �[1m�[34mSELECT "members".* FROM "members" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE "members"."project_id" = $1 AND "users"."type" IN ($2, $3)�[0m [["project_id", 2], ["type", "GroupAnonymous"], ["type", "GroupNonMember"]]
�[1m�[36mCustomField Load (0.5ms)�[0m �[1m�[34mSELECT "custom_fields".* FROM "custom_fields" WHERE (type = 'ProjectCustomField') ORDER BY "custom_fields"."position" ASC�[0m
�[1m�[36mViewCustomize Load (0.4ms)�[0m �[1m�[34mSELECT "view_customizes".* FROM "view_customizes" ORDER BY "view_customizes"."id" ASC�[0m
Rendered plugins/redmine_favorite_projects/app/views/favorite_projects/_additional_assets.html.erb (0.2ms)
Rendered plugins/redmine_zenedit/app/views/zenedit/_additional_assets.html.erb (0.1ms)
�[1m�[36mProject Load (0.6ms)�[0m �[1m�[34mSELECT "projects"."id", "projects"."name", "projects"."identifier", "projects"."lft", "projects"."rgt" FROM "projects" INNER JOIN "members" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = $1 AND "projects"."status" != $2 AND "projects"."status" = $3�[0m [["user_id", 1], ["status", 9], ["status", 1]]
�[1m�[36mProject Load (0.4ms)�[0m �[1m�[34mSELECT "projects".* FROM "projects" WHERE 1=0 AND (projects.status <> 9)�[0m
�[1m�[36mProject Load (0.4ms)�[0m �[1m�[34mSELECT "projects".* FROM "projects" WHERE "projects"."id" IN ($1, $2)�[0m [["id", 2], ["id", 3]]
�[1m�[36mTracker Exists (0.6ms)�[0m �[1m�[34mSELECT 1 AS one FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mCACHE Tracker Exists (0.0ms)�[0m �[1m�[34mSELECT 1 AS one FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mAnnouncement Load (0.8ms)�[0m �[1m�[34mSELECT "announcements".* FROM "announcements" INNER JOIN "projects" ON "projects"."id" = "announcements"."project_id" WHERE (projects.status = 1 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='announcements')) AND "announcements"."project_id" = $1�[0m [["project_id", 2]]
�[1m�[36mVersion Exists (1.0ms)�[0m �[1m�[34mSELECT 1 AS one FROM "versions" INNER JOIN "projects" ON "projects"."id" = "versions"."project_id" WHERE (projects.id = 2 OR (projects.status <> 9 AND ( versions.sharing = 'system' OR (projects.lft >= 1 AND projects.rgt <= 2 AND versions.sharing = 'tree') OR (projects.lft < 1 AND projects.rgt > 2 AND versions.sharing IN ('hierarchy', 'descendants')) OR (projects.lft > 1 AND projects.rgt < 2 AND versions.sharing = 'hierarchy')))) LIMIT $1�[0m [["LIMIT", 1]]
�[1m�[36mWiki Load (0.4ms)�[0m �[1m�[34mSELECT "wikis".* FROM "wikis" WHERE "wikis"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mBoard Exists (0.4ms)�[0m �[1m�[34mSELECT 1 AS one FROM "boards" WHERE "boards"."project_id" = $1 LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
�[1m�[36mRepository Load (0.3ms)�[0m �[1m�[34mSELECT "repositories".* FROM "repositories" WHERE "repositories"."project_id" = $1 AND "repositories"."is_default" = $2 LIMIT $3�[0m [["project_id", 2], ["is_default", true], ["LIMIT", 1]]
�[1m�[36mEnabledModule Load (0.3ms)�[0m �[1m�[34mSELECT "enabled_modules".* FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1�[0m [["project_id", 2]]
�[1m�[36mRole Load (0.4ms)�[0m �[1m�[34mSELECT "roles".* FROM "roles"�[0m
�[1m�[36mSprint Exists (0.5ms)�[0m �[1m�[34mSELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 AND "sprints"."is_product_backlog" = $2 LIMIT $3�[0m [["project_id", 2], ["is_product_backlog", true], ["LIMIT", 1]]
�[1m�[36mSprint Exists (0.4ms)�[0m �[1m�[34mSELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 AND "sprints"."is_product_backlog" = $2 LIMIT $3�[0m [["project_id", 2], ["is_product_backlog", false], ["LIMIT", 1]]
Rendered plugins/scrum/app/views/scrum_hooks/_scrum_tips.html.erb (6.8ms)
�[1m�[36mProject Load (0.5ms)�[0m �[1m�[34mSELECT "projects".* FROM "projects" WHERE (projects.lft <= 1 AND projects.rgt >= 2) ORDER BY "projects"."lft" ASC�[0m
�[1m�[36mAnnouncement Exists (1.2ms)�[0m �[1m�[34mSELECT 1 AS one FROM "announcements" LEFT OUTER JOIN projects on projects.id = announcements.project_id WHERE (projects.status = 1 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='announcements') OR (project_id IS NULL)) AND (announcements.starts_at <= now() AND announcements.ends_at >= now()) AND ("announcements"."project_id" = $1 OR "announcements"."project_id" IS NULL) AND ((projects.status = 1 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE em.project_id = projects.id AND em.name='announcements')) OR (project_id IS NULL)) LIMIT $2�[0m [["project_id", 2], ["LIMIT", 1]]
Rendered plugins/redmine_announcements/app/views/application/_announcements.html.erb (3.1ms)
Rendered plugins/redmine_contacts/app/views/common/_contacts_select2_data.html.erb (0.5ms)
Rendered plugins/redmineup_tags/app/views/tags/_select2_transformation_rules.html.erb (0.2ms)
�[1m�[36mCACHE ViewCustomize Load (0.0ms)�[0m �[1m�[34mSELECT "view_customizes".* FROM "view_customizes" ORDER BY "view_customizes"."id" ASC�[0m
Rendered plugins/redmine_favorite_projects/app/views/favorite_projects/_select2_transformation_rules.html.erb (0.2ms)
Rendered plugins/redmine_people/app/views/common/_people_select2_data.html.erb (0.2ms)
Rendered plugins/redmine_people/app/views/common/_layout_bottom.html.erb (0.4ms)
Rendered plugins/redmine_products/app/views/products/_select2_transformation_rules.html.erb (0.3ms)
�[1m�[35mSQL (0.8ms)�[0m �[1m�[34mSELECT "sprints"."id" AS t0_r0, "sprints"."name" AS t0_r1, "sprints"."description" AS t0_r2, "sprints"."sprint_start_date" AS t0_r3, "sprints"."sprint_end_date" AS t0_r4, "sprints"."user_id" AS t0_r5, "sprints"."project_id" AS t0_r6, "sprints"."created_on" AS t0_r7, "sprints"."updated_on" AS t0_r8, "sprints"."is_product_backlog" AS t0_r9, "sprints"."status" AS t0_r10, "sprints"."shared" AS t0_r11, "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, "projects"."default_version_id" AS t1_r13, "projects"."default_assigned_to_id" AS t1_r14, "projects"."product_backlog_id" AS t1_r15 FROM "sprints" INNER JOIN "projects" ON "projects"."id" = "sprints"."project_id" WHERE ((((projects.id = 2) OR issues.id IN (SELECT issue_id FROM issues_projects WHERE project_id = 2)))) AND "sprints"."sprint_start_date" BETWEEN $1 AND $2 AND "sprints"."is_product_backlog" = $3�[0m [["sprint_start_date", "2020-12-27"], ["sprint_start_date", "2021-02-06"], ["is_product_backlog", false]]
Completed 500 Internal Server Error in 147ms (Views: 58.6ms | ActiveRecord: 43.4ms)

plugins/scrum/lib/scrum/calendars_controller_patch.rb:35:in query_sprints' plugins/scrum/lib/scrum/calendars_controller_patch.rb:24:in add_sprints'
lib/redmine/sudo_mode.rb:65:in `sudo_mode'

Plugin compatibility with Redmine 4.2

Hello,

thanks for your plugin, very useful.
This morning i tried to upgrade Redmine to version 4.2 but i have some errors.

NoMethodError (undefined method `where' for #<Proc:0x0000558422692548>
Did you mean?  when):
  
plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/acts_as_activity_provider.rb:27:in `find_events'
lib/redmine/activity/fetcher.rb:93:in `block (2 levels) in events'
lib/redmine/activity/fetcher.rb:92:in `each'
lib/redmine/activity/fetcher.rb:92:in `block in events'
lib/redmine/activity/fetcher.rb:91:in `each'
lib/redmine/activity/fetcher.rb:91:in `events'
plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/activity_fetcher_patch.rb:6:in `events'
app/controllers/activities_controller.rb:58:in `index'

Maybe due to the patch https://www.redmine.org/issues/33664?

Thanks

Incorrect output in Impacted projects column on redmine 3.2.0

Steps to reproduce: install clean redmine 3.2.0

Install redmine_multiproject_issue plugin

List issues in any project with column Impacted projects enabled

Ipact projects column shows strange records like Project::ActiveRecord_Associations_CollectionProxy:0x007fe172ec0f80

Make Related Projects a filter to search on

When we go to an issue list it would be cool if we could limit it to issues that have been linked to this project or that are related to this project and project X

Screenshot attached for clarity

Plugin installation

I tried to install the plugin on redmine 2.5.1, and faced several problems, essentially due to external plugin requirements.

Maybe it could be great to update installation description, and add links to the two plugins that are required?

redmine_base_deface
redmine_base_select2

Thanks!

Project overview shows wrong issue count

Hi,
I installed the plugin and it works pretty well.

While using it, I noticed that the project overview only shows issue count for main issues (issues created in the project). Issues from other projects are not taken in account.

Do you plan to fix this up ?
Thanks

forms changed error in production.log

Using branch 3.3-stable from https://github.com/redmine/redmine.git I get in production log:

Deface: [ERROR] The original source for 'show-projects-in-issue-description' has changed, this override should be reviewed to ensure it's still valid.
Deface: [ERROR] The original source for 'add-multiple-projects-to-issue-form' has changed, this override should be reviewed to ensure it's still valid.

so this seems related:

redmine@xx$ grep -r add-multiple-projects-to-issue-form plugins/
plugins/redmine_multiprojects_issue/app/overrides/issues/_form.rb:                     :name         => 'add-multiple-projects-to-issue-form',
redmine@xx$ grep -r show-projects-in-issue-description plugins/
plugins/redmine_multiprojects_issue/app/overrides/issues/show.rb:                     :name         => 'show-projects-in-issue-description',

Anything I can do here to fix this?

Thanx in advance
Falko

feature request: target version for each project

First off, nice work. It works as advertised! 👍

It would be real nice to be able to select a Target Version for each project individually.

This should show up in issue lists/searches matching the the Target Version filter for each project or even using the "Group By" functionality
When viewing an issue in the list it should show the Target Version applicable to that associated project.
The issues should show up in the appropriate Target Version section on the Roadmap page

Error on install/plugin-migration

On trying to install the Plugin to a Redmine 2.6.0 installation I get this:

root@redmine:/var/redmine# rake redmine:plugins
rake aborted!
Redmine::PluginNotFound: Redmine::PluginNotFound
/var/redmine/lib/redmine/plugin.rb:118:in find' /var/redmine/lib/redmine/plugin.rb:246:inrequires_redmine_plugin'
/var/redmine/plugins/redmine_multiprojects_issue/init.rb:19:in block in <top (required)>' /var/redmine/lib/redmine/plugin.rb:75:ininstance_eval'
/var/redmine/lib/redmine/plugin.rb:75:in register' /var/redmine/plugins/redmine_multiprojects_issue/init.rb:11:in<top (required)>'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:inrequire'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in block in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:236:inload_dependency'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in require' /var/redmine/lib/redmine/plugin.rb:150:inblock in load'
/var/redmine/lib/redmine/plugin.rb:141:in each' /var/redmine/lib/redmine/plugin.rb:141:inload'
/var/redmine/config/initializers/30-redmine.rb:19:in <top (required)>' /var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:245:inload'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:245:in block in load' /var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:236:inload_dependency'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:245:in load' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/engine.rb:593:inblock (2 levels) in class:Engine'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/engine.rb:592:in each' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/engine.rb:592:inblock in class:Engine'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:30:in instance_exec' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:30:inrun'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:55:in block in run_initializers' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:54:ineach'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:54:in run_initializers' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/application.rb:136:ininitialize!'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/railtie/configurable.rb:30:in method_missing' /var/redmine/config/environment.rb:14:in<top (required)>'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:inrequire'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in block in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:236:inload_dependency'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/application.rb:103:inrequire_environment!'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/application.rb:305:in block (2 levels) in initialize_tasks' /var/redmine/lib/tasks/redmine.rake:52:inblock (2 levels) in <top (required)>'
Tasks: TOP => redmine:plugins:migrate => environment
(See full trace by running task with --trace)
root@redmine:/var/redmine# rake db:migrate
rake aborted!
Redmine::PluginNotFound: Redmine::PluginNotFound
/var/redmine/lib/redmine/plugin.rb:118:in find' /var/redmine/lib/redmine/plugin.rb:246:inrequires_redmine_plugin'
/var/redmine/plugins/redmine_multiprojects_issue/init.rb:19:in block in <top (required)>' /var/redmine/lib/redmine/plugin.rb:75:ininstance_eval'
/var/redmine/lib/redmine/plugin.rb:75:in register' /var/redmine/plugins/redmine_multiprojects_issue/init.rb:11:in<top (required)>'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:inrequire'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in block in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:236:inload_dependency'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in require' /var/redmine/lib/redmine/plugin.rb:150:inblock in load'
/var/redmine/lib/redmine/plugin.rb:141:in each' /var/redmine/lib/redmine/plugin.rb:141:inload'
/var/redmine/config/initializers/30-redmine.rb:19:in <top (required)>' /var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:245:inload'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:245:in block in load' /var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:236:inload_dependency'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:245:in load' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/engine.rb:593:inblock (2 levels) in class:Engine'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/engine.rb:592:in each' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/engine.rb:592:inblock in class:Engine'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:30:in instance_exec' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:30:inrun'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:55:in block in run_initializers' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:54:ineach'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/initializable.rb:54:in run_initializers' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/application.rb:136:ininitialize!'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/railtie/configurable.rb:30:in method_missing' /var/redmine/config/environment.rb:14:in<top (required)>'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:inrequire'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in block in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:236:inload_dependency'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/activesupport-3.2.19/lib/active_support/dependencies.rb:251:in require' /var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/application.rb:103:inrequire_environment!'
/var/redmine/vendor/bundle/ruby/2.1.0/gems/railties-3.2.19/lib/rails/application.rb:305:in `block (2 levels) in initialize_tasks'
Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)

Change Values of Related Projects by using Custom Workflows Plugin

Hi there,

I'm wondering if there is a way of auto checking the check boxes in (Related projects (Edit project list)) based on a if statement of another custom field in the issue?

I've tried to do that by using the Custom Workflow plugin. But I couldn't get it to work. The following was my attempt by using the Custom Workflow Plugin:

Before Saving:
self.project_ids => ["5"]

This throws an error. Is there a way I can use the Custom Workflow plugin to change the values in the Related Project List?

additionals plugin compatibility redmine 5.0.4

Is it possible to run both additionals plugin and redmine_multiprojects_issue? On previous redmine 4.x I was using both by changing deface plugin dependency to additionals plaugin, since it already provides deface.

On redmine 5.0.4 same edit result in

=> Booting WEBrick
=> Rails 6.1.7 application starting in production http://0.0.0.0:3000
=> Run `bin/rails server --help` for more startup options
Exiting
/home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/helpers.rb:135:in `const_get': uninitialized constant Issues::Form (NameError)
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/helpers.rb:135:in `cget'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/eager_load.rb:169:in `block in actual_eager_load_dir'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/helpers.rb:40:in `block in ls'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/helpers.rb:25:in `each'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/helpers.rb:25:in `ls'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/eager_load.rb:164:in `actual_eager_load_dir'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/eager_load.rb:17:in `block (2 levels) in eager_load'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/eager_load.rb:16:in `each'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/eager_load.rb:16:in `block in eager_load'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/eager_load.rb:10:in `synchronize'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader/eager_load.rb:10:in `eager_load'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader.rb:297:in `block in eager_load_all'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader.rb:295:in `each'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/zeitwerk-2.6.7/lib/zeitwerk/loader.rb:295:in `eager_load_all'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/railties-6.1.7/lib/rails/application/finisher.rb:133:in `block in <module:Finisher>'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/railties-6.1.7/lib/rails/initializable.rb:32:in `instance_exec'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/railties-6.1.7/lib/rails/initializable.rb:32:in `run'
        from /home/tomin/devel/redmine-test/redmine-5.0.4/bundler/ruby/3.0.0/gems/railties-6.1.7/lib/rails/initializable.rb:61:in `block in run_initializers'

Have only these plugins installed

additionals
redmine_base_stimulusjs
redmine_multiprojects_issue

Allow setting multiple target-milestones

There is an open issue to 6 years old already and that seems a requirement for several people..

http://www.redmine.org/issues/1266

I'm not a ruby programmer, but i could try to help with this feature. . it would be very usefull for me.

👍

Per Project Activation ?

Would it be possible to activate this plugin as a module ?
Or another solution would be to restrict the field to some trackers.

entally closed it, sorry

it seems not compability with advanced roadmap v2 and Calendar in Redmine3.2.X

it seems not compability with advanced roadmap v2 with . redmine Calendar. Any solution?
Thanks so much..

the error log is

Completed 500 Internal Server Error in 316ms (Views: 219.9ms | ActiveRecord: 27.3ms)

ActiveRecord::ConfigurationError (#<Issue id: 2, tracker_id: 1, project_id: 1, subject: "Demo Bug 100", description: "<h2 style="font-style:italic;">前置条件\r\n\r\n<div s...", due_date: nil, category_id: nil, status_id: 1, assigned_to_id: nil, priority_id: 2, fixed_version_id: nil, author_id: 1, lock_version: 1, created_on: "2016-04-08 05:27:59", updated_on: "2016-04-08 05:27:59", start_date: "2016-04-08", done_ratio: 10, estimated_hours: nil, parent_id: nil, root_id: 2, lft: 1, rgt: 2, is_private: false, closed_on: nil, answers_on_secondary_projects: true>):
plugins/advanced_roadmap_v2/lib/advanced_roadmap/calendars_controller_patch.rb:19:in add_milestones' lib/redmine/sudo_mode.rb:63:insudo_mode'

Calendar 500 error with redmine 3.4.3

Started GET "/projects/abq" for 10.1.10.22 at 2018-02-07 11:31:39 +0800
Processing by ProjectsController#show as HTML
  Parameters: {"id"=>"abq"}
  Current user: lgh (id=20)
  Rendered projects/_members_box.html.erb (22.0ms)
  Rendered news/_news.html.erb (7.1ms)
  Rendered plugins/advanced_roadmap/app/views/hooks/_milestones.html.erb (2.0ms)
  Rendered projects/show.html.erb within layouts/base (49.8ms)
  Rendered plugins/a_common_libs/app/views/hooks/a_common_libs/_html_head.html.erb (2.1ms)
  Rendered plugins/advanced_roadmap/app/views/hooks/_stylesheet.html.erb (0.3ms)
  Rendered plugins/redmine__select2/app/views/redmine__select2/_includes.html.erb (0.8ms)
  Rendered plugins/redmine_favourite_projects/app/views/favourite_projects/_favourite_projects_searchbox_partial.html.erb (0.2ms)
  Rendered plugins/redmine_banner/app/views/banner/_project_body_bottom.html.erb (2.3ms)
  Rendered plugins/sidebar_hide/app/views/sidebar/_hideButton_partial.html.erb (0.2ms)
Completed 200 OK in 440ms (Views: 99.9ms | ActiveRecord: 135.8ms)
Started GET "/issue_badge" for 10.1.10.22 at 2018-02-07 11:31:39 +0800
Processing by IssueBadgeController#index as */*
  Current user: lgh (id=20)
  Rendered plugins/redmine_issue_badge/app/views/issue_badge/_issue_badge.html.erb (0.5ms)
Completed 200 OK in 43ms (Views: 1.3ms | ActiveRecord: 8.4ms)
Started GET "/projects/abq/issues/gantt" for 10.1.10.22 at 2018-02-07 11:31:43 +0800
Processing by GanttsController#show as HTML
  Parameters: {"project_id"=>"abq"}
  Current user: lgh (id=20)
  Rendered queries/_filters.html.erb (25.9ms)
  Rendered plugins/advanced_roadmap/app/views/hooks/_milestones.html.erb (2.0ms)
  Rendered plugins/redmine_issue_templates/app/views/issue_templates/_issue_template_link.html.erb (1.3ms)
  Rendered issues/_sidebar.html.erb (10.4ms)
  Rendered gantts/show.html.erb within layouts/base (227.4ms)
  Rendered plugins/a_common_libs/app/views/hooks/a_common_libs/_html_head.html.erb (1.9ms)
  Rendered plugins/advanced_roadmap/app/views/hooks/_stylesheet.html.erb (0.4ms)
  Rendered plugins/redmine__select2/app/views/redmine__select2/_includes.html.erb (0.8ms)
  Rendered plugins/redmine_favourite_projects/app/views/favourite_projects/_favourite_projects_searchbox_partial.html.erb (0.2ms)
  Rendered plugins/redmine_banner/app/views/banner/_project_body_bottom.html.erb (2.3ms)
  Rendered plugins/sidebar_hide/app/views/sidebar/_hideButton_partial.html.erb (0.2ms)
Completed 200 OK in 418ms (Views: 249.8ms | ActiveRecord: 137.7ms)
Started GET "/issue_badge" for 10.1.10.22 at 2018-02-07 11:31:43 +0800
Processing by IssueBadgeController#index as */*
  Current user: lgh (id=20)
  Rendered plugins/redmine_issue_badge/app/views/issue_badge/_issue_badge.html.erb (1.0ms)
Completed 200 OK in 59ms (Views: 2.8ms | ActiveRecord: 9.6ms)
Started GET "/projects/kdcs/issues/calendar" for 10.1.10.22 at 2018-02-07 11:31:58 +0800
Processing by CalendarsController#show as HTML
  Parameters: {"project_id"=>"kdcs"}
  Current user: lgh (id=20)
  Rendered queries/_filters.html.erb (30.3ms)
  Rendered common/_calendar.html.erb (27.8ms)
  Rendered plugins/advanced_roadmap/app/views/hooks/_milestones.html.erb (3.4ms)
  Rendered plugins/redmine_issue_templates/app/views/issue_templates/_issue_template_link.html.erb (0.2ms)
  Rendered issues/_sidebar.html.erb (11.0ms)
  Rendered calendars/show.html.erb within layouts/base (74.9ms)
  Rendered plugins/a_common_libs/app/views/hooks/a_common_libs/_html_head.html.erb (1.9ms)
  Rendered plugins/advanced_roadmap/app/views/hooks/_stylesheet.html.erb (0.3ms)
  Rendered plugins/redmine__select2/app/views/redmine__select2/_includes.html.erb (0.8ms)
  Rendered plugins/redmine_favourite_projects/app/views/favourite_projects/_favourite_projects_searchbox_partial.html.erb (0.2ms)
  Rendered plugins/redmine_banner/app/views/banner/_project_body_bottom.html.erb (2.1ms)
  Rendered plugins/sidebar_hide/app/views/sidebar/_hideButton_partial.html.erb (0.2ms)
Completed 500 Internal Server Error in 317ms (Views: 119.7ms | ActiveRecord: 124.5ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'issues.id' in 'IN/ALL/ANY subquery': SELECT `milestones`.`id` AS t0_r0, `milestones`.`name` AS t0_r1, `milestones`.`description` AS t0_r2, `milestones`.`milestone_effective_date` AS t0_r3, `milestones`.`user_id` AS t0_r4, `milestones`.`project_id` AS t0_r5, `milestones`.`created_on` AS t0_r6, `milestones`.`updated_on` AS t0_r7, `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, `projects`.`dmsf_description` AS t1_r13, `projects`.`dmsf_notification` AS t1_r14, `projects`.`default_assignee_id` AS t1_r15, `projects`.`text_formatting` AS t1_r16, `projects`.`modules_for_formatting` AS t1_r17, `projects`.`default_version_id` AS t1_r18, `projects`.`default_assigned_to_id` AS t1_r19, `projects`.`dmsf_act_as_attachable` AS t1_r20 FROM `milestones` INNER JOIN `projects` ON `projects`.`id` = `milestones`.`project_id` WHERE ((((projects.id = 90) OR issues.id IN (SELECT issue_id FROM issues_projects WHERE project_id = 90)))) AND (`milestones`.`milestone_effective_date` BETWEEN '2018-01-28' AND '2018-03-03')):
  plugins/advanced_roadmap/lib/advanced_roadmap/calendars_controller_patch.rb:27:in `add_milestones'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'


Environment:
  Redmine version                3.4.3.stable
  Ruby version                   2.3.5-p376 (2017-09-14) [x86_64-linux]
  Rails version                  4.2.8
  Environment                    production
  Database adapter               Mysql2
SCM:
  Subversion                     1.9.7
  Git                            1.7.1
  Filesystem                     
Redmine plugins:
  a_common_libs                  2.4.0
  advanced_roadmap               0.11.0
  gantt_extension                0.2
  projects_tree_view             0.0.9
  redmine__select2               1.1.0
  redmine_banner                 0.1.2
  redmine_base_deface            0.0.1
  redmine_base_stimulusjs        0.9.0
  redmine_category_tree          0.0.7
  redmine_checklists             3.1.10
  redmine_ckeditor               1.1.5
  redmine_dmsf                   1.6.0
  redmine_favourite_projects     0.9.1
  redmine_image_clipboard_paste  3.3.0
  redmine_issue_badge            0.0.6
  redmine_issue_templates        0.1.8
  redmine_lightbox2              0.4.3
  redmine_my_page                0.1.13
  redmine_per_project_formatting 0.0.4
  redmine_pivot_table            0.0.5
  redmine_questions              0.0.7
  redmine_work_time              0.3.4
  redmine_xlsx_format_issue_exporter 0.1.5
  sidebar_hide                   0.0.8

PluginNotFound

bash-4.1# rake redmine:plugins:migrate RAILS_ENV=production
(in /opt/redmine-2.6.2-0/apps/redmine/htdocs)
rake aborted!
Redmine::PluginNotFound: Redmine::PluginNotFound
/opt/redmine-2.6.2-0/apps/redmine/htdocs/lib/redmine/plugin.rb:118:in find' /opt/redmine-2.6.2-0/apps/redmine/htdocs/lib/redmine/plugin.rb:246:inrequires_redmine_plugin'
/opt/redmine-2.6.2-0/apps/redmine/htdocs/plugins/redmine_multiprojects_issue/init.rb:18:in block in <top (required)>' /opt/redmine-2.6.2-0/apps/redmine/htdocs/lib/redmine/plugin.rb:75:ininstance_eval'
/opt/redmine-2.6.2-0/apps/redmine/htdocs/lib/redmine/plugin.rb:75:in register' /opt/redmine-2.6.2-0/apps/redmine/htdocs/plugins/redmine_multiprojects_issue/init.rb:11:in<top (required)>'
/opt/redmine-2.6.2-0/apps/redmine/htdocs/lib/redmine/plugin.rb:150:in block in load' /opt/redmine-2.6.2-0/apps/redmine/htdocs/lib/redmine/plugin.rb:141:ineach'
/opt/redmine-2.6.2-0/apps/redmine/htdocs/lib/redmine/plugin.rb:141:in load' /opt/redmine-2.6.2-0/apps/redmine/htdocs/config/initializers/30-redmine.rb:19:in<top (required)>'
/opt/redmine-2.6.2-0/apps/redmine/htdocs/config/environment.rb:14:in `<top (required)>'
Tasks: TOP => redmine:plugins:migrate => environment
(See full trace by running task with --trace)

Unable to open issue page and an activity page

After installing the plugin and dependences, everything works, except I'm unable to open certain issues and activity page. Error log:

�[1;32mDeface:�[0m 'disable_project_link_if_current_user_cannot_open_it' matched 0 times with 'table.list.issues tbody tr'
�[1;32mDeface: [ERROR]�[0m The original source for 'show-projects-in-issue-description' has changed, this override should be reviewed to ensure it's still valid.
�[1;32mDeface: [ERROR]�[0m The original source for 'add-multiple-projects-to-issue-form' has changed, this override should be reviewed to ensure it's still valid.

ActionView::Template::Error (super: no superclass method `show_detail' for #<#Class:0x000056321d88d088:0x0000563222202a60>
Did you mean? show_value):
19:
20: <% if journal.details.any? %>
21:

<%= string %>

plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/issues_helper_patch.rb:53:in show_detail' plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/issues_helper_patch.rb:53:in show_detail'
app/helpers/issues_helper.rb:494:in block in details_to_strings' app/helpers/issues_helper.rb:480:in each'
app/helpers/issues_helper.rb:480:in details_to_strings' app/views/issues/tabs/_history.html.erb:22:in block in _8c956b192a709ba8e84f95f289716173'
app/views/issues/tabs/_history.html.erb:7:in each' app/views/issues/tabs/_history.html.erb:7:in _8c956b192a709ba8e84f95f289716173'
plugins/that_thread/app/views/issues/tabs/_history.html.erb:5:in _d27ba65f6584cbefb88dae0cdae0cc4a' app/views/common/_tabs.html.erb:21:in block in _edbe8cba465e1fb61be17275f584bf56'
app/views/common/_tabs.html.erb:20:in each' app/views/common/_tabs.html.erb:20:in _edbe8cba465e1fb61be17275f584bf56'
app/helpers/application_helper.rb:481:in render_tabs' app/views/issues/show.html.erb:144:in _5a981755fabd88113545d3a216f106b5'
app/controllers/issues_controller.rb:112:in block (2 levels) in show' app/controllers/issues_controller.rb:104:in show'
lib/redmine/sudo_mode.rb:61:in `sudo_mode'

Compatibility with Redmine 3.4.2.stable

rake aborted!
Redmine::PluginNotFound: Redmine::PluginNotFound
/var/www/html/redmine/lib/redmine/plugin.rb:123:in find' /var/www/html/redmine/lib/redmine/plugin.rb:251:in requires_redmine_plugin'
/var/www/html/redmine/plugins/redmine_multiprojects_issue/init.rb:20:in block in <top (required)>' /var/www/html/redmine/lib/redmine/plugin.rb:75:in instance_eval'
/var/www/html/redmine/lib/redmine/plugin.rb:75:in register' /var/www/html/redmine/plugins/redmine_multiprojects_issue/init.rb:13:in <top (required)>'
/usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in require' /usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in block in require'
/usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:240:in load_dependency' /usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in require'
/var/www/html/redmine/lib/redmine/plugin.rb:155:in block in load' /var/www/html/redmine/lib/redmine/plugin.rb:146:in each'
/var/www/html/redmine/lib/redmine/plugin.rb:146:in load' /var/www/html/redmine/config/initializers/30-redmine.rb:21:in <top (required)>'
/usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:268:in load' /usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:268:in block in load'
/usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:240:in load_dependency' /usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:268:in load'
/usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/engine.rb:652:in block in load_config_initializer' /usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/notifications.rb:166:in instrument'
/usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/engine.rb:651:in load_config_initializer' /usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/engine.rb:616:in block (2 levels) in class:Engine'
/usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/engine.rb:615:in each' /usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/engine.rb:615:in block in class:Engine'
/usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/initializable.rb:30:in instance_exec' /usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/initializable.rb:30:in run'
/usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/initializable.rb:55:in block in run_initializers' /usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/initializable.rb:44:in each'
/usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/initializable.rb:44:in tsort_each_child' /usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/initializable.rb:54:in run_initializers'
/usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/application.rb:352:in initialize!' /var/www/html/redmine/config/environment.rb:14:in <top (required)>'
/usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in require' /usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in block in require'
/usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:240:in load_dependency' /usr/local/rvm/gems/ruby-2.4.1/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in require'
/usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/application.rb:328:in require_environment!' /usr/local/rvm/gems/ruby-2.4.1/gems/railties-4.2.8/lib/rails/application.rb:457:in block in run_tasks_blocks'
/usr/local/rvm/gems/ruby-2.4.1@global/gems/rake-12.0.0/exe/rake:27:in `<top (required)>'

Are there any plans to update the themes to Redmine 3.4.2.stable ?

Thanks a lot for your work.

Is possible limit who can edit the Project List?

Would it be possible to limit by Rol or Workflow who can edit the Project List ?

Unable to open issue page and an activiti page

ActionView::Template::Error (super: no superclass method show_detail' for #<#<Class:0x000056271a9ed210>:0x00007f855270efc0> Did you mean? show_value): 19: 20: <% if journal.details.any? %> 21: <ul class="details"> 22: <% details_to_strings(journal.visible_details).each do |string| %> 23: <li><%= string %></li> 24: <% end %> 25: </ul>

Restriction to trackers

Some trackers are project-related (for example we have trackers to follow risks and I don't think it's relevant to have the multiproject field).

Issues with plugin redmine_crm

When we install your plugin in addition to redmine_crm ( https://www.redminecrm.com/projects/crm/pages/1 ) we get the following error:

Log:

ActionView::Template::Error (undefined method each' for #<RedmineCrm::Tag id: 35, name: "diomex">): 13: <% project_tree(@projects) do |project, level| %> 14: <tr class="<%= cycle("odd", "even") %> <%= project.css_classes %> <%= level > 0 ? "idnt idnt-#{level}" : nil %>"> 15: <td><%= favorite_tag(project, User.current) %></td> 16: <% @query.columns.each do |column| %><%= content_tag 'td', column_content(column, project), :class => column.css_classes %><% end %> 17: </tr> 18: <% end %> 19: </tbody> plugins/redmine_favorite_projects/lib/redmine_favorite_projects/patches/queries_helper_patch.rb:40:incolumn_value_with_favorite_projects'
plugins/redmine_products/lib/redmine_products/patches/queries_helper_patch.rb:58:in column_value_with_products' plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/queries_helper_patch.rb:12:inblock in column_content_with_multiprojects_issues'
plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/queries_helper_patch.rb:12:in collect' plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/queries_helper_patch.rb:12:incolumn_content_with_multiprojects_issues'
plugins/redmine_favorite_projects/app/views/projects/_list.html.erb:16:in block (2 levels) in _1a4882b24976a664b866948292a0087c' plugins/redmine_favorite_projects/app/views/projects/_list.html.erb:16:ineach'
plugins/redmine_favorite_projects/app/views/projects/_list.html.erb:16:in block in _1a4882b24976a664b866948292a0087c' app/models/project.rb:796:inblock in project_tree'
app/models/project.rb:792:in each' app/models/project.rb:792:inproject_tree'
app/helpers/application_helper.rb:384:in project_tree' plugins/redmine_favorite_projects/app/views/projects/_list.html.erb:13:in_1a4882b24976a664b866948292a0087c'
plugins/redmine_favorite_projects/app/views/projects/index.html.erb:88:in _93388134edba0921a63dd91ad883e79d' plugins/redmine_favorite_projects/app/controllers/favorite_projects_controller.rb:44:inblock (2 levels) in search'
plugins/redmine_favorite_projects/app/controllers/favorite_projects_controller.rb:39:in search' lib/redmine/sudo_mode.rb:63:insudo_mode'

Information about our redmine:

Environment:
Redmine version 3.3.0.stable.15582
Ruby version 2.3.1-p112 (2016-04-26) [x86_64-linux-gnu]
Rails version 4.2.6
Environment production
Database adapter Mysql2
SCM:
Subversion 1.9.3
Git 2.7.4
Filesystem
Redmine plugins:
clipboard_image_paste 1.10
issue_hot_buttons 0.4.4
progressive_projects_list 3.0.1
redmine_auto_percent 0.0.1
redmine_banner 0.1.2
redmine_base_deface 0.0.1
redmine_changeauthor 1.0.1
redmine_checklists 3.1.5
redmine_contacts 4.0.4
redmine_contacts_helpdesk 3.0.4
redmine_favorite_projects 2.0.2
redmine_improved_searchbox 0.0.3
redmine_issue_templates 0.1.3
redmine_lightbox2 0.3.1
redmine_local_avatars 1.0.0
redmine_multiprojects_issue 3.3.0
redmine_my_page_queries 2.1.6
redmine_products 2.0.1
redmine_questions 0.0.7
redmine_recenthistory 0.0.2
redmine_silencer 0.4.1-burg
redmine_wiki_extensions 0.7.0
sidebar_hide 0.0.7
wiking 1.0.0b

Search, Linking, and Issue List not working

After our recent update from Redmine 4.0.9 to Redmine 4.2.2 I am seeing a weird issue with the latest version of this plugin (master-branch cloned in August and again today). I can use the plugin just fine and assign additional projects to issues perfectly fine. Users, that are members of one of the projects selected can then open the issue directly via URL, however:

The issue does not show up if they search for its ticket number
The issue does not show up in the secondary project's issue overview
The issue is not highlighted as clickable in-text link anymore

The logs don't show anything unusual or any errors, and I cannot really put my finger on it.

Plugin configuration

Once installed, I checked the plugin configuration. The plugin asks for a custom field to quickly select projects.

What kind of custom field is needed there?
I tried a text field or an integer field for object type issues, but did not succeed to select multiple projects for one issure (new or already existing).

Could you give some explanation on the plugin configuration?

Thanks!

Impacted projects not shown on Issue

Hi,

I have installed this plugin as well as redmine_base_deface. No errors.

The list of Issues show (after adding it to see) the column Impacted projects. But on an Issue, I do not see this text, so one can not add one or multiple projects to an Issue.

In the plugin overview it is listed as version 0.2 When I use the Configure button, an empty listbox is shown; I have the feeling I must add projects which can be selected, but the list is empty.

Any ideas?

Thanks,

Clemens

The Redmine environment:

Redmine version 2.6.6.stable
Ruby version 2.0.0-p645 (2015-04-13) [i386-mingw32]
Rails version 3.2.22
Environment production
Database adapter Mysql2
SCM:
Subversion 1.7.19
Mercurial 3.3.3
Git 1.9.5
Filesystem
Redmine plugins:
redmine_base_deface 0.0.1
redmine_multiprojects_issue 0.2
redmine_re 1.5.0
redmine_release_notes 1.3.1
redmine_wiki_unc 0.0.3

share custom poles between projects

Hello,

this is probably not a bug but i have a problem with your plugin.

I have 2 different projects. Project A and Project B.

Project A has custom pole: "Custom Pole 1" and Project B has custom pole "Custom Pole 2".
Plugin actually works, that the issue inherit all custom poles from project where issue was created (Issue created in Project A has Custom Pole 1. Issue is related to Project B, but dont has the Custom Pole 2). It is possible to get all the custom poles from all projects where is issue related?

I have no idea how ruby works, so can you implement this feature?

Thank you.

Issues with plugin a_common_libs

My config

Debian 9.13
mariadb 10.1.48-0+deb9u2

Environment:
  Redmine version                3.4.11.stable
  Ruby version                   2.4.4-p296 (2018-03-28) [x86_64-linux]
  Rails version                  4.2.11.1
  Environment                    production
  Database adapter               Mysql2
SCM:
  Git                            2.11.0
  Filesystem                     
Redmine plugins:
  a_common_libs                  2.5.3
  clipboard_image_paste          1.13
  custom_menu                    1.8.6
  easy_gantt                     1.10
  progressive_projects_list      4.0.0
  projects_show                  0.0.3
  redmine_activity_report        1.2.10
  redmine_banner                 0.1.2
  redmine_base_deface            1.5.3
  redmine_base_stimulusjs        1.1.1
  redmine_changeauthor           1.0.1
  redmine_checklists             3.1.19
  redmine_email_images           0.1.1
  redmine_issue_dynamic_edit     0.7.2
  redmine_issue_evm              4.0
  redmine_issue_tabs             1.3.2
  redmine_login_audit            0.3.3
  redmine_logs                   0.2.0
  redmine_move_comments          0.0.2
  redmine_multiprojects_issue    3.4.5
  redmine_people                 1.6.1
  redmine_per_project_formatting 0.0.5
  redmine_pivot_table            0.0.7
  redmine_pretend                2.0.1
  redmine_reminder               0.3.0
  redmine_send_mails             0.3.23xBeta
  redmine_spent_time_required    0.0.1
  redmine_summed_fields          1.0.1
  redmine_update_reminder        1.1
  redmine_work_time              0.3.4
  redmine_workload               1.1.0
  sidebar_hide                   0.0.8
  subtask_columns                0.0.3
  that_email_log                 0.0.4
  timelog_timer                  2.0.0
  unread_issues                  2.2.3

I have a conflict between plugins a_common_libs and redmine_multiprojects when I try to open project like http://redmine.my.domain/projects/deps

Started GET "/projects" for 10.90.20.2 at 2021-10-07 23:57:53 +0300
Processing by ProjectsController#index as HTML
  Current user: admin (id=1)
  Rendered projects/index.html.erb within layouts/base (2557.9ms)
  Rendered inline template (0.4ms)
  Rendered plugins/redmine_pretend/app/views/user/_unpretend.html.erb (0.1ms)
  Rendered plugins/a_common_libs/app/views/hooks/a_common_libs/_html_head.html.erb (1.7ms)
  Rendered plugins/clipboard_image_paste/app/views/clipboard_image_paste/_headers.html.erb (0.4ms)
  Rendered plugins/custom_menu/app/views/hooks/custom_menu/_html_head.html.erb (0.7ms)
  Rendered plugins/progressive_projects_list/app/views/projects/_progressive_sidebar.html.erb (1.6ms)
  Rendered plugins/progressive_projects_list/app/views/application/_progressive_recent_projects.html.erb (0.1ms)
  Rendered plugins/redmine_banner/app/views/banner/_project_body_bottom.html.erb (0.1ms)
  Rendered plugins/sidebar_hide/app/views/sidebar/_hideButton_partial.html.erb (0.1ms)
  Rendered plugins/clipboard_image_paste/app/views/clipboard_image_paste/_add_form.html.erb (2.3ms)
  Rendered plugins/custom_menu/app/views/hooks/custom_menu/_view_layouts_base_body_bottom.erb (0.1ms)
  Rendered plugins/redmine_people/app/views/common/_people_select2_data.html.erb (0.2ms)
  Rendered plugins/redmine_people/app/views/common/_layout_bottom.html.erb (0.5ms)
Completed 200 OK in 2626ms (Views: 2402.9ms | ActiveRecord: 205.0ms)
Started GET "/projects/deps" for 10.90.20.2 at 2021-10-07 23:57:58 +0300
Processing by ProjectsController#show as HTML
  Parameters: {"id"=>"deps"}
  Current user: admin (id=1)
Completed 500 Internal Server Error in 68ms (ActiveRecord: 7.1ms)

SystemStackError (stack level too deep):
  plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/issue_patch.rb:22:in `visible_condition'
  plugins/a_common_libs/lib/acl/patches/models/issue_patch.rb:171:in `visible_condition_with_acl'
  plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/issue_patch.rb:32:in `visible_condition'
  plugins/a_common_libs/lib/acl/patches/models/issue_patch.rb:171:in `visible_condition_with_acl'
  plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/issue_patch.rb:32:in `visible_condition'
  plugins/a_common_libs/lib/acl/patches/models/issue_patch.rb:171:in `visible_condition_with_acl'
  plugins/redmine_multiprojects_issue/lib/redmine_multiprojects_issue/issue_patch.rb:32:in `visible_condition'

An internal error is displayed in the browser when I want to look at Project -> Issues

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.

Install plugin:

~/redmine]$ bundle exec rake redmine:plugins  RAILS_ENV=production                         == 1 CreateIssuesProjects: migrating ==========================================
-- create_table(:issues_projects, {:id=>false})
   -> 0.0034s
== 1 CreateIssuesProjects: migrated (0.0036s) =================================

== 2 AddUniqueIndex: migrating ================================================
-- add_index(:issues_projects, [:issue_id, :project_id], {:unique=>true})
   -> 0.0056s
== 2 AddUniqueIndex: migrated (0.0057s) =======================================

== 3 AddAllowAnswersOnSecondaryProjectsToIssues: migrating ====================
-- add_column(:issues, :answers_on_secondary_projects, :boolean, {:default=>true, :null=>false})
   -> 0.0026s
== 3 AddAllowAnswersOnSecondaryProjectsToIssues: migrated (0.0028s) ===========

Environment:

Environment:
  Redmine version                4.1.0.stable
  Ruby version                   2.6.3-p62 (2019-04-16) [x86_64-linux]
  Rails version                  5.2.4.1
  Environment                    production
  Database adapter               PostgreSQL
  Mailer queue                   ActiveJob::QueueAdapters::AsyncAdapter
  Mailer delivery                smtp
SCM:
  Subversion                     1.7.14
  Mercurial                      5.2.2
  Bazaar                         2.5.1
  Git                            2.9.3
  Filesystem                     
  Xitolite                       2.9.3
Redmine plugins:
  additionals                    2.0.23
  progressive_projects_list      4.0.0
  redmine_git_hosting            4.0.1
  redmine_issue_badge            0.1.3
  redmine_tags                   4.0.0

Incompatibility with Easy WBS

When im trying to update a issue on Easy WBS preview, this shows a error message saying i'm not able to leave Related prjects empty. But when i click on "Edit projects list", the main project is already checked.

issue not show on Related project's parent project

Hi,

I have project A, A's subproject AA, and project B.
And I have issue bi01 on prject B.
After related issue bi01 to project AA, I can see this issue on project AA's issue list.
But when I checked the project A's issue list, it disappeared.

Any ideas?
Thanks!

The Redmine environment:
Redmine version 3.3.0
redmine_multiprojects_issue: master

Not working with Redmine 5.0.1

Hello,
sadly this plugin is not yet working with the latest version of Redmine. I tried to adjust some stuff to the Rails 6 and zeitgeist but as I’m not a pro in Ruby its not full working and I can’t open the list of projects to add more projects to the ticket. The trouble seems to be with authorization.
Will add my changes as pull request and I would be very happy if someone could support me with the final fixes. Thank you!

nanego / redmine_multiprojects_issue Goto Github PK

redmine_multiprojects_issue's Introduction

Redmine Multiprojects Issue plugin

Screenshots

Installation

Test status

Contributing

redmine_multiprojects_issue's People

Contributors

Stargazers

Watchers

Forkers

redmine_multiprojects_issue's Issues

Recommend Projects

Recommend Topics

Recommend Org