[Koha] Patron with checked out items with no information

[Katrin Fischer]

Hi Clint,

with SQL you could delete the entries for the checkouts from the issues
table. But before you do that it might be worthwhile to try and figure
out how it happened. It would be interesting to check if the itemnumber
is still present in issues. If the itemnumbers are there, does the
itemnumber exist in items or deletediems?

Katrin


On 06.11.20 20:46, clint.deckard wrote:
> Hello again Katrin,
> No, the patrons checkout history only shows the time the three items
> were checked out and no other details.
> I realise it should not be possible to delete items/records that are
> checked out but that certainly looks like what has happened.
>
> Could there be a way to remove the issues at database level?
>
> Clint.
>
> ------ Original Message ------
> From: "Katrin Fischer" <katrin.fischer.83 at web.de>
> To: "clint.deckard" <clint.deckard at frontiers.co.nz>; "Koha-List"
> <koha at lists.katipo.co.nz>
> Sent: 7/11/2020 6:59:26 a.m.
> Subject: Re: [Koha] Patron with checked out items with no information
>
>> Hi Clint,
>>
>> I am not sure what's going on there. If you look at the checkout history
>> for the patron, does the information there display correctly? (you might
>> have to turn on the 'intranetreadinghistory' system preference first)
>>
>> In Koha it should not be possible to delete records/items while they are
>> checked out.
>>
>> Katrin
>>
>>
>> On 04.11.20 23:21, clint.deckard wrote:
>>> Thank you Katrin,
>>> error message from the log when checking the patrons checked out items
>>> is;
>>> [Thu Nov  5 07:58:08 2020] checkouts: GetMarcBiblio called with
>>> undefined biblionumber at
>>> /usr/share/koha/intranet/cgi-bin/svc/checkouts line 168.
>>> [Thu Nov  5 07:58:08 2020] checkouts: GetRecordValue called with
>>> undefined record at /usr/share/koha/intranet/cgi-bin/svc/checkouts
>>> line 168.
>>> [Thu Nov  5 07:58:08 2020] checkouts: Use of uninitialized value $lost
>>> in anonymous hash ({}) at
>>> /usr/share/koha/intranet/cgi-bin/svc/checkouts line 168.
>>> [Thu Nov  5 07:58:08 2020] checkouts: Use of uninitialized value
>>> $damaged in anonymous hash ({}) at
>>> /usr/share/koha/intranet/cgi-bin/svc/checkouts line 168.
>>> [Thu Nov  5 07:58:08 2020] checkouts: Odd number of elements in
>>> anonymous hash at /usr/share/koha/intranet/cgi-bin/svc/checkouts line
>>> 168.
>>>
>>> It looks as though  biblio records have been deleted whilst items
>>> checked out. The librarian suggests this may be true but it is unsure.
>>> Given there are no details for the 'blank' checked out items, how does
>>> one go about rectifying it?
>>>
>>> Clint.
>>>
>>>
>>>
>>>
>>> ------ Original Message ------
>>> From: "Katrin Fischer" <katrin.fischer.83 at web.de>
>>> To: koha at lists.katipo.co.nz
>>> Sent: 4/11/2020 8:41:00 p.m.
>>> Subject: Re: [Koha] Patron with checked out items with no information
>>>
>>>> Hi Client,
>>>>
>>>> if you use the developer tools in your browser it might help to see a
>>>> more detailed error message.
>>>>
>>>> One case we saw recently where the checkouts list would not load was
>>>> when the user had checked out an item without 245$a ($p was filled
>>>> out,
>>>> so it was not obvious on first glance when looking at the record).
>>>> Also
>>>> check the items have all required values, like itemtype, homebranch
>>>> and
>>>> holdingbranch set.
>>>>
>>>> Hope that helps,
>>>>
>>>> Katrin
>>>>
>>>> On 04.11.20 00:43, clint.deckard wrote:
>>>>> I have a patron that has a number of checked out items, three of
>>>>> which
>>>>> are blank/have no details ie. when viewing overdue items there are no
>>>>> details for three of the items.
>>>>> When listing checked out items for this patron it just sits trying to
>>>>> load them.
>>>>> I can't find any similar problem in bugs or the web.
>>>>> How can I correct the problem?
>>>>>
>>>>> This was originally a 3.20 version and migrated to 17.11 on Debian
>>>>> using MySQL.
>>>>> There are no problems listed in 'System Information' on the 'About
>>>>> Koha' page.
>>>>>
>>>>> Appreciate the help,
>>>>> Clint.
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>>
>>>>> Koha mailing list  http://koha-community.org
>>>>> Koha at lists.katipo.co.nz
>>>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>> _______________________________________________
>>>>
>>>> Koha mailing list  http://koha-community.org
>>>> Koha at lists.katipo.co.nz
>>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>