Bug 22391: Remove group by clause in ajax-getauthvaluedropbox.pl
authorNick Clemens <nick@bywatersolutions.com>
Thu, 21 Feb 2019 16:48:22 +0000 (16:48 +0000)
committerNick Clemens <nick@bywatersolutions.com>
Thu, 21 Feb 2019 16:48:28 +0000 (16:48 +0000)
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: Nick Clemens <nick@bywatersolutions.com>

acqui/ajax-getauthvaluedropbox.pl

index f5852d4..d82d4a5 100755 (executable)
@@ -75,7 +75,6 @@ my $avs = Koha::AuthorisedValues->search(
         category => $category,
     },
     {
-        group_by => 'lib',
         order_by => [ 'category', 'lib', 'lib_opac' ],
     }
 );