Bug 21598

Summary: budget_parent_id isn't in GROUP BY - GetBudgetHierarchy
Product: Koha Reporter: Jonathan Druart <jonathan.druart>
Component: Architecture, internals, and plumbingAssignee: Jonathan Druart <jonathan.druart>
Status: CLOSED FIXED QA Contact: Martin Renvoize (ashimema) <martin.renvoize>
Severity: major    
Priority: P5 - low CC: fridolin.somers, martin.renvoize, nick
Version: unspecified   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on:    
Bug Blocks: 21597    
Attachments: Bug 21598: 'koha_kohadev.aqbudgets.budget_parent_id' isn't in GROUP BY
Bug 21598: 'koha_kohadev.aqbudgets.budget_parent_id' isn't in GROUP BY

Description Jonathan Druart 2018-10-18 11:35:24 UTC
http://pro.kohadev.org/cgi-bin/koha/admin/aqbudgets.pl

    '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.
Comment 1 Jonathan Druart 2018-10-18 12:03:00 UTC
Created attachment 80811 [details] [review]
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
Comment 2 Martin Renvoize (ashimema) 2018-10-18 13:17:24 UTC
Created attachment 80836 [details] [review]
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 <martin.renvoize@ptfs-europe.com>
Comment 3 Martin Renvoize (ashimema) 2018-10-18 13:18:03 UTC
Trivial fix.. Passing QA
Comment 4 Nick Clemens (kidclamp) 2018-10-18 14:32:40 UTC
Pushed to master for 18.11
Comment 5 Martin Renvoize (ashimema) 2018-10-26 13:29:34 UTC
Pushed to 18.05.x for 18.05.06
Comment 6 Fridolin Somers 2018-11-09 15:19:23 UTC
21599
Comment 7 Fridolin Somers 2018-11-28 15:35:59 UTC
SQL modes not in 17.11.x