Re: [Koha] Error 500 when opening records with attached items
Good day Katrin, I found a few items without item types. I have added these to the items where they were missing. I still get the error 500. I have run the rebuild, but still the error is there. Now, all items have the correct home and holdings locations as well as correct item types. The error 500 appears when: Checking out items Renewing items Checking in items Viewing the detailed display of records Batch editing/deleting items It looks like where there is anything to do with items, this error appears. I ran a report that outputs all items fields, and a few have entries in the field "more_subfields_xml". Here is an example of one entry: "<?xml version=""1.0"" encoding=""UTF-8""?> <collection xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xsi:schemaLocation=""http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"" xmlns=""http://www.loc.gov/MARC21/slim""> <record> <leader> a </leader> <datafield tag=""999"" ind1="" "" ind2="" ""> <subfield code=""d"">2022-05-19</subfield> </datafield> </record> </collection>" What does this field mean? Kind regards, Bongiwe Shongwe Chief Technology Officer Universal Knowledge Software Tel.: +27(11) 375-4700 Fax : +27(11) 375-4710 e-mail: bongiwe@uks.co.za Web: www.uks.co.za -------------------------------------------------------------------------------------------------- 7. Re: Error 500 when opening records with attached items (Katrin Fischer) Message: 7 Date: Mon, 18 Sep 2023 21:00:25 +0200 From: Katrin Fischer <katrin.fischer.83@web.de> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Error 500 when opening records with attached items Message-ID: <88b7e0c0-be32-dab5-f22e-e94973030060@web.de> Content-Type: text/plain; charset=UTF-8; format=flowed Hi, did you check the itemtype as well? It would also cause a 500 in the OPAC. Hope this helps, Katrin On 18.09.23 20:06, bongiwe@uks.co.za wrote:
Good day, Thomas
Thank you for your response. I checked all the items and all have the correct homebranch and holdingbranch
Kind regards,
Bongiwe Shongwe Chief Technology Officer Universal Knowledge Software Tel.: +27(11) 375-4700 Fax : +27(11) 375-4710 e-mail: bongiwe@uks.co.za Web: www.uks.co.za
-----Original Message----- From: Thomas Klausner <domm@plix.at> Sent: Tuesday, September 5, 2023 2:43 PM To: bongiwe@uks.co.za Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Error 500 when opening records with attached items
Hi!
On Tue, Sep 05, 2023 at 02:17:59PM +0200, bongiwe@uks.co.za wrote:
We have just migrated our database to another server with an upgraded version of KOHA (23.05.01.000). On the new server we encounter problems with opening bibliographic records in NORMAL view after performing a search. We get the "error 500". This only happens in records with attached items. Records with no items attached to them open successfully in this view. First guess: The items have no homebranch and holdingbranch. Make sure that every item has a (correct) value for those columns.
Greetings, domm
------------------------------ Message: 8 Date: Mon, 18 Sep 2023 21:03:18 +0200 From: Katrin Fischer <katrin.fischer.83@web.de> To: koha@lists.katipo.co.nz Subject: Re: [Koha] output of authors' subfields Message-ID: <fa179307-61f3-5ff2-aee3-356b2a877d64@web.de> Content-Type: text/plain; charset=UTF-8; format=flowed Hi, Koha uses XSLT stylesheets to display bibliographic and optionally authority data. Instead of using the default, you can also define your own - look for XSLT in the system preferences. But it might also be worth reporting an enhancement request for this one if it's about following the MARC standard. Hope this helps, Katrin On 15.09.23 16:37, Сычев Игорь Алексеевич wrote:
Hello!
How to do if 7xx $g and $b are filled, output only $g? Both subfields are being displayed now. Is this reaction only in Unimarc? Example: 700 $aAufderstraße $bH. $gHartmut
https://koha.lib.tpu.ru/cgi-bin/koha/opac-detail.pl?biblionumber=667189 https://koha.lib.tpu.ru/cgi-bin/koha/opac-detail.pl?biblionumber=22141 https://koha.lib.tpu.ru/cgi-bin/koha/opac-detail.pl?biblionumber=634386
Good Luck!
Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 215, Issue 18 *************************************
Hi, I think you need to check the server logs for the full error, so we can see what might be the source of the issue. more_subfields_xml is used to store additional item information that hasn't been mapped to any of the standard fields. Odd is that $d in MARC21 should be mapped to items.dateaccessioned, but I am not sure if this could be the source of your problem. Are you using MARC21 and have you changed anything about the Koha to MARC mappings? Katrin On 27.09.23 20:23, bongiwe@uks.co.za wrote:
Good day Katrin,
I found a few items without item types. I have added these to the items where they were missing. I still get the error 500. I have run the rebuild, but still the error is there. Now, all items have the correct home and holdings locations as well as correct item types.
The error 500 appears when:
Checking out items Renewing items Checking in items Viewing the detailed display of records Batch editing/deleting items
It looks like where there is anything to do with items, this error appears. I ran a report that outputs all items fields, and a few have entries in the field "more_subfields_xml". Here is an example of one entry:
"<?xml version=""1.0"" encoding=""UTF-8""?> <collection xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xsi:schemaLocation=""http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"" xmlns=""http://www.loc.gov/MARC21/slim"">
<record> <leader> a </leader> <datafield tag=""999"" ind1="" "" ind2="" ""> <subfield code=""d"">2022-05-19</subfield> </datafield> </record>
</collection>"
What does this field mean?
Kind regards,
Bongiwe Shongwe Chief Technology Officer Universal Knowledge Software Tel.: +27(11) 375-4700 Fax : +27(11) 375-4710 e-mail: bongiwe@uks.co.za Web: www.uks.co.za
--------------------------------------------------------------------------------------------------
7. Re: Error 500 when opening records with attached items (Katrin Fischer)
Message: 7 Date: Mon, 18 Sep 2023 21:00:25 +0200 From: Katrin Fischer <katrin.fischer.83@web.de> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Error 500 when opening records with attached items Message-ID: <88b7e0c0-be32-dab5-f22e-e94973030060@web.de> Content-Type: text/plain; charset=UTF-8; format=flowed
Hi,
did you check the itemtype as well? It would also cause a 500 in the OPAC.
Hope this helps,
Katrin
On 18.09.23 20:06, bongiwe@uks.co.za wrote:
Good day, Thomas
Thank you for your response. I checked all the items and all have the correct homebranch and holdingbranch
Kind regards,
Bongiwe Shongwe Chief Technology Officer Universal Knowledge Software Tel.: +27(11) 375-4700 Fax : +27(11) 375-4710 e-mail: bongiwe@uks.co.za Web: www.uks.co.za
-----Original Message----- From: Thomas Klausner <domm@plix.at> Sent: Tuesday, September 5, 2023 2:43 PM To: bongiwe@uks.co.za Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Error 500 when opening records with attached items
Hi!
On Tue, Sep 05, 2023 at 02:17:59PM +0200, bongiwe@uks.co.za wrote:
We have just migrated our database to another server with an upgraded version of KOHA (23.05.01.000). On the new server we encounter problems with opening bibliographic records in NORMAL view after performing a search. We get the "error 500". This only happens in records with attached items. Records with no items attached to them open successfully in this view. First guess: The items have no homebranch and holdingbranch. Make sure that every item has a (correct) value for those columns.
Greetings, domm
------------------------------
Message: 8 Date: Mon, 18 Sep 2023 21:03:18 +0200 From: Katrin Fischer <katrin.fischer.83@web.de> To: koha@lists.katipo.co.nz Subject: Re: [Koha] output of authors' subfields Message-ID: <fa179307-61f3-5ff2-aee3-356b2a877d64@web.de> Content-Type: text/plain; charset=UTF-8; format=flowed
Hi,
Koha uses XSLT stylesheets to display bibliographic and optionally authority data. Instead of using the default, you can also define your own - look for XSLT in the system preferences.
But it might also be worth reporting an enhancement request for this one if it's about following the MARC standard.
Hope this helps,
Katrin
On 15.09.23 16:37, Сычев Игорь Алексеевич wrote:
Hello!
How to do if 7xx $g and $b are filled, output only $g? Both subfields are being displayed now. Is this reaction only in Unimarc? Example: 700 $aAufderstraße $bH. $gHartmut
https://koha.lib.tpu.ru/cgi-bin/koha/opac-detail.pl?biblionumber=667189 https://koha.lib.tpu.ru/cgi-bin/koha/opac-detail.pl?biblionumber=22141 https://koha.lib.tpu.ru/cgi-bin/koha/opac-detail.pl?biblionumber=634386
Good Luck!
Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Subject: Digest Footer
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
End of Koha Digest, Vol 215, Issue 18 *************************************
participants (2)
-
bongiwe@uks.co.za -
Katrin Fischer