- Koha - lists.katipo.co.nz

auto_increment problem with holds in Koha 21.11
by Michael Kuhn 27 Apr '23

27 Apr '23

Hi We are working on Debian GNU/Linux 10 with MariaDB 10.3.38 and Koha 21.11.09. Since about September 2022 after the update from Koha 18.11 to 21.11 we see auto_increment problems with tables "reserves" and "old_reserves" (but NOT with any of the other tables): The following ids exist in both tables reserves and old_reserves: 372 In fact every single hold evokes the problem. Deleting the id manually from table "old_reserves" does always solve the problem: DELETE FROM old_reserves WHERE reserve_id IN (372); According to https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix the auto_increment problem should not occur at all after Koha 17.05. What could be the reason for this behavior? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 1

KOHA upgrade from V20.05 to V22.11 (Browse by last name error)
by zen zenitram 27 Apr '23

27 Apr '23

Hello I finished upgrading koha version 20.05 to version 22.11, but when i tried to search for patron by clicking the letter of the last name this message shows ( Something went wrong when loading table . 500 Internal server error. then lots of " Month out of range message". How do i fix this kind of error? I tried to overwrite the patron by uploading new list of patrons but nothing change. Thank you!

2 1

koha-US May 2023 Events & Meetings
by Jennifer Marlatt 27 Apr '23

27 Apr '23

Hello! koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/. For Google Calendar users, add our events calendar to your list for easy access to meeting times and links: https://calendar.google.com/calendar/u/1?cid=a29oYS11cy5vcmdfZG1xb2pkczE5Zn… *Meetings* Board Meeting - Wednesday, May 3 @ 8:30a PT / 11:30a ET / 15:30 UTC General Meeting - Wednesday, May 10 @ 8:30a PT / 11:30a ET / 15:30 UTC *Special Interest Groups* Cataloging - Thursday, May 4 @ 8:00a PT / 11:00a ET / 15:00 UTC System Administration - Tuesday, May 9 @ 8:00a PT / 11:00a ET / 15:00 UTC *Circulation - Thursday, May 11 @ 8:00a PT / 11:00a ET / 15:00 UTC - New day & time!!* Acquisitions - Tuesday, May 16 @ 9:00a PT / 12:00p ET / 16:00 UTC Web Development - Thursday, May 18 @ 10:00a PT / 1:00p ET / 17:00 UTC Consortia - Thursday, May 25 @ 9:00a PT / 12:00p ET / 16:00 UTC Demonstration Instance - on hiatus Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topic-specific mailing lists. Most meetings and events are recorded and made available at https://www.youtube.com/kohaus Jennifer Marlatt koha-US Secretary secretary(a)koha-us.org

1 0

Roles for 23.11 are open
by Tomas Cohen Arazi 26 Apr '23

26 Apr '23

A new cycle is about to start. It is time for you all to put your names for the next release. Here: https://wiki.koha-community.org/wiki/Roles_for_23.11 Best regards -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

1 0

Reminder: Development IRC Meeting this week
by David Nind 26 Apr '23

26 Apr '23

Hi everyone. Just a reminder that the Development IRC Meeting is on this week - 26 April 2023, 14:00 UTC. *Agenda*: https://wiki.koha-community.org/wiki/Development_IRC_meeting_26_April_2023 *Time*: To see what time the meeting is for you, visit https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I… *Agenda items*: There are a lot of items on the agenda. If you have action points or general business items, please add a quick update to the agenda to help the meeting go faster. I've also added the agenda items from the General IRC Meeting that was not held. Note: The Development IRC Meeting previously scheduled for 12 April 2023 was not held. David Nind New Zealand

1 0

Special CatSIG at a later time!
by Hernandez, Heather H 25 Apr '23

25 Apr '23

Hi, all! The second Koha-US Cataloging Special Interest Group ("CatSIG") April meeting is coming up on Thursday April 27, 2023, at 1(13:00)PT / 4(16:00)ET / 9(21:00)UTC, Friday April 28, 2023, 8:00 NZST! You don't have to be a member of Koha-US to join us, so we're hoping the different times will make it possible for more folks to join in! This meeting is the second of additional, quarterly CatSIGs during the US's afternoons, as an experiment to see if more folks would like to join us at that time. And remember that you don't even need to self-identify as a cataloger! There will be our usual roundtable of questions, solutions and resource brainstorming, tips, tricks, suggestions, bug & development awareness, and the usual laughter, fun, and fellowship to discuss anything cataloging, authority, or metadata related in Koha. Not sure if it's cataloging related? It probably is! Actual catalogers do attend, as well as the cataloging curious and those who have had cataloging thrust upon them! Information on joining us is on the Koha-US calendar: https://koha-us.org/calendar/ Can't make it? No worries--it will be recorded and available on the Koha-US YouTube Channel: https://www.youtube.com/c/kohaUS/playlists (See the Cataloging Special Interest Group's playlist for more cataloging fun!) As ever, feel free to send me any questions or topics for discussion ahead of time! See you there! --h2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian Library catalog: https://keys.bywatersolutions.com/ San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032 (office, generally M, W, F, telecommuting Tu,Th) heather_hernandez(a)nps.gov<https://webmail.lmi.net/src/compose.php?send_to=heather_hernandez%40nps.gov>

1 0

OPAC Search results - 500 Error
by John J. English 24 Apr '23

24 Apr '23

Hello all, I'm having trouble getting detail for books in the OPAC. If I search for something in the catalog I'm presented with ta list of books. If I click the title of a book I get a 500 error. I think it must something to do with "DBIC result _type isn't of the _type Branch" seen in the plack error log. Relevant logs are below. Any help is much appreciated. Thank you. ==> /var/log/koha/library/plack-opac-error.log <== [2023/04/18 11:06:04] [WARN] Use of uninitialized value in hash element at /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl line 680. ==> /var/log/koha/library/plack-error.log <== DBIC result _type isn't of the _type Branch at /usr/share/koha/opac/cgi-bin/opac/opac-detail.pl line 680. ==> /var/log/koha/library/plack.log <== 192.168.101.254 - - [18/Apr/2023:11:06:04 -0600] "GET /opac/opac-detail.pl?biblionumber=631&query_desc=kw%2Cwrdl%3A%20deep%20work HTTP/1.1" 500 20863 "https://library.ncat.org/cgi-bin/koha/opac-search.pl?idx=kw&q=deep%20work&s…" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0" ==> /var/log/koha/library/opac-access.log <== 192.168.101.254 - - [18/Apr/2023:11:06:04 -0600] "GET /cgi-bin/koha/opac-detail.pl?biblionumber=631&query_desc=kw%2Cwrdl%3A%20deep%20work HTTP/1.1" 500 20863 JOHN J. ENGLISH

2 2

Re: [Koha] Error 500 with dpkg returned an error code (1)
by library＠ssst.edu.ba 24 Apr '23

24 Apr '23

Hello Fred, Last I wrote I was about to make the changes you suggested, but even after doing so I still had DDC in Details for the cataloged books. However other things came up and I couldn't write back right away, and the next day I had to go on sick leave. I checked Administration > Classification configuration, and I had already set DDC to "No" and UDC to "Yes" for the field "In use". When I went to edit a record, I found that I didn't have the field 080ab in the "Books, booklets, workbooks" MARC framework I'm using, only the 082 DDC field, so there was nothing to map the MARC subfields to. The question now is, how do I add the 080ab field and remove 082? I've seen from messing about in the now gone UNIMARC flavor installation that it wasn't a good idea to delete fields at will because that gets me a 500 error. Best regards Aida Đikić From: library(a)ssst.edu.ba <library(a)ssst.edu.ba> Sent: Tuesday, April 18, 2023 1:19 PM To: King, Fred <Fred.King(a)Medstar.net>; koha(a)lists.katipo.co.nz Subject: Re: [Koha] Error 500 with dpkg returned an error code (1) Thank you, Fred, I'll try that right away! Best regards Aida Đikić ________________________________ From: King, Fred <Fred.King(a)Medstar.net<mailto:Fred.King@Medstar.net>> Sent: Monday, April 17, 2023 4:04 PM To: library(a)ssst.edu.ba<mailto:library@ssst.edu.ba> <library(a)ssst.edu.ba<mailto:library@ssst.edu.ba>>; koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> <koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>> Subject: Re: [Koha] Error 500 with dpkg returned an error code (1) > Alternatively, if I must continue to use the MARC21 flavor, and since by default both the staff interface and OPAC show the DDC classification, is it possible to replace that with UDC? This part I think I can help you with. UNIMARC, not at all. :-) If you go to Administration --> System preferences --> Cataloging preferences --> Record structure --> itemcallnumber you can choose which MARC subfields will be displayed in the Call Number field. For UDC it would be 080ab. Then go up to Interface --> DefaultClassificationSource and select Universal Decimal Classification. You can add others--my library uses NLM, for example. --Fred Fred King, MSLS, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net<mailto:fred.king@medstar.net> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org I'm thinking about selling my theremin... I haven't touched it in years. --Anon

1 0

email notice sending
by zen zenitram 21 Apr '23

21 Apr '23

hello KOHA v22.11 How to check for errors in my SMTP and Overdue notice/status triggers <http://172.16.35.130:15000/cgi-bin/koha/tools/overduerules.pl>. because everytime i tried to checkout books for client this error appear ( Unhandled email failure, check the logs for further details) which log should i check? Thank you!

3 7

view patron information (borrowers)
by Сычев Игорь Алексеевич 21 Apr '23

21 Apr '23

Hello! How do I set up so that the librarian can only view information about the reader and cannot edit it? I only see (edit_borrowers). Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru<https://lib.tpu.ru/>

2 2