https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13452
Julian Maurice <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Signed Off --- Comment #11 from Julian Maurice <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
