Project

General

Profile

Defect #1620 » 1620.log

Attila Ferencz-Csibi, 2023-06-29 15:33

 
1
Started GET "/projects/scrum/issues?c%5B%5D=project&c%5B%5D=tracker&c%5B%5D=status&c%5B%5D=subject&c%5B%5D=assigned_to&c%5B%5D=author&c%5B%5D=updated_on&c%5B%5D=sprint&f%5B%5D=status_id&f%5B%5D=&group_by=&op%5Bstatus_id%5D=o&set_filter=1&sort=sprint%2Cid%3Adesc&t%5B%5D=&utf8=%E2%9C%93" for 84.206.29.113 at 2023-06-28 16:48:35 +0200
2
Processing by IssuesController#index as HTML
3
Parameters: {"c"=>["project", "tracker", "status", "subject", "assigned_to", "author", "updated_on", "sprint"], "f"=>["status_id", ""], "group_by"=>"", "op"=>{"status_id"=>"o"}, "set_filter"=>"1", "sort"=>"sprint,id:desc", "t"=>[""], "utf8"=>"✓", "project_id"=>"scrum"}
4
Current user: testuser (id=5)
5
Query::StatementInvalid: Mysql2::Error: Unknown column 'sprints.sprint_end_date' in 'order clause': 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 FROM `issues` INNER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_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.is_public = TRUE AND projects.id NOT IN (SELECT project_id FROM members WHERE user_id IN (5,3))) AND ((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)))) OR (projects.id IN (1,3,4) AND (((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (10,59,8,11,87,86,14,15,9,6,16,12,13,7,90,64,126,65,127,66,128,129,67,68,69,70)))) OR (projects.id IN (2,15,32,36,37,38,39,40,41,42,49,58,59,63,65,69,75,93,100) AND ((1=1 AND issues.tracker_id IN (79,60,92,73,72,71,33,78,80,82,83,84,89,88,94,77,34,136,85,93,76,90,91,81,50,22,31,51,55,23,20,27,28,32,21,18,29,24,54,26,25,19,53,46,47,48,52,49,145)))) OR (projects.id IN (2,15,32,36,37,39,40,41,42,49,58,59,63,65,69,73,75,93,96,100) AND (((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (79,60,92,134,73,72,132,131,130,71,33,78,80,82,83,84,89,88,94,77,34,136,85,93,76,90,91,81,50,22,31,51,55,23,20,27,28,32,21,18,29,24,54,26,25,19,53,46,47,48,52,49,145)))) OR (projects.id IN (5,6,7,8,9,10,11,12,17,18,19,20,21,22,23,24,25,26,27,28,33,34,35,44,48,64,66,72,76,79,80,98,99,104) AND (((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (10,59,8,11,87,86,14,15,9,6,16,12,13,7,92,90,31,54)))) OR (projects.id IN (15,36,49,58,59,69,75,93,100) AND (((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (79,60,92,73,72,71,33,78,80,82,83,84,89,88,94,77,34,85,93,76,90,91,81,50,22,31,51,55,23,20,27,28,32,21,18,29,24,54,26,25,19,53,46,47,48,52,49,145)))) OR (projects.id IN (15,36,59,63) AND ((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)))) OR (projects.id IN (36,49,58,59,65,75) AND ((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)))) OR (projects.id IN (36,49,58,59,65,75) AND ((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)))) OR (projects.id IN (38) AND ((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)))) OR (projects.id IN (49) AND ((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)))) OR (projects.id IN (70,71,78) AND (((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (64,126,65,127,66,128,129,67,68,69,70,146)))) OR (projects.id IN (77,81) AND (((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (116,117,135)))) OR (projects.id IN (77,81) AND (((issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (135)))) OR (projects.id IN (81) AND (((issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (116)))) OR (projects.id IN (106) AND (((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (147,148,149,150)))) OR (projects.id IN (106) AND (((issues.is_private = FALSE OR issues.author_id = 5 OR issues.assigned_to_id IN (5,98,419,420,424,426,1107,1114,1496,1868,1869)) AND issues.tracker_id IN (147,148,149,150)))))))) AND ((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=FALSE)) AND projects.id = 106) 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
6
Rendering common/error.html.erb within layouts/base
7
Rendered common/error.html.erb within layouts/base (0.1ms)
8
Rendered plugins/redmine_wiki_extensions/app/views/wiki_extensions/_html_header.html.erb (0.9ms)
9
Rendered plugins/redmineup_tags/app/views/tags/_additional_assets.html.erb (0.3ms)
10
Rendered plugins/scrum/app/views/scrum_hooks/_head.html.erb (0.1ms)
11
Rendered plugins/a_common_libs/app/views/hooks/a_common_libs/_html_head.html.erb (1.2ms)
12
Rendered plugins/unread_issues/app/views/hooks/unread_isues/_add_css.html.erb (0.1ms)
13
Rendered plugins/a_common_libs/app/views/hooks/a_common_libs/_view_layouts_base_body_top.html.erb (0.1ms)
14
Rendered plugins/scrum/app/views/scrum_hooks/_scrum_tips.html.erb (2.6ms)
15
Rendered plugins/redmine_drawio/app/views/redmine_drawio/_macro_dialog.html.erb (0.2ms)
16
Rendered plugins/redmine_wiki_extensions/app/views/wiki_extensions/_body_bottom.html.erb (0.0ms)
17
Rendered plugins/redmineup_tags/app/views/tags/_select2_transformation_rules.html.erb (0.1ms)
18
Rendered plugins/redmine_people/app/views/people_announcements/_call_announcements.html.erb (0.0ms)
19
Rendered plugins/redmine_people/app/views/common/_people_select2_data.html.erb (0.0ms)
20
Rendered plugins/redmine_people/app/views/common/_layout_bottom.html.erb (0.3ms)
21
Completed 500 Internal Server Error in 215ms (Views: 33.4ms | ActiveRecord: 85.9ms)
(3-3/3)