Plugins compatible with redmine_agile

[mornzhou]

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. AnonymousUser Load (0.6ms) SELECT "users". FROM "users" WHERE "users"."type" IN ('AnonymousUser') AND "users"."lastname" = $1 LIMIT $2 [["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)  (0.5ms) SELECT version FROM schema_migrations  (0.2ms) SELECT pg_try_advisory_lock(5339476299225889275)  (0.5ms) SELECT version FROM schema_migrations Migrating to CreateIssuesProjects (1)  (0.1ms) BEGIN  (1.9ms) CREATE TABLE "issues_projects" ("issue_id" integer, "project_id" integer) ActiveRecord::SchemaMigration Create (0.3ms)["version", "1-redmine_multiprojects_issue"] VALUES ($1) RETURNING "version" [["version", "1-redmine_multiprojects_issue"]]  (0.6ms) COMMIT["version", "2-redmine_multiprojects_issue"] BEGIN  (1.0ms) CREATE UNIQUE INDEX "index_issues_projects_on_issue_id_and_project_id" ON "issues_projects" ("issue_id", "project_id") ActiveRecord::SchemaMigration Create (0.2ms)["version", "2-redmine_multiprojects_issue"] VALUES ($1) RETURNING "version" [["version", "2-redmine_multiprojects_issue"]]  (0.3ms) COMMIT Migrating to AddAllowAnswersOnSecondaryProjectsToIssues (3)  (0.1ms) BEGIN  (11.9ms) ALTER TABLE "issues" ADD "answers_on_secondary_projects" boolean DEFAULT TRUE NOT NULL ActiveRecord::SchemaMigration Create (0.3ms)["version", "3-redmine_multiprojects_issue"] VALUES ($1) RETURNING "version" [["version", "3-redmine_multiprojects_issue"]]  (1.5ms) COMMIT ActiveRecord::InternalMetadata Load (0.3ms) SELECT "ar_internal_metadata". FROM "ar_internal_metadata" WHERE "ar_internal_metadata"."key" = $1 LIMIT $2 [["key", "environment"], ["LIMIT", 1]]  (0.1ms) BEGIN  (0.1ms) COMMIT  (0.2ms) SELECT pg_advisory_unlock(5339476299225889275)  (1.6ms) SELECT "schema_migrations"."version" FROM "schema_migrations" ORDER BY "schema_migrations"."version" ASC 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. AnonymousUser Load (1.4ms) SELECT "users". FROM "users" WHERE "users"."type" IN ('AnonymousUser') AND "users"."lastname" = $1 LIMIT $2 [["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"} Setting Load (0.5ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "session_lifetime"], ["LIMIT", 1]] Setting Load (0.3ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "session_timeout"], ["LIMIT", 1]] Token Update All (1.2ms) UPDATE "tokens" SET "updated_on" = '2021-01-04 16:59:07.400726' WHERE "tokens"."user_id" = $1 AND "tokens"."value" = $2 AND "tokens"."action" = $3 [["user_id", 1], ["value", "dedda96b54a3400336edb29ad78c542253832ad3"], ["action", "session"]]  (0.6ms) SELECT MAX("settings"."updated_on") FROM "settings" User Load (1.5ms) SELECT "users". FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser', 'Person') AND "users"."status" = $1 AND "users"."id" = $2 LIMIT $3 [["status", 1], ["id", 1], ["LIMIT", 1]] Current user: admin (id=1) Setting Load (0.4ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "force_default_language_for_loggedin"], ["LIMIT", 1]] Setting Load (0.3ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "default_language"], ["LIMIT", 1]] Project Load (0.4ms) SELECT "projects". FROM "projects" WHERE "projects"."identifier" = $1 LIMIT $2 [["identifier", "test_project"], ["LIMIT", 1]]  (0.5ms) SELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1 [["project_id", 2]] UserPreference Load (0.5ms) SELECT "user_preferences". FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT $2 [["user_id", 1], ["LIMIT", 1]] Setting Load (0.3ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "start_of_week"], ["LIMIT", 1]] Tracker Load (4.6ms) SELECT 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 [["name", "issue_tracking"]] IssuePriority Load (0.5ms) SELECT "enumerations". FROM "enumerations" WHERE "enumerations"."type" IN ('IssuePriority') ORDER BY "enumerations"."position" ASC IssueCustomField Load (1.2ms) SELECT "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 [["is_filter", true]] ["is_filter", true] SELECT "custom_fields". FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1 [["is_filter", true]] Sprint Exists (0.8ms) SELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] Sprint Load (0.7ms) SELECT "sprints". FROM "sprints" WHERE "sprints"."project_id" = $1 ORDER BY sprint_start_date ASC, name ASC [["project_id", 2]] CACHE CustomField Load (0.0ms) SELECT "custom_fields". FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1 [["is_filter", true]] IssueCustomField Load (0.8ms) SELECT "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 Setting Load (0.4ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "user_format"], ["LIMIT", 1]]  (0.4ms) SELECT "users"."id" FROM "users" WHERE "users"."type" IN ('GroupNonMember')  (1.0ms) SELECT "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)) Setting Load (0.3ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "issue_list_default_columns"], ["LIMIT", 1]] SQL (15.2ms) SELECT "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 SQL (1.4ms) SELECT "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') Rendering calendars/show.html.erb within layouts/base Tracker Load (1.6ms) SELECT 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 [["name", "issue_tracking"]]  (1.1ms) SELECT DISTINCT "workflows"."old_status_id", "workflows"."new_status_id" FROM "workflows" WHERE "workflows"."type" IN ('WorkflowTransition') AND "workflows"."tracker_id" IN ($1, $2, $3) [["tracker_id", 1], ["tracker_id", 2], ["tracker_id", 3]] IssueStatus Load (0.5ms) SELECT "issue_statuses". FROM "issue_statuses" WHERE "issue_statuses"."id" IN ($1, $2, $3, $4, $5, $6) ORDER BY "issue_statuses"."position" ASC [["id", 4], ["id", 3], ["id", 5], ["id", 2], ["id", 6], ["id", 1]] Rendered queries/_filters.html.erb (15.3ms) Setting Load (0.3ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "non_working_week_days"], ["LIMIT", 1]] Group Load (0.8ms) SELECT "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 [["user_id", 1]] Setting Load (0.3ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "date_format"], ["LIMIT", 1]] Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["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) Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "plugin_redmineup_tags"], ["LIMIT", 1]] Rendered plugins/redmineup_tags/app/views/issues/_tags_sidebar.html.erb (1.7ms) IssueQuery Load (1.4ms) SELECT "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 [["project_id", 2]] Rendered issues/_sidebar.html.erb (20.1ms) Rendered calendars/show.html.erb within layouts/base (78.1ms) Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["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) Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "plugin_view_customize"], ["LIMIT", 1]] Token Load (0.5ms) SELECT "tokens". FROM "tokens" WHERE "tokens"."user_id" = $1 AND (action='api') LIMIT $2 [["user_id", 1], ["LIMIT", 1]] CustomField Load (0.5ms) SELECT "custom_fields". FROM "custom_fields" WHERE (type = 'UserCustomField') ORDER BY "custom_fields"."position" ASC Member Load (0.5ms) SELECT "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 [["user_id", 1], ["status", 9], ["project_id", 2], ["LIMIT", 1]] Role Load (0.5ms) SELECT "roles". FROM "roles" WHERE "roles"."builtin" = $1 LIMIT $2 [["builtin", 1], ["LIMIT", 1]] Member Load (0.8ms) SELECT "members". FROM "members" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE "members"."project_id" = $1 AND "users"."type" IN ($2, $3) [["project_id", 2], ["type", "GroupAnonymous"], ["type", "GroupNonMember"]] CustomField Load (0.5ms) SELECT "custom_fields". FROM "custom_fields" WHERE (type = 'ProjectCustomField') ORDER BY "custom_fields"."position" ASC ViewCustomize Load (0.6ms) SELECT "view_customizes". FROM "view_customizes" ORDER BY "view_customizes"."id" ASC 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) Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "gravatar_enabled"], ["LIMIT", 1]] Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "plugin_redmine_work_time"], ["LIMIT", 1]] Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "plugin_redmine_contacts"], ["LIMIT", 1]] Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "plugin_redmine_products"], ["LIMIT", 1]] Project Load (0.6ms) SELECT "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 [["user_id", 1], ["status", 9], ["status", 1]] Project Load (0.4ms) SELECT "projects". FROM "projects" WHERE 1=0 AND (projects.status <> 9) Project Load (0.4ms) SELECT "projects". FROM "projects" WHERE "projects"."id" IN ($1, $2) [["id", 2], ["id", 3]] Tracker Exists (0.6ms) SELECT 1 AS one FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "new_item_menu_tab"], ["LIMIT", 1]] CACHE Tracker Exists (0.0ms) SELECT 1 AS one FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] Announcement Load (1.0ms) SELECT "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 [["project_id", 2]] Version Exists (1.3ms) SELECT 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 [["LIMIT", 1]] Wiki Load (0.5ms) SELECT "wikis". FROM "wikis" WHERE "wikis"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] Board Exists (0.4ms) SELECT 1 AS one FROM "boards" WHERE "boards"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] Repository Load (0.4ms) SELECT "repositories". FROM "repositories" WHERE "repositories"."project_id" = $1 AND "repositories"."is_default" = $2 LIMIT $3 [["project_id", 2], ["is_default", true], ["LIMIT", 1]] Setting Load (0.2ms) SELECT "settings". FROM "settings" WHERE "settings"."name" = $1 ORDER BY "settings"."id" DESC LIMIT $2 [["name", "plugin_scrum"], ["LIMIT", 1]] EnabledModule Load (0.3ms) SELECT "enabled_modules". FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1 [["project_id", 2]] Role Load (0.3ms) SELECT "roles". FROM "roles" Sprint Exists (0.4ms) SELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 AND "sprints"."is_product_backlog" = $2 LIMIT $3 [["project_id", 2], ["is_product_backlog", true], ["LIMIT", 1]] Sprint Exists (0.4ms) SELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 AND "sprints"."is_product_backlog" = $2 LIMIT $3 [["project_id", 2], ["is_product_backlog", false], ["LIMIT", 1]] Rendered plugins/scrum/app/views/scrum_hooks/_scrum_tips.html.erb (16.6ms) Project Load (0.5ms) SELECT "projects". FROM "projects" WHERE (projects.lft <= 1 AND projects.rgt >= 2) ORDER BY "projects"."lft" ASC["project_id", 2], ["LIMIT", 1] SELECT 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 [["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) CACHE ViewCustomize Load (0.0ms) SELECT "view_customizes". FROM "view_customizes" ORDER BY "view_customizes"."id" ASC 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) SQL (0.8ms) 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 [["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:inadd_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"} Token Update All (1.0ms) UPDATE "tokens" SET "updated_on" = '2021-01-04 16:59:11.232391' WHERE "tokens"."user_id" = $1 AND "tokens"."value" = $2 AND "tokens"."action" = $3 [["user_id", 1], ["value", "dedda96b54a3400336edb29ad78c542253832ad3"], ["action", "session"]]  (0.5ms) SELECT MAX("settings"."updated_on") FROM "settings" User Load (0.6ms) SELECT "users". FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser', 'Person') AND "users"."status" = $1 AND "users"."id" = $2 LIMIT $3 [["status", 1], ["id", 1], ["LIMIT", 1]] Current user: admin (id=1) Project Load (0.4ms) SELECT "projects". FROM "projects" WHERE "projects"."identifier" = $1 LIMIT $2 [["identifier", "test_project"], ["LIMIT", 1]]  (0.3ms) SELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1 [["project_id", 2]] UserPreference Load (0.3ms) SELECT "user_preferences". FROM "user_preferences" WHERE "user_preferences"."user_id" = $1 LIMIT $2 [["user_id", 1], ["LIMIT", 1]] Tracker Load (3.0ms) SELECT 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 [["name", "issue_tracking"]] IssuePriority Load (0.5ms) SELECT "enumerations". FROM "enumerations" WHERE "enumerations"."type" IN ('IssuePriority') ORDER BY "enumerations"."position" ASC IssueCustomField Load (0.8ms) SELECT "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 [["is_filter", true]] ["is_filter", true] SELECT "custom_fields". FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1 [["is_filter", true]] Sprint Exists (0.4ms) SELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] Sprint Load (0.5ms) SELECT "sprints". FROM "sprints" WHERE "sprints"."project_id" = $1 ORDER BY sprint_start_date ASC, name ASC [["project_id", 2]] CACHE CustomField Load (0.0ms) SELECT "custom_fields". FROM "custom_fields" WHERE "custom_fields"."is_filter" = $1 [["is_filter", true]] IssueCustomField Load (0.7ms) SELECT "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  (0.4ms) SELECT "users"."id" FROM "users" WHERE "users"."type" IN ('GroupNonMember')  (1.1ms) SELECT "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)) SQL (15.3ms) SELECT "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 SQL (0.8ms) SELECT "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') Rendering calendars/show.html.erb within layouts/base Tracker Load (1.3ms) SELECT 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 [["name", "issue_tracking"]]  (0.6ms) SELECT DISTINCT "workflows"."old_status_id", "workflows"."new_status_id" FROM "workflows" WHERE "workflows"."type" IN ('WorkflowTransition') AND "workflows"."tracker_id" IN ($1, $2, $3) [["tracker_id", 1], ["tracker_id", 2], ["tracker_id", 3]] IssueStatus Load (0.4ms) SELECT "issue_statuses". FROM "issue_statuses" WHERE "issue_statuses"."id" IN ($1, $2, $3, $4, $5, $6) ORDER BY "issue_statuses"."position" ASC [["id", 4], ["id", 3], ["id", 5], ["id", 2], ["id", 6], ["id", 1]] Rendered queries/_filters.html.erb (10.2ms) Group Load (0.7ms) SELECT "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 [["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) IssueQuery Load (1.1ms) SELECT "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 [["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) Token Load (0.5ms) SELECT "tokens". FROM "tokens" WHERE "tokens"."user_id" = $1 AND (action='api') LIMIT $2 [["user_id", 1], ["LIMIT", 1]] CustomField Load (0.5ms) SELECT "custom_fields". FROM "custom_fields" WHERE (type = 'UserCustomField') ORDER BY "custom_fields"."position" ASC Member Load (0.5ms) SELECT "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 [["user_id", 1], ["status", 9], ["project_id", 2], ["LIMIT", 1]] Role Load (0.3ms) SELECT "roles". FROM "roles" WHERE "roles"."builtin" = $1 LIMIT $2 [["builtin", 1], ["LIMIT", 1]] Member Load (0.8ms) SELECT "members". FROM "members" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE "members"."project_id" = $1 AND "users"."type" IN ($2, $3) [["project_id", 2], ["type", "GroupAnonymous"], ["type", "GroupNonMember"]] CustomField Load (0.5ms) SELECT "custom_fields". FROM "custom_fields" WHERE (type = 'ProjectCustomField') ORDER BY "custom_fields"."position" ASC ViewCustomize Load (0.4ms) SELECT "view_customizes". FROM "view_customizes" ORDER BY "view_customizes"."id" ASC 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) Project Load (0.6ms) SELECT "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 [["user_id", 1], ["status", 9], ["status", 1]] Project Load (0.4ms) SELECT "projects". FROM "projects" WHERE 1=0 AND (projects.status <> 9) Project Load (0.4ms) SELECT "projects". FROM "projects" WHERE "projects"."id" IN ($1, $2) [["id", 2], ["id", 3]] Tracker Exists (0.6ms) SELECT 1 AS one FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] CACHE Tracker Exists (0.0ms) SELECT 1 AS one FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] Announcement Load (0.8ms) SELECT "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 [["project_id", 2]] Version Exists (1.0ms) SELECT 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 [["LIMIT", 1]] Wiki Load (0.4ms) SELECT "wikis". FROM "wikis" WHERE "wikis"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] Board Exists (0.4ms) SELECT 1 AS one FROM "boards" WHERE "boards"."project_id" = $1 LIMIT $2 [["project_id", 2], ["LIMIT", 1]] Repository Load (0.3ms) SELECT "repositories". FROM "repositories" WHERE "repositories"."project_id" = $1 AND "repositories"."is_default" = $2 LIMIT $3 [["project_id", 2], ["is_default", true], ["LIMIT", 1]] EnabledModule Load (0.3ms) SELECT "enabled_modules". FROM "enabled_modules" WHERE "enabled_modules"."project_id" = $1 [["project_id", 2]] Role Load (0.4ms) SELECT "roles". FROM "roles" Sprint Exists (0.5ms) SELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 AND "sprints"."is_product_backlog" = $2 LIMIT $3 [["project_id", 2], ["is_product_backlog", true], ["LIMIT", 1]] Sprint Exists (0.4ms) SELECT 1 AS one FROM "sprints" WHERE "sprints"."project_id" = $1 AND "sprints"."is_product_backlog" = $2 LIMIT $3 [["project_id", 2], ["is_product_backlog", false], ["LIMIT", 1]] Rendered plugins/scrum/app/views/scrum_hooks/_scrum_tips.html.erb (6.8ms) Project Load (0.5ms) SELECT "projects". FROM "projects" WHERE (projects.lft <= 1 AND projects.rgt >= 2) ORDER BY "projects"."lft" ASC["project_id", 2], ["LIMIT", 1] SELECT 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 [["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) CACHE ViewCustomize Load (0.0ms) SELECT "view_customizes". FROM "view_customizes" ORDER BY "view_customizes"."id" ASC 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) SQL (0.8ms) 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 [["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)

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:inadd_sprints' lib/redmine/sudo_mode.rb:65:in `sudo_mode'