Project

General

Profile

Defect #1577

Internal error sorting task by sprints

Added by Maxim Danilin 20 days ago. Updated 19 days ago.

Status:
New
Priority:
Normal
Category:
General
Source:
Customer
Detected on version:
Blocked:
No
Alone:
No
Milestones:
Sprint:

Description

If you open the task list and click on the "Sprint" sort, we get error 500.

Database error on log:

Query::StatementInvalid: PG::UndefinedTable: ERROR: missing FROM-clause entry for table "sprints" 
LINE 1: ...= 1 AND projects.rgt <= 236) ORDER BY (CASE WHEN sprints.sp...
^
: 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, "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, "issue_reads"."id" AS t3_r0, "issue_reads"."user_id" AS t3_r1, "issue_reads"."issue_id" AS t3_r2, "issue_reads"."read_date" AS t3_r3, "issue_reads"."created_at" AS t3_r4, "issue_reads"."updated_at" AS t3_r5 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 "issue_reads" ON "issue_reads"."issue_id" = "issues"."id" AND (issue_reads.user_id = 526) 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='f')) AND (issues.fixed_version_id IN ('304','300')) AND (issues.sprint_id IN ('6')) AND projects.lft >= 1 AND projects.rgt <= 236) ORDER BY (CASE WHEN sprints.sprint_end_date IS NULL THEN 1 ELSE 0 END) ASC, sprints.sprint_end_date ASC, sprints.name ASC, sprints.id ASC, issues.id DESC LIMIT 25 OFFSET 0

Files

rm_sprint_error.jpg (470 KB) rm_sprint_error.jpg Maxim Danilin, 2020-05-08 04:19
#1

Updated by Emilio González Montaña 19 days ago

  • Description updated (diff)
#2

Updated by Emilio González Montaña 19 days ago

Have you migrate redmine plugins first? missing table error is pointing to that... PG::UndefinedTable: ERROR: missing FROM-clause entry for table "sprints"

Take a look to wiki: RAILS_ENV=production bundle exec rake redmine:plugins:migrate

Also available in: Atom PDF