Satish, Yes 16.11.09 was a buggy version, but what you describe is not a known bug. I'd say that old_issues.returndate is set to null and so the history page consider it as "currently checked out", but it is not. In this case the patron should have only 3 items at home and the other items are actually available. Could you check: SELECT COUNT(*) FROM old_issues WHERE returndate IS NULL ? On Thu, 21 Sep 2017 at 02:39 SATISH <lis4satish@gmail.com> wrote:
Hi Jonathan,
1) The SQL query, SELECT COUNT(*) FROM issues WHERE borrowernumber=516 results = 3
2) At the OPAC (when patron login), it shows counts = 3
3) At the Koha Administrator, Patron, Check-out page = 3
4) At the Koha Administrator, Patron, Circulation history = 9 (this is the actual number of books borrowed by the patron)
5) At the OPAC search (without login) for a particular barcode which is not shown in patron's OPAC but picked from Patron's Circulation history for which status shown as "Check-out", is displayed as: "AVAILABLE" in OPAC.
I guess, the problem started after migration from 16.05 to 16.11.09. before that, during previous semesters Koha behaved excellently, did 22,000 transactions during last one year. The problem reported with Check-In. when performed check-in, the barcode/books details was not removing from the patron's account. after that Check-out counts. Now, all the OPAC's terminal's are kept shutdown, until it is fixed.
And only satisfaction is, it is showing correct check-out counts in patron's page and opac login for the recent Check-outs. After update from 16.5 to 16.11.09, during last week of July, whatever books issued for those accounts I am facing problem.
Not sure, how to proceed further to fix the issue and appreciate your feedback.
-Satish