From 6813a49eae5c108d1bb258f6bc31d0e7f62d4b38 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 6 Feb 2018 15:43:09 -0300 Subject: [PATCH] Bug 20144: [sql_modes] Fix GROUP BY clause in Virtualshelves search (DT) Fix for: 'koha_kohadev.vs.shelfname' isn't in GROUP BY t/db_dependent/Utils/Datatables_Virtualshelves.t Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice --- C4/Utils/DataTables/VirtualShelves.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/C4/Utils/DataTables/VirtualShelves.pm b/C4/Utils/DataTables/VirtualShelves.pm index 156b68cb23..5a349326b1 100644 --- a/C4/Utils/DataTables/VirtualShelves.pm +++ b/C4/Utils/DataTables/VirtualShelves.pm @@ -95,7 +95,8 @@ sub search { $limit = "LIMIT $dt_params->{iDisplayStart},$dt_params->{iDisplayLength}"; } - my $group_by = " GROUP BY vs.shelfnumber"; + my $group_by = " GROUP BY vs.shelfnumber, vs.shelfname, vs.owner, vs.category, + vs.created_on, vs.lastmodified, bo.surname, bo.firstname, vs.sortfield "; my $query = join( " ", -- 2.14.2