Bug 22391

Summary: Incorrect GROUP BY in /acqui/ajax-getauthvaluedropbox.pl
Product: Koha Reporter: Nick Clemens (kidclamp) <nick>
Component: Architecture, internals, and plumbingAssignee: Bugs List <koha-bugs>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: martin.renvoize, tomascohen
Version: Main   
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:
Attachments: Bug 22391: Remove group by clause in ajax-getauthvaluedropbox.pl
Bug 22391: Remove group by clause in ajax-getauthvaluedropbox.pl

Description Nick Clemens (kidclamp) 2019-02-21 16:47:18 UTC
Also see bug 21593
Comment 1 Nick Clemens (kidclamp) 2019-02-21 16:49:42 UTC
Created attachment 85465 [details] [review]
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
Comment 2 Tomás Cohen Arazi (tcohen) 2019-02-22 16:55:30 UTC
Created attachment 85568 [details] [review]
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>
Comment 3 Nick Clemens (kidclamp) 2019-02-22 17:39:12 UTC
Awesome work all!

Pushed to master for 19.05
Comment 4 Martin Renvoize (ashimema) 2019-02-26 09:17:47 UTC
Pushed to 18.11.x for 18.11.04