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

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

18 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

Remove Not For Loan / Available distinctions
by Elaine Bradtke 26 Aug '20

26 Aug '20

We've been running Koha for a while, but have a new person in charge and they (correctly) pointed out that displaying Available / Not Available status for a collection that's 99% reference only is useless and possibly confusing. Is there an easy way to switch this display off? A quick look round the preferences didn't show anything. We're trying to avoid custom configurations because we've got very minimal, volunteer support. Right now, just about everything shows up as 'not available' even though it's sitting right there on the shelf. 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

2 3

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

(PTFS customer) Bywater recalls plugin configured but staff side recall item symbol not showing on 18.11
by Perks, Emma (UNIVERSITY HOSPITALS BIRMINGHAM NHS FOUNDATION TRUST) 30 Jan '20

30 Jan '20

?Hello, We have the item recalls plugin version 1.0.26 installed and recall rules set up. The circulation rules are set up for item level holds and hold notices are ending with the reserves.reserve_id code. On the staff client when an item is checked out with an item level hold placed, there isn't a manual recall button anywhere on the patron record. My vendor PTFS cannot support the plugin and I cannot verify whether we have the code added to the Apache config. ? ?Does anyone know what needs to be done to display the manual recall button? Many thanks, Kind rgeards, Emma Perks Area Systems Librarian Tel: +44 (0) 121 424 9824 Email 1: baselibrary.consortium(a)nhs.net<mailto:emma.perks@heartofengland.nhs.uk> Email 2: emma.perks(a)heartofengland.nhs.uk<mailto:emma.perks@heartofengland.nhs.uk> Web: http://www.base-library.nhs.uk BASE Library Consortium ******************************************************************************************************************** This message may contain confidential information. If you are not the intended recipient please inform the sender that you have received the message in error before deleting it. Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation. NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services. For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail

2 4

Reporting on 942$c
by Coehoorn, Joel 20 Jan '20

20 Jan '20

I'm working on a report, and I'd like to see data related to the 942$c field. We want to look at instances where it's different than 952$y, and validate these. Where (if anywhere) is this field stored in the database? I can't find it. It doesn't seem to always match either item.itype or biblioitem.itemtype. Joel Coehoorn Director of Information Technology 402.363.5603 *jcoehoorn(a)york.edu <jcoehoorn(a)york.edu>* *Please contact helpdesk(a)york.edu <helpdesk(a)york.edu> for technical assistance.* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society

4 10

Re: [Koha] Software error: Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627.
by Tadesse, Bruck 19 Jan '20

19 Jan '20

Hi Katrin, Thanks, I have never used a client for IRC, but I will try pidgin. What would be the address then? Is it irc.oftc.net:6667 ? thanks, Bruck T From: Katrin Fischer <Katrin.Fischer.83(a)web.de> Sent: Thursday, December 19, 2019 12:21 PM To: Tadesse, Bruck <bruck(a)wider.unu.edu> Cc: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org>; koha(a)lists.katipo.co.nz Subject: Aw: Re: [Koha] Software error: Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. Hi Bruck, the web link hasn't worked for me in a while - the #koha tab doesn't open and only the status one is shown for me. Do you have access to a program like pidgin or another IRC client maybe that you could use instead? Katrin Gesendet: Donnerstag, 19. Dezember 2019 um 11:03 Uhr Von: "Tadesse, Bruck" <bruck(a)wider.unu.edu<mailto:bruck@wider.unu.edu>> An: "Jonathan Druart" <jonathan.druart(a)bugs.koha-community.org<mailto:jonathan.druart@bugs.koha-community.org>> Cc: "koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>" <koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>> Betreff: Re: [Koha] Software error: Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. Hi Jonathan, I have been connected to this Koha channel (https://webchat.oftc.net/?channels=koha) through a browser for a while now, but I do not see any activity. May be I am not in the right, Can you send me the link to the right channel. Many thanks, Bruck T. -----Original Message----- From: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org<mailto:jonathan.druart@bugs.koha-community.org>> Sent: Wednesday, December 18, 2019 6:36 PM To: Tadesse, Bruck <bruck(a)wider.unu.edu<mailto:bruck@wider.unu.edu>> Cc: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Subject: Re: [Koha] Software error: Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. I am expecting to see something just before this error. Maybe you did not restart plack? Consider jumping into IRC and catch me there, that would be easier ;) Le mer. 18 déc. 2019 à 17:09, Tadesse, Bruck <bruck(a)wider.unu.edu<mailto:bruck@wider.unu.edu>> a écrit : > > Jonathan, > I am not sure if I am looking in the right place and thanks for your patient with me. I opened the " intranet-error.log " log file (tail -f intranet-error.log) in the backend and see the result below. Could this be any helpful. > > Thanks. > Bruck.- > ********************************* > [Wed Dec 18 15:59:18.279781 2019] [cgi:error] [pid 19666] [client > 172.22.3.115:59956] AH01215: [Wed Dec 18 15:59:18 2019] additem.pl: > Can't call method "branchname" on an undefined value at > /usr/share/koha/lib/C4/Biblio.pm line 1627.: > /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: > http://koha.wider.unu.edu:8080/cgi-bin/koha/catalogue/detail.pl?biblio > number=8418&searchid=scs_1576671122887 > > ********************************* > -----Original Message----- > From: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org<mailto:jonathan.druart@bugs.koha-community.org>> > Sent: Wednesday, December 18, 2019 3:15 PM > To: Tadesse, Bruck <bruck(a)wider.unu.edu<mailto:bruck@wider.unu.edu>> > Cc: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> > Subject: Re: [Koha] Software error: Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. > > Have a look at the Koha log file, you should see the value of $value in it. > > Le mer. 18 déc. 2019 à 13:23, Tadesse, Bruck <bruck(a)wider.unu.edu<mailto:bruck@wider.unu.edu>> a écrit : > > > > Jonathan, > > > > Thanks, the SQL query returns empty set. I have also added the debug statement just before the line 1627 and there is no change to the error message. Thinking it is a browser cache issue, I changed computer and browser, the debug statement didn’t bring any change to the error message. > > > > This is how it looks now in ...C4/biblio.pm > > #---- branch > > if ( $tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) { > > warn $value; > > return Koha::Libraries->find($value)->branchname; > > } > > > > Thanks, > > Bruck T. > > > > -----Original Message----- > > From: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org<mailto:jonathan.druart@bugs.koha-community.org>> > > Sent: Wednesday, December 18, 2019 1:22 PM > > To: Tadesse, Bruck <bruck(a)wider.unu.edu<mailto:bruck@wider.unu.edu>> > > Cc: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> > > Subject: Re: [Koha] Software error: Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. > > > > Bruck, > > > > My understanding of the error is that you have a field that is mapped with the "authorised value" branches (that's not a real authorised value). But at least one of those field has a value that is not a branchcode defined in your system. > > > > The weird thing is that, by default, only item's fields are mapped with "branches", 952$a and 952$b Can you try this SQL query: select tagfield, tagsubfield from marc_subfield_structure where authorised_value="branches" and tagfield != 952; Does it return something? > > > > To know which value we are searching search, you could also add a debug statement > > warn $value; > > before > > 1627 return Koha::Libraries->find($value)->branchname; > > > > Regards, > > Jonathan > > > > Le mer. 18 déc. 2019 à 11:37, Tadesse, Bruck <bruck(a)wider.unu.edu<mailto:bruck@wider.unu.edu>> a écrit : > > > > > > Dear Karam, > > > > > > Thanks, Since the update didn’t result in solving the problem, I will revert back for now. I have taken a snapshot of the VM, so it easy to do that. I would still appreciate any advice that would help me resolve the underlying problem of updating the items. > > > > > > Thanks, > > > Bruck T. > > > > > > From: Karam Qubsi <karamqubsi(a)gmail.com<mailto:karamqubsi@gmail.com>> > > > Sent: Wednesday, December 18, 2019 12:26 PM > > > To: Tadesse, Bruck <bruck(a)wider.unu.edu<mailto:bruck@wider.unu.edu>> > > > Cc: koha(a)lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>; Allonen, Lay Poh > > > <allonen(a)wider.unu.edu<mailto:allonen@wider.unu.edu>> > > > Subject: Re: [Koha] Software error: Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. > > > > > > Hello Bruck, > > > > > > This query (UPDATE items SET homebranch='LIB', holdingbranch='LIB') ) is very dangerous. > > > > > > This will set all (homebranch and holdingbranch ) in your items table to be LIB for all items! > > > > > > if that is not what you want, then try to retrieve a backup from ( /var/spool/koha ) or anywhere else you store your backups . > > > > > > Please note that LIB should be one of your branches custom code. so are you sure it is LIB in your Koha installation ? > > > Regards. > > > > > > On Wed, Dec 18, 2019 at 5:27 PM Tadesse, Bruck <bruck(a)wider.unu.edu<mailto:bruck@wider.unu.edu<mailto:bruck@wider.unu.edu%3cmailto:bruck@wider.unu.edu>>> wrote: > > > Hi All, > > > > > > I have just recently upgraded to 17.05 from 16.05 and when I try to edit items on Koha, it throws the following error "Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627". I search the archive online saw the advice to update the two fields<https://lists.katipo.co.nz/public/koha/2017-September/048966.html> (UPDATE items SET homebranch='LIB', holdingbranch='LIB'). I have done that and did the full reindex. But, that does not seem to have helped. Please advise. > > > > > > Many thanks, > > > Bruck Tadesse > > > _______________________________________________ > > > Koha mailing list http://koha-community.org > > > Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz%3cmailto:Koha@lists.katipo.co.nz>> > > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > -- > > > Karam Qubsi > > > > > > _______________________________________________ > > > Koha mailing list http://koha-community.org > > > Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha

2 7

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

Duplicate Fine Issue in Checkin
by Laxmi Lal Menaria 12 Jan '20

12 Jan '20

Hello, We are using Koha 17.11 and Default fine calculation settings. When I see the Fine details are check-in, I found the fine is some time double and some time 3 times, the fine report also shows the same result. Please let me know how to fix this duplicate fine issue. -- Thanks, Laxmilal Menaria | +91 982 955 3793 | https://cloud-computing.solutions/ <http://laxmilalmenaria.com/>

2 3