Bug 21718

Summary: Lists of pending/received orders for a fund explodes with strict modes active
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: AcquisitionsAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: major    
Priority: P5 - low CC: jonathan.druart
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on:    
Bug Blocks: 17258    

Description Katrin Fischer 2018-10-29 21:27:46 UTC
http://localhost:8081/cgi-bin/koha/acqui/ordered.pl?fund=2&fund_code=Fund%201_2

To Test:
- Make sure you have some pending orders
- Go to the acquisition start page
- Click on the ordered amount in the budget and funds table

Explosion:

Error occurred fetching records: 'koha_kohadev.aqorders.biblionumber' isn't in GROUP BY at /home/vagrant/kohaclone/acqui/ordered.pl line 84
Comment 1 Katrin Fischer 2018-10-29 21:29:02 UTC
Same is true for the spend value as well.
Comment 2 Jonathan Druart 2018-10-29 21:34:58 UTC

*** This bug has been marked as a duplicate of bug 21622 ***