[Koha-bugs] [Bug 21622] Incorrect GROUP BY clause in acqui/ scripts
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Oct 29 23:09:14 CET 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21622
Katrin Fischer <katrin.fischer at bsz-bw.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #80943|0 |1
is obsolete| |
--- Comment #3 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Created attachment 81596
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81596&action=edit
Bug 21622: Remove incorrect GROUP BY clauses in acqui script
acqui/ordered.pl: GROUP BY aqorders.ordernumber
acqui/spent.pl: GROUP BY aqorders.ordernumbe
'koha_kohadev.aqorders.biblionumber' isn't in GROUP BY
Test plan:
- Create orders for different basket and using different funds
- Receive some of them
- Hit the ordered and spent pages (from the acqui home page)
=> The tables must contain the same data with and without this patch
Signed-off-by: Katrin Fischer <katrin.fischer.83 at web.de>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list