[Koha] Check-out Counts difference

[Jonathan Druart]

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 at 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
>
>