- Koha - lists.katipo.co.nz

Possible solution to 500 errors.
by Rudy Hinojosa 21 Sep '23

21 Sep '23

If you are running into 500 errors, and you've exhausted all means to verify you have a valid biblio, a valid item record and confirmed homebranch is populated, there may be one more spot you need check. Before I state what I found, this is a disclaimer. Do not attempt what I did without consulting with your Database Administrator or someone with technical experience. ===Discovery=== You may have an invalid XML structure in your table biblio_metadata->metadata field. Dump the xml content for the suspected record to your clipboard and visit any online xml validator checker tool. Paste it and see if it passes. I found 134 records with invalid xml properties. <datafield tag="500" ind1=" " ind2=" "> <subfield code=""">Based on the TV series SpongeBob SquarePants created by Stephen Hillenburg as seen on Nickelodeon"--T.p. verso.</subfield> </datafield> I found 134 records with triple double quotes as you see above to the left of the word Based. Your koha-rebuild-zebra command should alert you of all xml errors. You'll really want to fix those if you don't want to see 500 errors. Here's my code snippet I ran to fix this problem globally, now keep in mind, your xml errors may not be the same as mine, but you'll have to investigate your own solution: ====sql fix==== -- Step 1: Create a copy of biblio_metadata as reh_biblio_metadata CREATE TABLE reh_biblio_metadata AS SELECT * FROM biblio_metadata; -- Step 2: Update the metadata field in biblio_metadata UPDATE biblio_metadata SET metadata = REPLACE(metadata, '=""">', '="">') WHERE metadata LIKE '%=""%">%'; =========== then exit to system prompt and run your reindex: "koha-rebuild-zebra -f -a -b -v <your-koha-instance>" Cheers! -- photo Rudy E. Hinojosa CEO/President,Lightwave Library +1 737-372-7779 <tel:+1 737-372-7779> | lightwavelibrary.com <https://lightwavelibrary.com> rudy.hinojosa(a)lightwavelibrary.com <mailto:rudy.hinojosa@lightwavelibrary.com> 25101 Ronald W. Reagan Blvd #49, Georgetown TX 78633 <https://maps.google.com/?q=25101 Ronald W. Reagan Blvd #49, Georgetown TX 78633>

1 0

cannot display branchname and patron category description in card layout
by Zahid Iqbal 20 Sep '23

20 Sep '23

Hi, In koha 22.11 can someone guide to print branchname and patron category description on pdf file for patron card creator 1. print branchname not branchcode 2. print patron-category-description not categorycode what are the values i have to type in text box for field1 and field2 in patron card layout for printing branchname and patron-category-description? i am stuck with this problem and cannot find any other solution Can anyone suggest that i have to change the code or is there any other way that it can be solved? I am not an expert in coding, any help will be appreciated. Best Regards -- *Zahid Iqbal*

1 0

Error 500 when opening records with attached items
by bongiwe＠uks.co.za 19 Sep '23

19 Sep '23

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

3 3

Koha running number of background job process and CPU high usage
by JITHIN N 19 Sep '23

19 Sep '23

Am using Koha 22.11.07. My server running 6 instances. I noticed my disk was filling up because worker-output.log was getting several hundred of these per second: *[2023/09/17 22:41:14] [WARN] Frame not processed - malformed JSON string, neither tag, array, object, number, string or atom, at character offset 0 (before "You must log in usin...") at /usr/share/koha/bin/workers/background_jobs_worker.pl <http://background_jobs_worker.pl> line 118. main::catch {...} /usr/share/koha/bin/workers/background_jobs_worker.pl <http://background_jobs_worker.pl> (120)* while checking the terminal it ran a number of background jobs and CPU usage became very high. can I have any solution for this? With Regards JIthin

2 1

Email for suggestion book
by Toni Afandi 19 Sep '23

19 Sep '23

Dear all, After upgrading to Koha 23 from koha 20, I noticed something strange about the suggestion notification email. Now I receive email when a patron suggestion is received or declined, but no to the patron who suggests. So where should I set the email so they would receive it? I noticed that koha made a notification, but it is set to me not to the patrons. Thank you *Toni Afandi* *Librarian* *STT SAAT* *(Southeast Asia Bible Seminary)* Jl. Bukit Hermon No 1, Tidar Atas Malang, Jawa Timur 65151 Indonesia www.seabs.ac.id

2 1

link_bibs_to_authorities
by Сычев Игорь Алексеевич 17 Sep '23

17 Sep '23

Hello! When executing "link_bibs_to_authorities.pl", the messages "oAuth error: Too many characters in search statement (11) Bib-1" are output. What's it? How can I see the details? Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru/

1 0

Problem with SIP
by Gonzalo Córdova Mío 16 Sep '23

16 Sep '23

Hello. I have already configured the SIP for self-service and when making a loan from the loan equipment I get this error message. Anyone know what might be happening? 2023-09-15 15:10:03,817 INFO [SIP] MessageFormatter - Parsed: [64] Patron Information Response {patron_status = None, language = SpanishNA, transaction_date = 2023-09-15T15:10:04, hold_items_count = 0, overdue_items_count = 0, charged_items_count = 0, fine_items_count = 0, recall_items_count = 0, unavailable_holds_count = 0, institution_id = "BUCS", patron_identifier = #6da1f2e2, personal_name = #4414b04d, valid_patron = True, valid_patron_password = True, fee_amount = 0, fee_limit = 5, PC = "AL", PI = "Y", screen_message = "Greetings from Koha. "} 2023-09-15 15:10:03,819 TRACE [SIP] MessageProcessor - Response read for: Patron Information Response, elapsed=00:00:00.2712779 2023-09-15 15:10:03,821 ERROR [SIP] MessageProcessor - Invalid message received: The value for field "patron_identifier" in the response (patron_identifier = #6da1f2e2) is not the expected value (patron_identifier = #6a705781); requesting resend (1) 2023-09-15 15:10:03,823 TRACE [SIP] MessageProcessor - Writing request for: Request ACS Resend, timeout=00:00:19.6590000 -------- Gonzalo Córdova

1 0

String freeze - 22.11.x
by Blenkinsop, Matthew 15 Sep '23

15 Sep '23

Hi everyone, String freeze for 22.11.x starts today (15/09). Aiming to release at the end of next week or the beginning of the following week. Happy translating! Matt Blenkinsop Junior Software Engineer PTFS Europe [image: Phone icon] M: +44 7311382399 | T: +44 1483 378728 ext. 1020 [image: Email icon] matt.blenkinsop(a)ptfs-europe.com [image: Link icon] www.ptfs-europe.com [image: Click to open Twitter] [image: Click to open YouTube] <https://www.youtube.com/@PTFSEurope> [image: Click to open PTFS Europe webpage]

1 0

Patron Profile picture upload
by Rupinder Singh 15 Sep '23

15 Sep '23

HI, I have a question, just like we can allow our users to edit or add their profile information from the opac profile section. Can we also enable any option so that users can upload their photos themselves ? Thanks Rupinder Singh

2 1

Koha ERM workflow / EDS
by Jeffrey Gabel 14 Sep '23

14 Sep '23

Hi everyone, Brooklyn Law School Library is interested in learning about other Koha libraries' workflows using the Koha ERM module, and with the EDS holding API for those who also use EDS. We are just starting to test the ERM and think about workflow and practices here. Has anyone starting using the ERM in their regular workflow? Thank you, Jeff Gabel Acquisitions Librarian Brooklyn Law School Library 250 Joralemon Street Brooklyn, NY 11201 718-780-7978 jeff.gabel(a)brooklaw.edu

1 0