From fa0c1737b9918c2cad85bfc1da136b4901c07f20 Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Thu, 21 Feb 2019 16:48:22 +0000
Subject: [PATCH] Bug 22391: Remove group by clause in
 ajax-getauthvaluedropbox.pl

To test:
1 - Enable strict sql modes
2 - Tail the error log
3 - Add an item to a basket - note that when fund selected you get an error
4 - Apply patch
5 - Repeat, no error

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
---
 acqui/ajax-getauthvaluedropbox.pl | 1 -
 1 file changed, 1 deletion(-)

diff --git a/acqui/ajax-getauthvaluedropbox.pl b/acqui/ajax-getauthvaluedropbox.pl
index f5852d4bd7..d82d4a59c1 100755
--- a/acqui/ajax-getauthvaluedropbox.pl
+++ b/acqui/ajax-getauthvaluedropbox.pl
@@ -75,7 +75,6 @@ my $avs = Koha::AuthorisedValues->search(
         category => $category,
     },
     {
-        group_by => 'lib',
         order_by => [ 'category', 'lib', 'lib_opac' ],
     }
 );
-- 
2.20.1