[Koha-bugs] [Bug 13452] Average checkout report always uses biblioitems.itemtype
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Aug 19 15:55:40 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13452
Julian Maurice <julian.maurice at biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|Failed QA |Signed Off
--- Comment #11 from Julian Maurice <julian.maurice at biblibre.com> ---
(In reply to Jonathan Druart from comment #10)
> On reports/issues_avg_stats.pl, select row=patron category and column=item
> type
>
> DBD::mysql::st execute failed: You have an error in your SQL syntax
I tried just now and saw no errors.
Generated SQL:
SELECT borrowers.categorycode, items.itype, issuedate, returndate, COUNT(*)
FROM `old_issues`,borrowers,biblioitems
LEFT JOIN items ON (biblioitems.biblioitemnumber=items.biblioitemnumber)
WHERE old_issues.itemnumber=items.itemnumber
AND old_issues.borrowernumber=borrowers.borrowernumber
group by borrowers.categorycode, items.itype, issuedate, returndate
order by borrowers.categorycode, items.itype
I tried to change the value of item-level_itypes syspref, but it works as well.
Could you give it another try ?
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list