[Koha] Check-out Counts difference

[Jonathan Druart]

Satish,

Yes, that was the solution.
I cannot explain how it has been possible, but the returndate field should
not be set to null for checkins.
You must upgrade to the latest 16.11.x version, 16.11.09 may have caused
this problem.

Cheers,
Jonathan

On Fri, 22 Sep 2017 at 09:08 SATISH <lis4satish at gmail.com> wrote:

> In the test server, I observed, there seems to be Check-In issue as well
> for these 16 titles, when I perform, Check-In, it won't be removed from the
> display as well as Check-out counts.
>
> since, I am unable to find any solutions and
>
> From the patron's perspective, I wanted their OPAC to be displayed
> accurate information,I am planning for generating titles, for whom there is
> mis-match between checkout counts and circulation history.
>
> And I am expanding your SQL
> SELECT COUNT(*) FROM old_issues WHERE returndate IS NULL to
> -----------
> SELECT
> items.barcode,biblio.title,biblio.author,borrowers.firstname,borrowers.surname,
> borrowers.cardnumber,borrowers.categorycode FROM old_issues
> LEFT JOIN borrowers ON borrowers.borrowernumber=old_issues.borrowernumber
> LEFT JOIN items ON old_issues.itemnumber=items.itemnumber
> LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber
> WHERE returndate IS NULL
> -----------
> It shows 16 problematic titles with other patron and biblio details.
> later, setting up these 16 problematic title's Circulation history date
> forcefully to some date ( today's date) in mysql. so that, both OPAC login
> and Circulation checkout count and Circulation History could match.
> --------------
> UPDATE old_issues SET returndate = '2017-09-22' WHERE returndate IS NULL;
> ---------------
>
> with thanks
> -satish
>