From edefd14f23c8f49cd2d735aa527ecdbe8cfc3222 Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Tue, 18 Apr 2023 16:28:34 +0200 Subject: [PATCH] Bug 29393: Prevent SQL errors when SQL strict mode is set Signed-off-by: Matthias Le Gac Signed-off-by: Phan Tung Bui Signed-off-by: Martin Renvoize Signed-off-by: Katrin Fischer --- Koha/Template/Plugin/NoticeTemplates.pm | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/Koha/Template/Plugin/NoticeTemplates.pm b/Koha/Template/Plugin/NoticeTemplates.pm index e49ea4c08e..894e3080fc 100644 --- a/Koha/Template/Plugin/NoticeTemplates.pm +++ b/Koha/Template/Plugin/NoticeTemplates.pm @@ -29,7 +29,11 @@ sub GetByModule { return Koha::Notice::Templates->search( { module => $module }, - { group_by => 'code', order_by => ['name'] } + { + group_by => [ 'code', 'name' ], + columns => [ 'code', 'name' ], + order_by => ['name'] + } ); } -- 2.39.5