- Koha - lists.katipo.co.nz

subscribe to mail list
by Torma, Rozália 04 Mar '23

04 Mar '23

*Rozalia TORMA* *Bibliothekarin* | Könyvtáros *Bibliothek *| Könyvtár _______________________________ *Andrássy Universität Budapest* | * Andrássy Gyula Budapesti Német Nyelvű Egyetem**H-1088 Budapest |** Pollack Mihály tér 3*. Tel | (+36) 1-8158-133 Fax | (+36) 1-266-3099 www.andrassyuni.eu/bibliothek -- Diese Mitteilung erfolgt vertraulich und nur zur Kenntnisnahme durch die hierfür vorgesehenen Personen. Ihr Inhalt kann durch gesetzliche Berufs- oder Geschäftsgeheimnisse oder in sonstiger Weise geschützte Informationen enthalten. Sollte die Mitteilung irrtümlich zu Ihnen gelangt sein, ist jede Weitergabe, Kopie oder Nutzung des Inhalts unzulässig. Bitte benachrichtigen Sie den Absender gegebenenfalls telefonisch oder mit Antwortmail und löschen Sie diese Nachricht und alle Anhänge dazu unverzüglich. This message is confidential and may contain privileged, undisclosed or confidential information protected by law or regulation intended only for the exclusive use by particular persons. If you have received it by mistake, any review, copying, use or dissemination in whole or in part is strictly prohibited. Please notify the sender by return e-mail and delete this message and all its attachments from your system. Az ebben az e-mailben közölt információ bizalmas, törvény védi és csak a fent nevezett személynek vagy cégnek szól. Amennyiben nem Ön a címzett, tájékoztatjuk Önt, hogy ezen e-mail tartalmának nyilvánosságra hozatala, sokszorosítása, mások részére történő átadása és minden vele kapcsolatos cselekvés szigorúan tilos. Ha Ön ezt az e-mailt tévedésből kapta meg, kérjük, a lehető leggyorsabban lépjen velünk kapcsolatba.

1 0

KOHA upgrade error
by zen zenitram 03 Mar '23

03 Mar '23

Good morning all, we are trying to upgrade our koha database but too many duplicate entry shows. ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'ar' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739 This is the first error i encountered when upgrading koha from v20.05 to the latest version that is 22.11 and i already found the fix. The next error is " ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '20534' for key 'import_biblios.PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739". we tried to locate this duplicate entry and it points to biblios in reservoir entry. Anyone of you encountered this kind of error while upgrading? I need help on how we gonna fix it. Thank you!

2 1

How to run batchRebuildBiblioTables.pl
by library＠ssst.edu.ba 03 Mar '23

03 Mar '23

Hi all, I have been trying to find out how to run the batchRebuildBiblioTables.pl after Koha to MARC mapping errors were resolved, but couldn't figure out how exactly to execute this command in the terminal. After some googling it looked like /usr/share/koha/bin/batchRebuildBiblioTables.pl -c is what I needed to type, but I got this result: Can't locate Koha/Script.pm in @INC (you may need to install the Koha::Script module) (@INC contains: /usr/share/koha/bin/ /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.34.0 /usr/local/share/perl/5.34.0 /usr/lib/x86_64-linux-gnu/perl5/5.34 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.34 /usr/share/perl/5.34 /usr/local/lib/site_perl) at /usr/share/koha/bin/batchRebuildBiblioTables.pl line 9. BEGIN failed--compilation aborted at /usr/share/koha/bin/batchRebuildBiblioTables.pl line 9. When that didn't work I tried searching the archive for batchRebuildBiblioTables.pl and found this message: https://lists.katipo.co.nz/public/koha/2021-July/056487.html, which suggested using sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl -c' your_koha_name So I tried sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl -c' library The result was: DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st execute failed: Table 'koha_library.biblio' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152. DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/share/koha/lib/Koha/Database.pm line 152. Can someone help with how to resolve these please? Will I need to install Koha::Script module and how? My Koha version is 22.11.01, and MARC flavor is UNIMARC. I had recently run Koha to MARC mapping and my MARC Bibliographic framework test returned all OK after correcting the errors, but the message at the top of the page says If you make any change to the mappings, you must ask your administrator to run misc/batchRebuildBiblioTables.pl. Since our IT is dealing with other things and I'm the only one handling Koha installation, setup and eventual usage (god help me) I need to figure out many things that could seem obvious to more experienced users here. I only just started using Linux this month. Thank you in advance! Best regards Aida Đikić

2 1

Import Unimarc records with items
by Igor A. Sychev 03 Mar '23

03 Mar '23

Hello! There are records with items in UNIMARC format. Records are imported. Items are not imported. Why is this happening? Are there other options for importing items? Example: ... <datafield tag="995" ind1=" " ind2=" "> <subfield code="5">2001-01-01</subfield> <subfield code="9">1</subfield> <subfield code="a">NF</subfield> <subfield code="b">TPU</subfield> <subfield code="c">TPU</subfield> <subfield code="f">13821000185704</subfield> <subfield code="j">95-1389</subfield> <subfield code="k">95-1389</subfield> <subfield code="q">3700,00</subfield> <subfield code="r">BK</subfield> </datafield> ... Good Luck!

5 7

Adding ebook records to koha
by Thomas Vealehse 03 Mar '23

03 Mar '23

I am interested in the practice for adding ebooks marc records to koha. In particular, are items records added too? Is it necessary to have a 952 field? Thanks Thomas Veale

3 4

Setting folders for access_dir
by library＠ssst.edu.ba 03 Mar '23

03 Mar '23

Hello all, When I go to Access files under Additional tools, I get a message saying Error: Files could not be found because the "access_dir" option was not set in "koha-conf.xml". Contact your system administrator to add this option. Since Access files is meant for accessing "files stored on the server, like log files or reports", I assume it would be important to set this up correctly. What directory should be used to receive these log files and reports? Best regards Aida Đikić -----Original Message----- From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of koha-request(a)lists.katipo.co.nz Sent: Friday, February 24, 2023 12:00 AM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 208, Issue 21 Send Koha mailing list submissions to koha(a)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-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."

2 1

Another XSLT question: adding a line break between multiple names
by King, Fred 03 Mar '23

03 Mar '23

Hi everyone, I have another XLST question that I haven't been able to figure out: I'm using the 700 field for authors, and I want to start additional authors on a new line instead of separating them by |. This is what I have now:  <xsl:if test="marc:datafield[@tag=700]"> <xsl:if test="marc:datafield[@tag=700]/@ind1=' '"> MedStar authors: </xsl:if> <xsl:for-each select="marc:datafield[@tag=700]"> <a><xsl:attribute name="href">/cgi-bin/koha/opac-search.pl?q=au:"<xsl:value-of select="marc:subfield[@code='a']"/>"</xsl:attribute><xsl:value-of select="marc:subfield[@code='a']"/></a> <xsl:if test="marc:subfield[@code='b']"><a><xsl:attribute name="href">/cgi-bin/koha/opac-search.pl?q=au:"<xsl:value-of select="marc:subfield[@code='b']"/>"</xsl:attribute><xsl:text>, </xsl:text><xsl:value-of select="marc:subfield[@code='b']"/></a></xsl:if> <xsl:if test="marc:subfield[@code='c']"><a><xsl:attribute name="href">/cgi-bin/koha/opac-search.pl?q=au:"<xsl:value-of select="marc:subfield[@code='c']"/>"</xsl:attribute><xsl:text>, </xsl:text><xsl:value-of select="marc:subfield[@code='c']"/></a></xsl:if> <xsl:if test="position()!=last()"><xsl:text> | </xsl:text></xsl:if> </xsl:for-each> </xsl:if> And it shows on the OPAC details page the way it should: Arthur, King, field_b, field_c | Doyle, Arthur Conan | Arthur, Chester Alan, field_b | Murray, Arthur, field_c But what I'd really like is this: Arthur, King, field_b, field_c Doyle, Arthur Conan Arthur, Chester Alan, field_b Murray, Arthur, field_c Nothing I've tried so far has worked. Any suggestions? Thanks! --Fred Fred King, MSLS, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org You know it's cold outside when you go outside and it's cold. --NPS Twitter ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.

5 5

Internal server error with ISBD detail and making a hold on OPAC
by Paul 03 Mar '23

03 Mar '23

I’m recently started to get internal server errors when looking at ISBD detail and making a hold when in the OPAC. We’re using Koha 19.11.22.000 on Debian 9. I’ve seen a similar problem reported as bug 22735: Resolve internal server error on missing item type but that was on 18.05 and presumably fixed back then. Can anyone offer any fixes please? Paul Leman -- Paul Leman

2 1

How to resolve bug Bug 28267? What must I do in mysql?
by Δημήτρης Δαλαγιώργος 02 Mar '23

02 Mar '23

Dear all, I'm not a developer, and as I mentioned before, I'm stuck with an inoperable library catalogue due to the fact that I can't update to the latest version because "Older databases fail to upgrade due to having a row format other than "DYNAMIC"". https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267 I've read the comments on this bug but I fail to understand what I should do to fix this. Obviously I must login to mysql and perform some actions. What actions are those? Can someone point me to detailed instructions? Kind regards, Dimitrios Dalagiorgos 3rd high school of Kozani

2 2

The Terrific Every-Other-Thursday Training Videos | jQuery: Hold Dates | S3E13
by BRANNON, CHRISTOPHER 02 Mar '23

02 Mar '23

Hold it! Don't go any further. If you are looking for a way to wrangle your holds better around closed libraries, you should check out this video. George shows us ways to force "suspend until" dates for particular libraries, as well as work around some unexpected bugs with default hold expiration dates in current versions of Koha. I can't wait! But your patrons will have to if you implement these tweaks. https://youtu.be/GKrHrtLM5PM Christopher Brannon 2023 koha-US President

1 0