From eb231d8f186e7acfcc7f8c959e85651dbe6c14de Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 5 Feb 2018 18:13:06 -0300 Subject: [PATCH] Bug 20177: [sql_modes] Remove GROUP BY clause in GetCourses Fix for: 'koha_kohadev.courses.department' isn't in GROUP BY t/db_dependent/CourseReserves.t no need to group by here Signed-off-by: Josef Moravec --- C4/CourseReserves.pm | 2 -- 1 file changed, 2 deletions(-) diff --git a/C4/CourseReserves.pm b/C4/CourseReserves.pm index 3a3f422a96..91141a1543 100644 --- a/C4/CourseReserves.pm +++ b/C4/CourseReserves.pm @@ -180,8 +180,6 @@ sub GetCourses { $query .= join( ' AND ', @query_keys ); } - $query .= " GROUP BY courses.course_id "; - my $dbh = C4::Context->dbh; my $sth = $dbh->prepare($query); $sth->execute(@query_values); -- 2.14.2