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
|