From 383008ac39cf82cf11a6a72786652e0ca9d4d463 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 19 Oct 2018 12:06:43 -0300 Subject: [PATCH] Bug 21621: Remove incorrect GROUP BY from tools/letter.pl Fix: 'koha_kohadev.letter.name' isn't in GROUP BY DBD::mysql::db selectall_arrayref failed: 'koha_kohadev.letter.name' isn't in GROUP BY [for Statement "SELECT branchcode, module, code, name, branchname FROM letter LEFT OUTER JOIN branches USING (branchcode) GROUP BY branchcode,module,code ORDER BY module, code, branchcode"] at /home/vagrant/kohaclone/tools/letter.pl line 383. Test plan: - Copy some default notice templates for specific libraries - List the different notice templates - Confirm that notices appear only one, with "all libraries" you will see all Signed-off-by: Pierre-Marc Thibault https://bugs.koha-community.org/show_bug.cgi?id=21607 --- tools/letter.pl | 1 - 1 file changed, 1 deletion(-) diff --git a/tools/letter.pl b/tools/letter.pl index d1c95bc..caaeb0e 100755 --- a/tools/letter.pl +++ b/tools/letter.pl @@ -377,7 +377,6 @@ sub retrieve_letters { } $sql .= " WHERE ".join(" AND ", @where) if @where; - $sql .= " GROUP BY branchcode,module,code"; $sql .= " ORDER BY module, code, branchcode"; return $dbh->selectall_arrayref($sql, { Slice => {} }, @args); -- 2.7.4