From 286b453d3a41ed186ac44ac339319f934e2fb0eb Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 17 Oct 2018 19:31:14 -0300 Subject: [PATCH] Bug 21598: 'koha_kohadev.aqbudgets.budget_parent_id' isn't in GROUP BY DBD::mysql::db selectall_hashref failed: 'koha_kohadev.aqbudgets.budget_parent_id' isn't in GROUP BY [for Statement " at /home/vagrant/kohaclone/C4/Budgets.pm line 558. and at /home/vagrant/kohaclone/C4/Budgets.pm line 565. Test plan: hit /cgi-bin/koha/admin/aqbudgets.pl Signed-off-by: Martin Renvoize Signed-off-by: Nick Clemens (cherry picked from commit 60e00a332e2a500746f12908042dd61250d1f79a) Signed-off-by: Martin Renvoize --- C4/Budgets.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/Budgets.pm b/C4/Budgets.pm index 0b82055a01..d66cc0e43f 100644 --- a/C4/Budgets.pm +++ b/C4/Budgets.pm @@ -549,14 +549,14 @@ sub GetBudgetHierarchy { SUM( COALESCE(unitprice_tax_included, ecost_tax_included) * quantity ) AS budget_spent FROM aqorders JOIN aqbudgets USING (budget_id) WHERE quantityreceived > 0 AND datecancellationprinted IS NULL - GROUP BY budget_id + GROUP BY budget_id, budget_parent_id |, 'budget_id'); my $hr_budget_ordered = $dbh->selectall_hashref(q| SELECT aqorders.budget_id, aqbudgets.budget_parent_id, SUM(ecost_tax_included * quantity) AS budget_ordered FROM aqorders JOIN aqbudgets USING (budget_id) WHERE quantityreceived = 0 AND datecancellationprinted IS NULL - GROUP BY budget_id + GROUP BY budget_id, budget_parent_id |, 'budget_id'); my $hr_budget_spent_shipment = $dbh->selectall_hashref(q| SELECT shipmentcost_budgetid as budget_id, -- 2.39.5