From 7e220e0d8f107cce63f32bfaa1919c04b4dea6e2 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 6 Feb 2018 11:04:50 -0300 Subject: [PATCH] Bug 20179: [sql_modes] Remove GROUP BY in get_shelves_containing_record Replaced with distinct. Fix for: 'koha_kohadev.me.shelfname' isn't in GROUP BY t/db_dependent/Virtualshelves.t Signed-off-by: Roch D'Amour Signed-off-by: Julian Maurice Signed-off-by: Jonathan Druart --- Koha/Virtualshelves.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Koha/Virtualshelves.pm b/Koha/Virtualshelves.pm index 195376ce35..bb7db67789 100644 --- a/Koha/Virtualshelves.pm +++ b/Koha/Virtualshelves.pm @@ -154,7 +154,7 @@ sub get_shelves_containing_record { }, { join => [ 'virtualshelfcontents', 'virtualshelfshares' ], - group_by => 'shelfnumber', + distinct => 'shelfnumber', order_by => { -asc => 'shelfname' }, } ); -- 2.39.5