[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
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
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
[Koha] Error: Something went wrong when loading the table
Good day, Support. We are trying to receive some orders on the system, and we are getting an error "Something went wrong when loading the table. 500: Internal server error". This is not happening with all orders. We have just migrated to a new server. Bongiwe Shongwe ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Error: Something went wrong when loading the table
Good day Aleisha, We checked the plack-error.log and this what we are finding: Process Backgrounded 2023/11/21-10:39:31 Starman::Server (type Net::Server::PreFork) starting! pid(1143836) Binding to UNIX socket file "/var/run/koha/library/plack.sock" Setting gid to "1002 1002" Setting uid to "1002" 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: Koha On Behalf Of koha-requ...@lists.katipo.co.nz Sent: Monday, November 20, 2023 1:00 AM To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 217, Issue 17 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit https://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-requ...@lists.katipo.co.nz You can reach the person managing the list at koha-ow...@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Error: Something went wrong when loading the table (Aleisha Amohia) -- Message: 1 Date: Mon, 20 Nov 2023 09:04:14 +1300 From: Aleisha Amohia To: koha@lists.katipo.co.nz Subject: Re: [Koha] Error: Something went wrong when loading the table Message-ID: <0b643a0b-44c6-40c6-8264-71db69960...@catalyst.net.nz> Content-Type: text/plain; charset=UTF-8; format=flowed Hello, We've seen this error a few times with our libraries. In our experience is often related to data - dates (such as the order date) in the wrong format in the database, or having NULL values when they shouldn't, or a relationship to another table failing due to a NULL value. You should be able to get more information on the error in your plack-error.log on the server. Aleisha On 17/11/23 21:33, bong...@uks.co.za wrote: > Good day, Support. > > We are trying to receive some orders on the system, and we are getting > an error "Something went wrong when loading the table. 500: Internal > server error". This is not happening with all orders. > > We have just migrated to a new server. > > Bongiwe Shongwe > > ___ > > Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha -- *Aleisha Amohia (she/her)* Technical Lead | Rōpū kohinga *Catalyst.Net Limited - Expert Open Source Solutions* *Catalyst.Net Ltd - a Catalyst IT group company* Tel: +64 4 803 2259 or +61 3 9116 2642 | www.catalyst.net.nz <http://www.catalyst.net.nz> Follow Catalyst Koha on Twitter <https://twitter.com/catalystkoha> | Subscribe to the Catalyst Koha newsletter <https://catalyst.us4.list-manage.com/subscribe?u=62457ff5060d15ee3c07d3fc4&id=b73fbdcac8> Catalyst Logo CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267. -- Subject: Digest Footer ___ Koha mailing list Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha -- End of Koha Digest, Vol 217, Issue 17 * ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Unable to hide login screen on Koha OPAC
Hi
I would like to make our KOHA OPAC open to the public without them having to
login. I have edited the OPACUserJS entry and put in the following string,
$("#login").hide();
The login screen is still there after saving this.
What could I be doing wrong?
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
[Koha] Staging background job at null.0 progress
Dear all, We seem to have a recent problem with staging our import records where thee progress is stuck at 0. The progress status is null/0. We have been able to import until recently when we had a problem with Koha and needed to restore from backup. Why could be the reason for our staging background job to be stuck at 0. We are on Koha version 23.11.10.000 Thank you. Kind regards, Bongiwe Shongwe Universal Knowledge Software Tel.: +27(11) 375-4700 Fax : +27(11) 375-4710 e-mail: bong...@uks.co.za Web: www.uks.co.za Confidentiality Notice: The above message and all attachments may contain privileged and confidential information intended only for the person or entity to which it is addressed. Any review, retransmission, dissemination, copy or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the material from your computer. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the view of the entity transmitting the message. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
