Re: [Koha] Error 500 when opening records with attached items
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, bong...@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: " 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";> a 2022-05-19 " 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: bong...@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 To: koha@lists.katipo.co.nz Subject: Re: [Koha] Error 500 when opening records with attached items Message-ID: <88b7e0c0-be32-dab5-f22e-e94973030...@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, bong...@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: bong...@uks.co.za Web: www.uks.co.za -Original Message- From: Thomas Klausner Sent: Tuesday, September 5, 2023 2:43 PM To: bong...@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, bong...@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 To: koha@lists.katipo.co.nz Subject: Re: [Koha] output of authors' subfields Message-ID: 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/ko
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: " 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";> a 2022-05-19 " 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: bong...@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 To: koha@lists.katipo.co.nz Subject: Re: [Koha] Error 500 when opening records with attached items Message-ID: <88b7e0c0-be32-dab5-f22e-e94973030...@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, bong...@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: bong...@uks.co.za > Web: www.uks.co.za > > > > > -Original Message- > From: Thomas Klausner > Sent: Tuesday, September 5, 2023 2:43 PM > To: bong...@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, bong...@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 To: koha@lists.katipo.co.nz Subject: Re: [Koha] output of authors' subfields Message-ID: 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 * ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Error 500 when opening records with attached items
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, bong...@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: bong...@uks.co.za Web: www.uks.co.za -Original Message- From: Thomas Klausner Sent: Tuesday, September 5, 2023 2:43 PM To: bong...@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, bong...@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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Error 500 when opening records with attached items
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: bong...@uks.co.za Web: www.uks.co.za -Original Message- From: Thomas Klausner Sent: Tuesday, September 5, 2023 2:43 PM To: bong...@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, bong...@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 -- Thomas Klausner domm https://domm.plix.at Just another ( Perl | Postgres | Bicycle | Food | Photo | Vinyl ) Hacker A not-so-short list of things I learned at PerlKohaCon #Perl #Koha [ 2023-08-19 10:00 > https://domm.plix.at/perl/2023_08_things_i_learned_at_perlkohacon.html ] Fun: manually deleting a bridge set up by docker, because it is hogging the IP space that's also used by the free train WLAN network login page [ 2023-09-01 12:50 > https://domm.plix.at/microblog.html ] ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Error 500 when opening records with attached items
Hi! On Tue, Sep 05, 2023 at 02:17:59PM +0200, bong...@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 -- Thomas Klausner domm https://domm.plix.at Just another ( Perl | Postgres | Bicycle | Food | Photo | Vinyl ) Hacker A not-so-short list of things I learned at PerlKohaCon #Perl #Koha [ 2023-08-19 10:00 > https://domm.plix.at/perl/2023_08_things_i_learned_at_perlkohacon.html ] Fun: manually deleting a bridge set up by docker, because it is hogging the IP space that's also used by the free train WLAN network login page [ 2023-09-01 12:50 > https://domm.plix.at/microblog.html ] ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Error 500 when opening records with attached items
Good day, Apologies if I am sending to an incorrect list. 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. ISDB and MARC views are not an issue. These views open successfully for all records even those with attached items. We also cannot delete items from records. We get the same 500 error. Kind regards, Bongiwe Shongwe ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
