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 <[email protected]> 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 > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
