Patron with checked out items with no information
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.
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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@web.de> To: koha@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@web.de> To: koha@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@web.de> To: "clint.deckard" <clint.deckard@frontiers.co.nz>; "Koha-List" <koha@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@web.de> To: koha@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@web.de> To: "clint.deckard" <clint.deckard@frontiers.co.nz>; "Koha-List" <koha@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@web.de> To: koha@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
clint.deckard -
Katrin Fischer