- Koha - lists.katipo.co.nz

Upgrade to 21.11 Fails
by Bruce A. Metcalf 16 Mar '23

16 Mar '23

Greetings, Yes, I'm slow on the uptake, I've been running oldoldstable for some time now. With the release of 22.11, it's time for me to move up. My system was installed from deb packages under Debian 10, and has been updating fine. After an update (with no error messages), I find I am unable to access either the OPAC or the admin interfaces. Both give an "Internal Server Error" message, with a note that a 500 error was thrown by the ErrorDocument handler as well. Probably something simple, but not something I can see or find in the release notes. Help! Regards, / Bruce / Bruce A. Metcalf Augustan Library

6 16

Circulating non-specific items
by Caroline Cyr La Rose 16 Mar '23

16 Mar '23

Hello everyone! I need to pick the collective brain about a question I received from one of our libraries. They are a toy/game library. For games and books, they circulate items normally. However, they have some toys in many copies and they don't need to or want to have a specific barcode for each copy of a particular toy. They gave me the example of dinosaur figurines. They have 60+ dinosaur figurines, but they don't need to know that *this exact* dinosaur figurine went home with this patron. They just need to know that *a* dinosaur figurine went home with this patron. They want to avoid having barcodes for each dinosaur. Right now, they manage this in a spreadsheet, but would like to manage it in Koha with the rest of their inventory. Do any of you have a similar situation? If so how do you manage those items? Thank you so much! Caroline Cyr-La-Rose, M.L.I.S. Librarian | Product Manager 1-833-INLIBRO (465-4276), ext. 221 caroline.cyr-la-rose(a)inlibro.com https://www.inLibro.com

5 6

Adapting MARC frameworks and deleting unneeded tags
by library＠ssst.edu.ba 16 Mar '23

16 Mar '23

Hello all, Today I have another question for you regarding MARC frameworks and cataloging different items. While I wait for our IT to export the cataloged textbooks from our current system, I've been refreshing my knowledge on UNIMARC, going through the exported theses (2008-2018; for later ones I don't have an exported csv file yet) and trying to work out how best to adapt the MARC framework so they can be imported. I've also been looking up the mail archive to see how others have dealth with cataloging theses - if any of you could share your practice I'd be grateful! I downloaded the Books, Booklets, Workbooks framework I adapted from the Default framework, and in going through the tags I saw there were many I would never use; would these be OK to delete? I mean tags such as 20 Fingerprint Identifier, 21 Legal Deposit Number, or 36 Music Incipit, and others. For the eventual Theses framework, I also would not need tags such as 10 International Standard Book Number (ISBN) or 11 International Standard Serial Number (ISSN) and many other, but would need a tag where I could list the student mentor for that particular thesis. I'd also like to add a Serial publications framework. Would I actually be safe in deleting these tags, or is there a better way to handle them? In my earlier efforts to add Z39.50 servers, I tested adding a title I had in hand, but I am being prevented from saving it since some of the tags were blank upon import and I wasn't sure how to fill them out. 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: Wednesday, March 15, 2023 12:00 AM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 209, Issue 15 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..."

3 4

How to get sql report on patron additional attributes.
by MASTeR Library 16 Mar '23

16 Mar '23

Dear Team, how to get the sql report on Patron additional attributes for example Department, Student Roll number, blood group and etc? Sample SQL Code. SELECT ROW_NUMBER() OVER (ORDER BY LPAD(borrowers.cardnumber,100,' ') ASC) AS 'S.No', borrowers.cardnumber AS "Lib Membership No",borrowers.borrowernumber,borrowers.surname AS " Name",borrowers.title,borrowers.sex,borrowers.dateofbirth AS " Date of Birth",borrowers.contactname AS "Guardian Name", borrowers.relationship, borrowers.phone,borrowers.email,borrowers.address,borrowers.categorycode,borrowers.dateenrolled,borrowers.dateexpiry,borrowers.userid FROM borrowers WHERE branchcode=<<Enter patrons library|branches>> AND categorycode LIKE <<Select User category|categorycode>> -- Thanking you.. Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105.

2 1

Re: [Koha] Koha Export Data Options
by Jonathan Druart 16 Mar '23

16 Mar '23

Please reply to the list. Which exact version of Koha? 22.05.XX? It is missing the last part. Le jeu. 2 mars 2023 à 09:01, Ms. Naveen Ali <naveen(a)neduet.edu.pk> a écrit : > Hi. > Sorry for the incomplete information I am using Koha 22.05 > > Error log shows > > [Thu Mar 02 13:00:04.468545 2023] [cgi:error] [pid 40831] [client > 192.168.14.235:63827] AH01215: Use of uninitialized value $record_type in > string eq at /usr/share/koha/intranet/cgi-bin/tools/export.pl line 43.: > /usr/share/koha/intranet/cgi-bin/tools/export.pl, referer: > http://192.168.14.237:8001/cgi-bin/koha/tools/tools-home.pl > > Thanks. > > *With best regards,* > > *Naveen Ali* > > ** > *ITM-JE (EAKL)* > *Inst Representative for * > *HEC Digital Library Resources.* > *NEDUET, Karachi.* > > > > ------------------------------ > *From: *"Jonathan Druart" <jonathan.druart(a)bugs.koha-community.org> > *To: *"Ms. Naveen Ali" <naveen(a)neduet.edu.pk> > *Cc: *"Koha" <koha(a)lists.katipo.co.nz> > *Sent: *Thursday, 2 March, 2023 12:43:55 PM > *Subject: *Re: [Koha] Koha Export Data Options > > Hi, > > Which version of Koha? > > Do you see an error in the Koha log files? > > Regards, > Jonathan > > Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali <naveen(a)neduet.edu.pk> a > écrit : > >> Dear All, >> >> I use Koha Tools-> Export Data->Export Database Option to download dump >> of Koha database. >> >> I have a large database with over 150000 books and 8,000 patron records. >> The dump was a large file around 400MB. >> >> Suddenly the dump file now generated is just 1KB. >> >> Sharing contents of file >> -------------------------------------------------------------------------------------------------------------------------------------------- >> >> -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64) >> -- >> -- Host: localhost Database: koha_library >> -- ------------------------------------------------------ >> -- Server version 8.0.32-0ubuntu0.20.04.2 >> >> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; >> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; >> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; >> /*!50503 SET NAMES utf8mb4 */; >> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; >> /*!40103 SET TIME_ZONE='+00:00' */; >> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; >> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, >> FOREIGN_KEY_CHECKS=0 */; >> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' >> */; >> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; >> >> ----------------------------------------------------------------------------------------------------------------------------------------------------- >> >> >> No data in the file. I can't understand the reason for this. Can you >> please help. >> >> With best regards, >> >> Naveen Ali >> >> ITM-JE (EAKL) >> Inst Representative for >> HEC Digital Library Resources. >> NEDUET, Karachi. >> >> >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > >

2 3

Overdue Notices and Advance notices not being run by crontab
by Ms. Naveen Ali 16 Mar '23

16 Mar '23

Dear all, Hope this finds you well. I have configured overdue notices to be run from Tools Overdue Notices triggers. My problem is that the cronjob overdue_notices is not being run automatically. The koha-common file in /etc/cron.daily shows the lines koha-foreach --chdir --enabled --email /usr/share/koha/bin/cronjobs/overdue_notices.pl -t koha-foreach --chdir --enabled --email /usr/share/koha/bin/cronjobs/advance_notices.pl -c When i check the logs of cron jobs, all the scripts are listed except the above two. I can run the scripts manually and the result is that the emails are queued. How do I resolve this problem that the scripts are run automatically along with all the others With best regards, Naveen Ali ITM-JE (EAKL) Inst Representative for HEC Digital Library Resources. NEDUET, Karachi.

2 2

KOHA Upgrade fails from v20.05 to v22.11
by zen zenitram 15 Mar '23

15 Mar '23

Good day! Anyone encountered this kind of error while upgrading KOHA? Upgrading database schema for lrc Upgrade to 22.06.00.063 [05:39:06]: Bug 31569 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31569> - Add primary key for import_biblios ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '11545' for key 'import_biblios.PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739 and this one ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '24064' for key 'import_biblios.import_biblios_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 739 need help with this. THank you!

2 1

Integration with ABW (Agresso).
by Raymund Delahunty 15 Mar '23

15 Mar '23

University of the Arts London is investigating integrating our 21.11 Koha with Agresso. Anyone else done this? Any comments? Views? How bad, how painful was it? I've looked in the mail archives but not found any mention of a Koha - Agresso (ABW) integration. . This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY

1 0

Adding Z39.50 servers
by library＠ssst.edu.ba 14 Mar '23

14 Mar '23

Hi all, I'm currently reading up on using Z39.50 servers, and looking up prior messages in the archives. I added (presumably correctly) the Jisc Library Hub server using the data given at https://discover.libraryhub.jisc.ac.uk/support/api/#z3950 and even though I can see there is a catalog entry for the book "Computer architecture : a quantitative approach", ISBN 9780123838728, the only thing that comes up when I try adding it using New from Z39.50/SRU is the following message: You searched for: ISBN: 9780123838728 LIBRARY OF CONGRESS record 1: 239 DISCOVER.LIBRARYHUB.JISC.AC.UK record 1: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 2: 238 Nothing found. When I look it up by title, I get You searched for: Title: Computer architecture : a quantitative approach DISCOVER.LIBRARYHUB.JISC.AC.UK record 1: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 2: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 3: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 4: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 5: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 6: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 7: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 8: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 9: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 10: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 11: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 12: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 13: 238 DISCOVER.LIBRARYHUB.JISC.AC.UK record 14: 238 plus the option to import one of 7 records from the National Library of France. Neither of them is the correct edition (I have the 5th ed.). I'm not sure why this is happening, and what I need to do to import the record as it exists on discover.libraryhub.jisc.ac.uk. Have any of you come accross something like this? Best regards Aida Đikić Librarian Sarajevo School of Science and Technology<https://ch1prd0106.outlook.com/owa/redir.aspx?C=iu4F3prvKk26qlF7uQhmd7OEU2z…> Hrasnička Cesta 3A <https://ch1prd0106.outlook.com/owa/redir.aspx?C=iu4F3prvKk26qlF7uQhmd7OEU2z…>Ilidža 71210 Bosnia and Herzegovina Work: +387 33 975-026 Fax: +387 33 975-030

3 4

Internal Server Errors
by Paul 13 Mar '23

13 Mar '23

I recently reported that we'd started to get internal server errors when looking at ISBD detail and making a hold when in the OPAC. Jonathan Druart asked if I'd run misc/maintenance/ search_for_data_inconsistencies.pl to catch potential problems with our data. There were numerous errors with respect to home branch and/or holding branch which I corrected. We've run search_for_data_inconsistencies.pl again and no problems are reported. We're still getting internal servers errors when looking at ISBD detail and making a hold when in the OPAC. Is there anything else I can check? We've also seen that the plack-error.log has a continuously generated error: DBD::mysql::db selectrow_array failed: Unknown column 'LOST' in 'field list' [for Statement "SELECT LOST from items where itemnumber = ?"] at /usr/share/koha/lib/C4/Items.pm line 1229. -- Paul Leman

4 3