- Koha - lists.katipo.co.nz

Koha 22.11 Upgrade - Bug 31162 - Add primary key to erm_eholdings_packages_agreements
by Craig Butosi 26 Feb '23

26 Feb '23

Hi there, Just updated to Koha 22.11 (ubuntu 18.04.06) and received an error after database schema upgrade: Bug 31162 - Add primary key to erm_eholdings_packages_agreements Upgrade to 22.06.00.084 [10:30:33]: Bug 31162 - Add primary key to erm_eholdings_packages_agreements ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT erm_eholdings_packages_agreements_uniq, ADD PRIMARY K' at line 3 at /usr/share/koha/lib/C4/Installer.pm line 739 I don't quite understand this error. Could someone advise? Many thanks, Craig Butosi, MA, MLIS, B Mus (Hons) Library: library.craigbutosi.ca

1 0

Creating a database
by Thomas Daly 26 Feb '23

26 Feb '23

Hello, I'm following the 'Koha on Debian <https://wiki.koha-community.org/wiki/Koha_on_Debian> ' guide but have got stuck at the 'Create a Koha instance' part. This section doesn't say anything about supplying the 'koha-create' command with a MySQL username and password. I don't see how 'koha-create' can create the database if it doesn't know the MySQL root password. I tried putting the MySQL root login details in both /etc/koha/passwd and /etc/mysql/koha-common.cnf, but I get this error: # koha-create --create-db --passwdfile /etc/koha/passwd zilib WARNING: The koha-common.cnf file is a dead soft link! ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) koha-common.cnf is not actually a dead link but a text file. Can anyone help please?

1 0

2023 koha-US Annual Conference Location
by BRANNON, CHRISTOPHER 24 Feb '23

24 Feb '23

Happy Friday to all! I am pleased to announce that the votes are in and the location for the 2023 koha-US Annual Conference has been selected. This year we will be meeting at the Portsmouth Public Library, in Portsmouth, NH, which is scheduled for September 20th-23rd. Be sure to follow our 2023 Conference updates at https://koha-us.org/events/conferences/2023-koha-us-annual-conference-ports…. We will be updating the site this next month with more details. Sincerely, Christopher Brannon 2023 koha-US President

1 0

Request for proposals to host KohaCon 2024
by Caroline Cyr La Rose 24 Feb '23

24 Feb '23

Hello everyone! The request for proposals to host KohaCon 2024 is now open! If you or your organization would like to *organize KohaCon24*, please enter all the required information on the KohaCon 2024 proposal wiki page [1]: https://wiki.koha-community.org/wiki/KohaCon24_Proposals The closing date for bids is *4 April 2023 23:59 UTC*. Proposals received will be discussed at the *5 April 2023 General IRC Meeting* (https://wiki.koha-community.org/wiki/General_IRC_meeting_5_April_2023) Information about hosting KohaCon -------------------------------------------------- The community has agreed that KohaCon conferences must be either: - hybrid with an in-person conference streamed online, or - entirely online. This allows for greater accessibility, so that everyone can attend and learn from each other no matter their availability, ability to travel, or budget. For hybrid conferences, the rules for continent rotation apply. Therefore, for 2024, the following continents are eligible: - Africa - Asia - South America - Oceania For more information about the generally agreed rules established for KohaCons, see https://wiki.koha-community.org/wiki/Processes_for_KohaCons This covers the timetable, continent rotation, and information to help with planning a successful KohaCon. Deadline for proposals -------------------------------------------------- The closing date for proposals is *4 April 2023 at 23:59 UTC*. If there is more than one proposal, we will organize a vote - this will be announced on the mailing list. Help with your proposal -------------------------------------------------- The community stands behind anyone who volunteers to organize a KohaCon, and help is always available if you're unsure how to proceed. Send an email to the mailing list if you need help, or ask on IRC. There is a wealth of experience in the community from those who have attended and organized previous KohaCons (and other conferences). [1] If you do not have an account to edit the wiki, you can request one. It is usually pretty fast to get access. <https://inLibro.com/en> Caroline Cyr-La-Rose, M.L.I.S. Librarian | Product Manager P 833-INLIBRO (465-4276) <tel:833-465-4276>, poste 221 E caroline.cyr-la-rose(a)inlibro.com www.inLibro.com <https://inLibro.com/en>

1 0

Question on path for custom xsl files (OPAC and Staff client)
by Bruns, Anke 24 Feb '23

24 Feb '23

Hi, we have some settings of our own in some XSL files, e.g. /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/{langcode}/xslt/MARC21slim2O PACResults.xsl as well as for the staff client in e.g. /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/{langcode}/xslt/MARC21sli m2intranetResults.xsl All works fine when we copy and rename these files, keeping our own versions in /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/{langcode}/xslt/ resp. /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/{langcode}/xslt/ For us, however, it would be easier to store them in another place, e.g. (for the OPAC): /usr/share/koha/opac/htdocs/<our_directory>/<instancename>/{langcode}/xslt/ so we could hold all our files in one place (<our_directory), together with e.g. logos and other pictures etc, which we could easily tar and transport to another server when migrating an instance. But, alas, this doesn't seem to work - obviously the parameters XSLTDetailsDisplay, XSLTResultsDisplay, OPACXSLTDetailsDisplay and OPACXSLTResultsDisplay expect the files in the same directories as the standard versions. Is there any rule what paths are possible for our own xsl files/settings? Thanks in advance and best regards, Anke -- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns(a)gwdg.de --------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg(a)gwdg.de Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Norbert Lossau Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 --------------------------------------- Zertifiziert nach ISO 9001 ---------------------------------------

4 9

Koha 22.11.03 release
by Renvoize, Martin 23 Feb '23

23 Feb '23

Hello, Bonjour, Ola, Kia ora, 今日は, The Koha community is pleased to announce the release of version 22.11.03. This release is a bugfix/maintenance release with a small number of minor architectural enhancements to aid in the continued maintenance of this version. It includes 40 enhancements and 87 bugfixes. For full release notes, please visit https://koha-community.org/koha-22-11-03-released/ Thanks for anybody involved! 🚀 Martin Renvoize, MPhys (Hons) Head of Development and Community Engagement E: martin.renvoize(a)ptfs-europe.com P: +44 (0) 1483 378728 M: +44 (0) 7725 985636 www.ptfs-europe.com

1 0

Errors in the MARC bibliographic framework test: itemtype NOT mapped and subfields not in same tabs (UNIMARC)
by library＠ssst.edu.ba 23 Feb '23

23 Feb '23

Hello all, I am new to both Koha and Linux, and I have been trying to learn how to use both as I want our library to move from an in-house developed system to Koha. I am in Bosnia, and we use UNIMARC, so I chose that as my MARC flavor during the installation. When doing the MARC bibliographic framework test, I got two errors: itemtype NOT mapped the biblioitems.itemtype field MUST : - be mapped to a MARC subfield, - the corresponding subfield MUST have "Authorized value" set to "itemtype" subfields not in same tabs Not all subfields for the following tags are in the same tab (or marked 'ignored'). Code Description Tag Tabs in use Default framework 410 3,4 The tabs in use for all tags are tabs 3,4 and the tags are: 410 to 413 421 to 425 430 to 437 440 to 448 451 to 456 461 to 464 470 481 to 482 488 I'm not sure how to fix this error? What do I need to do? Best regards Aida Đikić

2 3

Volunteer needed to open the bidding for KohaCon24 & need confirmation of task list
by tuxayo 22 Feb '23

22 Feb '23

Hi :) The things to do are: - making the wikipage using the template - make an announcement email using past ones - send reminders - @all: anything else? The aim is to start the bid in the next weeks so proposals that start early 2024 have time to plan. And let the bid run until the next general meeting in april I can help with proofreading and finding past resources. (wikipage template, emails) Cheers, -- tuxayo

2 1

Problems setting up SIP2 in Koha
by Bob Ewart 21 Feb '23

21 Feb '23

I'm trying to set up SIP2 so we can purchase e-books from Palace Marketplace. So far they have not been able to connect. At first we were getting an XML error. There's a very long <login ... in the default SIPconfiguration.xml file which was deleted but not the following </login> I know they were getting in to our server because I could see the errors in the sip logs. When I deleted the </login> line, I updated a firewall rule in my firewall, IPFire, to log all incoming requests from their IP and port 6001. Now they aren't getting in. I just turned off the log request. The rule basically says that a TCP message from their IP and port 6001 should go to our server with that port. When I first tried the sip_cli_emulator, it complained about not finding the C4 libs so I ran: perl -I /usr/share/koha/lib /usr/local/sbin/sip_cli_emulator.pl -a localhost -p 6001 -su <AdminID>-sp <AdminPassword> -l SLA --patron<myID> --password <my password> -m patron_information and got: Attempting socket connection to localhost:6001...connected! Use of uninitialized value $hold_mode in string eq at /usr/local/sbin/sip_cli_emulator.pl line 120. SEND: 9300CN<AdminID>|CO<AdminPassword>|CPSLA| READ: 940 Login Failed! I know that both <AdminID>/<AdminPassword> and <myID>/<my password> are correct since I logged in to Koha with each of them. The sip.log is attached. I do wish that the sip_cli_emulator was in /usr/sbin with all the other koha... commands and properly setup so that it could find the C4 libs. Any suggestions? -- Bob

1 0

OPAC XSLT template: how to add text if the MARC field is not blank?
by King, Fred 21 Feb '23

21 Feb '23

Hi everyone, I'm editing the OPAC detail xslt file to display some extra fields. What I have now is this: <xsl:if test="marc:datafield[@tag=698]"> <xsl:if test="marc:datafield[@tag=698]/@ind1=' '"> Conference: </xsl:if> <xsl:for-each select="marc:datafield[@tag=698]"> <a><xsl:attribute name="href">/cgi-bin/koha/opac-search.pl?q=conference-name:"<xsl:value-of select="marc:subfield[@code='a']"/>"</xsl:attribute><xsl:value-of select="marc:subfield[@code='a']"/></a> <a><xsl:attribute name="href">/cgi-bin/koha/opac-search.pl?q=conference-name:"<xsl:value-of select="marc:subfield[@code='c']"/>"</xsl:attribute><xsl:value-of select="marc:subfield[@code='c']"/></a> <a><xsl:attribute name="href">/cgi-bin/koha/opac-search.pl?q=conference-name:"<xsl:value-of select="marc:subfield[@code='d']"/>"</xsl:attribute><xsl:value-of select="marc:subfield[@code='d']"/></a> <a><xsl:attribute name="href">/cgi-bin/koha/opac-search.pl?q=conference-name:"<xsl:value-of select="marc:subfield[@code='e']"/>"</xsl:attribute><xsl:value-of select="marc:subfield[@code='e']"/></a> <xsl:if test="position()!=last()"><xsl:text> | </xsl:text></xsl:if> </xsl:for-each> </xsl:if> Right now it appears on the details page as fieldafieldcfielddfielde. I'd like to add a comma between the fields. I tried adding <xsl:text>, </xsl:text>, but if there are fields a and e but no c and d, for example, the OPAC display comes out as fielda, , , fielde. Is there xsl for "if there's something in field c, then add a comma and a space, otherwise don't put anything there" so I can have fielda, fielde? It seems as if there ought to be one, but I haven't found it yet. Cheers, 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.

2 2