April 2017 - 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

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

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

Problem uploading patrons
by Elaine Bradtke 26 Aug '19

26 Aug '19

We're running 3.18.04. One (and only one) of my colleagues is unable to upload patron files. It's very curious, she has all the permissions, and I and another colleague have uploaded the same file without a problem. I have even logged into her account and uploaded the file successfully. But whenever she tries she gets a long string of error messages that boil down to Koha not parsing the header row. I've asked her to clear her browser (Firefox) history and cookies (there's an 8 hour time difference so I won't know if this works til tomorrow) Other than that I don't know why she can't do it and we can. Any ideas what might be causing the problem? -- Elaine Bradtke Data Wrangler 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 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

9 14

Add pictures in notices
by BOUIS Sonia 03 Jul '18

03 Jul '18

Hello, Do you have any tip to add pictures in notices template. I've seen that we could add a picture in branches.opac_info but it isn't sufficient for us. We want to use discharge notices but we need to insert a signature in it to make it "official" for other universities. I would like to insert a signature picture in the discharge notice template but I don't see how to do.. Thanks in advance, Cheers Sonia BOUIS Responsable du Service des application documentaires BIBLIOTHÈQUES UNIVERSITAIRES Bibliothèque de la Manufacture UNIVERSITÉ JEAN MOULIN LYON 3 1C AVENUE DES FRÈRES LUMIÈRE CS 78242 69372 LYON CEDEX 08 ligne directe : +33 (0)4 78 78 79 03 http://bu.univ-lyon3.fr<http://bu.univ-lyon3.fr/> L'Université Jean Moulin est membre fondateur de l'Université de Lyon

4 4

Software error: Biblionumber
by Peter Feingundez 08 Jan '18

08 Jan '18

hi, i am a new koha-developer. I have a problem with my koha system, but i can´t understand it. I created one new MARC Framework changing some fields and one new item type for it. When i try to add one new record using this framework, i get this : Software error: No biblionumber tag for framework "MTS" at /usr/share/koha/lib/C4/Biblio.pm line 3135. What should i do? Thx. -- View this message in context: http://koha.1045719.n5.nabble.com/Software-error-Biblionumber-tp5747673.html Sent from the Koha-general mailing list archive at Nabble.com.

6 5

ERROR LOADING MODULE: Date::Manip::DM6
by Federico Leva (Nemo) 03 Dec '17

03 Dec '17

Hello! I'm trying Koha on a small fedora 23 virtual machine for testing (500 MB RAM, 1 core) and I often get this error in the web interface: ---- Software error: ERROR LOADING MODULE: Date::Manip::DM6 at /usr/share/perl5/vendor_perl/Date/Manip.pm line 34. Compilation failed in require at /usr/share/perl5/vendor_perl/C4/Overdues.pm line 25. BEGIN failed--compilation aborted at /usr/share/perl5/vendor_perl/C4/Overdues.pm line 25. Compilation failed in require at /usr/share/perl5/vendor_perl/C4/Members.pm line 29. BEGIN failed--compilation aborted at /usr/share/perl5/vendor_perl/C4/Members.pm line 29. Compilation failed in require at /usr/share/perl5/vendor_perl/C4/Search.pm line 28. BEGIN failed--compilation aborted at /usr/share/perl5/vendor_perl/C4/Search.pm line 28. Compilation failed in require at /usr/share/perl5/vendor_perl/C4/AuthoritiesMarc.pm line 24. BEGIN failed--compilation aborted at /usr/share/perl5/vendor_perl/C4/AuthoritiesMarc.pm line 24. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 32. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 32. ---- The error is always identical and goes away with a refresh. When it happens I see I have less than 10 MB free memory so it really just seems a resource issue. I'll give Koha more memory :) but let me know if I missed something obvious. Federico (BEIC)

2 2

Software error: Koha Web Installer-MARC21
by bwengu 08 Oct '17

08 Oct '17

Hello, I am installing Koha on Ubuntu 16 and I have managed to go through everything until on *stage 3* where after selecting *mandatory* and *optional options* I get a *software error*. The error am getting is; DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: '' for column 'suggestible' at row 1 at /usr/share/koha/lib/Koha/SearchField.pm line 38 or DBIx::Class::Storage::DBI::_dbh_execute(): Data truncated for column 'type' at row 1 at /usr/share/koha/lib/Koha/Objects.pm line 101 Please hep me because am stack -- View this message in context: http://koha.1045719.n5.nabble.com/Software-error-Koha-Web-Installer-MARC21-… Sent from the Koha-general mailing list archive at Nabble.com.

7 7

Koha 16.11.04 - Setting a template cache directory
by Craig Butosi 01 Sep '17

01 Sep '17

Colleagues, I just upgraded my test server to 16.11.04 (on Ubuntu 16.04), checked the Koha System Information under About, and saw the following: >You are missing the <template_cache_dir> entry in your koha-conf.xml file. That will bring a performance boost to >enable it. Is there an expected, standard, or best directory path to use? The error is clear enough; however, I'd like to define the directory with an appropriate path. Suggestions? Many thanks! Craig Butosi, MA, MLIS, B Mus (Hons.) LIBRARY SERVICES MANAGER the royal conservatory TELUS Centre for Performance and Learning 273 Bloor Street West Toronto, ON M5S 1W2 416.408.2824 x338 www.rcmusic.ca<https://webmail.rcmusic.ca/owa/redir.aspx?C=b481823b299d45ee94b0016389bb76e…> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.

7 10

All items "not renewable"
by Michael Kuhn 19 Jul '17

19 Jul '17

Hi Using Koha 16.11.04 (via Debian package installation) on Debian 8 I encounter the following problem. In Koha menu "Administration > Circulation and fine rules" a single rule for all patron categories and all item types was defined. The rule includes: * Renewals allowed (count): 3 * Renewal period: 19 * No renewal before: [empty] * Automatic renewal: No * No automatic renewal after: [empty] However, when looking at the actual checkouts of any user, the column "Renew" always says "Not renewable (0 of 0 renewals remaining)" for every single item. Instead I would expect to see "Renewable (0 of 3 renewals remaining)". Restarting Koha / Plack and clearing the webbrowser's cache doesn't change a thing, unfortunately. How is this possible, why are all my items "not renewable"? Kind regards, Michael

3 6