August 2019 - Koha - lists.katipo.co.nz

Sorry, your Google login failed
by tony.h 19 Jan '23

19 Jan '23

Greetings, I'm having trouble getting the Google login to work since upgrading/rebuilding Koha (we rebuilt the VPS and followed the install guide: https://wiki.koha-community.org/wiki/Debian) *The problem:* 1) I can log in through my local account, no problem. 2) I then try to login through my Google account 3) After pressing allow from the accounts.google.com site, a message is displayed: /Sorry, your Google login failed. .../ The full message is below. "Log in to your account Google login Sorry, your Google login failed. The email address you are trying to use is not associated with a borrower at this library. Please note that the Google login will only work if you are using the e-mail address registered with this library. If you want to, you can try to log in using a different account Log in with Google If you do not have a Google account, but do have a local account, you can still log in:" There are no errors in the Apache log files. *Configuration* Since we had troubles, I'm following the testing guide to configure the OAuth login: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10988#c68 I removed the Google OAuth entries: DELETE FROM systempreferences WHERE variable LIKE 'GoogleO%'; I then ran the upgrade schema tool, as I did when I imported the db: sudo koha-upgrade-schema keiin_lib I added values back in admin panel (Home › Administration › System preferences > Google OpenID Connect I confirmed the 4 values are displayed in the MySQL DB: SELECT * FROM systempreferences WHERE variable LIKE 'GoogleO%'; Any thoughts? Tony -- View this message in context: http://koha.1045719.n5.nabble.com/Sorry-your-Google-login-failed-tp5895227.… Sent from the Koha-general mailing list archive at Nabble.com.

5 5

Location of tag 245$c in koha database
by vinod mishra 30 Jul '21

30 Jul '21

Dear All, May i know the location of marc tag 245$c im koha database/table, i wish to get the report of the same. With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website: http://mishravk.com/ ORCID ID: http://orcid.org/0000-0003-4666-7874 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

3 4

Check-in Receipt
by Mubassir Ahsan 15 Feb '21

15 Feb '21

Is there any way to print check-in receipt in koha. *Best wishes.--------------------Md. Mubassir Ahsan* *Library In-Charge* Southeast University Phone: +8801916303060 Email: mahsandu(a)gmail.com Facebook: mmahsan <http://facebook.com/mmahsan> Skype: mahsandu Twitter: mahsandu

4 4

double fines
by Margo Duncan 31 Jan '20

31 Jan '20

Good afternoon, Recently we have some patrons that are being double charged fines. It looks like when the item is turned in, the accruing fine (FU) remains and a fine (F) for the same amount is added as a second line. It doesn't appear to be happening to all patrons and I cannot determine a pattern. We are on version 18.11.02. Has anyone had this problem? Or any suggestions where to start looking? Thank you! Margo Margo Duncan, MLS Head of Library Systems Robert R. Muntz Library The University of Texas at Tyler 903.566.7174 | mduncan(a)uttyler.edu<mailto:mduncan@uttyler.edu>

8 13

change of domain name
by glernil evangelista 13 Jan '20

13 Jan '20

Good day! How can I change the domain name of a koha instance? I have a Koha 12.0 installed using debian repository.

4 3

Show analytics
by Petritsch Barbara 28 Dec '19

28 Dec '19

Dear Koha Community, I am a new koha user and have browsed your lively communication. It is good to see that this is a fine worling community. Mirko Tietgen has set up our application and is hosting and maintaining it. I don't want to bother him with every little problem I have though. So here comes my first issue: When linking to records I use the 773 to link the child record tot he parent record. This works just fine. Linking back to the child record (show analytics; Zeige unslebstständige Werke) from the parent record doesn't work regularly. I couldn't find out why it sometimes does or why it doesn't. Did anybody have the same issue and found the solution? I am happy with any clue. Best, Barbara Barbara Petritsch Bibliothek Museen der Stadt Wien Wien Museum 1040 Wien, Karlsplatz Liefer- und Büroadresse während der Sanierung am Karlsplatz: Arcade Meidling Eingang Wilhelmstraße 64, 3.OG Portier 1120 Wien T: +43 (0)1 505 87 47 84038 M: +43 (0)664 8829 3884 E: barbara.petritsch(a)wienmuseum.at W: www.wienmuseum.at

2 1

Invitation for Libraries using Koha to participate in the 2018 Library Automation Perceptions survey
by Marshall Breeding 18 Nov '19

18 Nov '19

To all libraries using Koha: I'm collecting data for the 2018 International Library Automation Perceptions survey. This survey, now in its twelfth annual iteration, provides an opportunity for libraries to register their perceptions of the strategic automation products they use, organizations that provide these products, and the quality of support delivered. The survey also probes at considerations for migrating to new systems and the level of interest in open source products. As open source software supported both by the general community and by a variety of different service organizations, some special considerations apply to Koha. In the libraries.org directory, Koha is represented by a combination of the name Koha and the primary support organization involved. (For example Koha - Catalyst IT, Koha -- ByWater Solutions). Libraries relying entirely on community support or internal resources are represented as Koha - Independent. If there are any special support arrangements not covered by these conventions, just mention that in the comments area of the survey. In this way the survey will be able to reflect both the functionality of the Koha software and the quality of support provided. This model of representing libraries using Koha isn't ideal, but is a pragmatic approach that aggregates all users of Koha while also segregating the different support scenarios. Participation in this survey will help amplify the visibility of Koha among those interested in library automation. While the numeric rating scales support the statistical results of the study, it's the comments offered that provide the most insight into the current state of library automation satisfaction. Comments will be published in the survey results, redacted to conceal text that might identify the individual or organization responding. The raw data for the survey will not be shared, but reports are available that provide a variety of ways to view results. Please help your fellow librarians who might be in the process of evaluating library automation options by responding to the survey. Any information regarding vendor performance and product quality can be helpful when making strategic decisions regarding automation alternatives. A large number of responses strengthen the impact of the survey and the subsequent report. If you have responded in previous years, please respond again this year to help identify any trends regarding improvement or worsening of the products or support services. For more information about the survey, for instructions on how to participate, and to see results of previous year's survey reports, see: http://librarytechnology.org/web/breeding/AutomationSurvey/ I hope that all libraries using Koha will respond. Feel free to forward this request to any other library-related list. You can view the report summarizing the results of last year's survey, including data from all previous editions, here: https://librarytechnology.org/perceptions/2017/ Please let me know if there are any questions regarding the survey. Marshall Breeding Editor, Library Technology Guides www.librarytechnology.org Marshall.breeding(a)librarytechnology.org twitter.com/mbreeding

1 1

Incomplete import of framework
by Michael Kuhn 21 Oct '19

21 Oct '19

Hi There seems to be a problem when trying to import a framework. As usual when creating a new framework I did export the standard framework in XML format, created a new framework ABC and the imported the XML file into the new framework ABC. I tried to do this in virgin installations of Koha 18.11.04 and Koha 19.05.00 but instead of importing all 345 MARC fields, only 102 were actually imported. Is this a bug or did I miss something? However, I then tried to export and import a CSV file which worked as expected. 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

3 4

Koha upgrade 3.18.11 --> 3.20.07
by Bortel, Gary 16 Oct '19

16 Oct '19

I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised? The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3 . . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data) DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614. Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4) Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7 release) gcb ______________________ Gary C. Bortel IT Services Manager, Library Development Program Office of the Secretary of State, Washington State Library 6880 Capitol Boulevard Southeast P.O. Box 42460 Olympia, WA 98501-2460 gary.bortel(a)sos.wa.gov<mailto:gbortel@secstate.wa.gov> voice: 360.570.5588 fax: 360.586.7575 Washington State Library: Empowering 21st Century Washington

9 22

Report help needed - lost items
by Elaine Bradtke 05 Oct '19

05 Oct '19

I've got the following adapted from one in the reports library. But I need to limit it by item type, or not return everything that doesn't have an item record attached. We've got lots of components in our catalogue that don't have items and it's returning all of them: SELECT CONCAT( '<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=', bib.biblionumber, '\">', bib.title, '</a>' ) AS Title, bib.title, bib.biblionumber, lostitems.barcode, lostitems.ccode, lostitems.onloan AS 'Checkout date' FROM biblio bib LEFT JOIN items ON (bib.biblionumber = items.biblionumber AND items.itemlost = 0) LEFT JOIN items AS lostitems ON (bib.biblionumber = lostitems.biblionumber AND lostitems.itemlost != 0) GROUP BY bib.biblionumber HAVING count(items.itemnumber) = 0 Thanks! Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999

4 4