[Koha-bugs] [Bug 22082] Ambiguous column in patron stats
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Sun Jan 13 22:34:36 CET 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22082
Katrin Fischer <katrin.fischer at bsz-bw.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #83733|0 |1
is obsolete| |
--- Comment #3 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Created attachment 83856
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=83856&action=edit
Bug 22082: ambiguous column in patron stats
In Reports > Patrons statistics, the combination of activity and extended
attributes generates an invalid SQL query with error :
ERROR 1052 (23000): Column 'borrowernumber' in IN/ALL/ANY subquery is ambiguous
This is because FROM contains tables borrowers and borrower_attributes both
containing borrowernumber column.
Test plan :
1) Be sure to have a patron extended attribute
2) Be sure you have some recent circulation activity
3) Go to Reports > Patrons statistics
4) Select 'active' in 'Patron activity' and 1 years of activity
5) Check 'Row' in 'Patron category'
6) Check 'Columns' in a extended attribute
7) Submit
8) Without patch you have no results, with patch you have exepected results
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