From c9db9c2abb88bea15838e495aca617c366088729 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 --- 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 e49ea4c08e2..894e3080fc8 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.43.0