[Koha] Error 500 when opening records with attached items

Sat Sep 30 08:15:17 NZDT 2023

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 at 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 at 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 at web.de>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Error 500 when opening records with attached items
> Message-ID: <88b7e0c0-be32-dab5-f22e-e94973030060 at 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 at 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 at uks.co.za
>> Web: www.uks.co.za
>>
>>
>>
>>
>> -----Original Message-----
>> From: Thomas Klausner <domm at plix.at>
>> Sent: Tuesday, September 5, 2023 2:43 PM
>> To: bongiwe at uks.co.za
>> Cc: koha at 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 at 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 at web.de>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] output of authors' subfields
> Message-ID: <fa179307-61f3-5ff2-aee3-356b2a877d64 at 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 at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ------------------------------
>
> End of Koha Digest, Vol 215, Issue 18
> *************************************
>