From edefd14f23c8f49cd2d735aa527ecdbe8cfc3222 Mon Sep 17 00:00:00 2001
From: Julian Maurice <julian.maurice@biblibre.com>
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 <matthias.le-gac@inlibro.com>
Signed-off-by: Phan Tung Bui <phan-tung.bui@inlibro.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
---
 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