- Koha - lists.katipo.co.nz

Time slots for hold pickups
by Stephen Graham 21 Jul '20

21 Jul '20

Hi All - I've noticed that some Libraries, who have started to offer a "Click& Collect" service, have introduced time slot functionality i.e. you decide the day and a set time that you would like to collect the items. Obviously you would only want X users choosing a certain time, and an easy way for users to pick the time slot and see when is available. Just wondering if Koha supports anything like this? I can't see anything in the docs or a system preference. Anybody on the list offering such a service? Stephen -------------------------------------- Stephen Graham Library Technology Consultant Content and Collections Team Library and Computing Services University of Hertfordshire Tel: 01707 286111 Ext: 77751 Email: s.graham4(a)herts.ac.uk<mailto:s.graham4@herts.ac.uk>

3 2

Schema upgrade issue 16.11 to 20.05
by vinod mishra 20 Jul '20

20 Jul '20

Hello While restoring Koha 16.11 from Mysql database to 20.05 Mariadb 10.03 database found below warning during database schema upgrade. Please suggest the possible problem or it can be ignored? Upgrade to 16.12.00.003 done (Bug 17486 - Remove 'Mozilla Persona' as an authentication method) DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`deletedbiblio_metadata`, CONSTRAINT `deletedbiblio_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `deletedbiblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement " INSERT INTO deletedbiblio_metadata ( biblionumber, format, marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM deletedbiblioitems; "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/ updatedatabase.pl line 13816. With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 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*

2 2

multilingual opac nav
by Alvaro Cornejo 19 Jul '20

19 Jul '20

Hi Is there a way to have the opac nav bottom show content in the appropriate user language? ie if the user selects spanish, show content in spanish, and if he changes it to another language show content in the new language? I guess I´ll need some JS, first to detect language selected and the other js to show the correct text. Is that right? A basic example would be nice Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire

1 1

General Query
by Sanjay Uchcharia 19 Jul '20

19 Jul '20

Hello there, How would I find/see my Koha z39.50 target? Sincerely Sanjay Uchcharit Bhopal, Madhya Pradesh, India

2 1

Re: [Koha] Koha Digest, Vol 177,
by Joseph Longshak 19 Jul '20

19 Jul '20

On Sun, Jul 19, 2020, 1:01 AM <koha-request(a)lists.katipo.co.nz> wrote: > 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..." > > > Today's Topics: > > 1. Re: Error message in Koha (Mason James) > 2. Re: Unable to create patron (Katrin Fischer) > 3. Re: Unable to create patron (Alvaro Cornejo) > 4. Re: Unable to create patron (Michael Kuhn) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 18 Jul 2020 23:29:11 +1200 > From: Mason James <mtj(a)kohaaloha.com> > To: Larisa Snabi <larisasnabi(a)gmail.com>, koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Error message in Koha > Message-ID: <101443f2-60c4-d66d-793a-425c4d194149(a)kohaaloha.com> > Content-Type: text/plain; charset=utf-8; format=flowed > > hi Larisa > i think you probably have a debian/ubuntu system that is a bit old - try > upgrading it to a newer version? > > curious, what debian and koha versions are you running? > > > On 17/07/20 6:35 pm, Larisa Snabi wrote: > > Please help. > > When logging in to Koha and going to About Koha I am getting the > following > > error > > > > "Can't locate object method " structured_requirements_for_module" via > > package "CPAN: : Meta: :Requirements " at > > /usr/share/koha/lib/C4/Installer/PerlModules.pm line 66 > > > > Thank you for your help > > > > Larisa Snabi > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > > > ------------------------------ > > Message: 2 > Date: Sat, 18 Jul 2020 16:38:01 +0200 > From: Katrin Fischer <katrin.fischer.83(a)web.de> > To: Koha <koha(a)lists.katipo.co.nz>, Koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Unable to create patron > Message-ID: <b24e85e7-337b-22f3-1f06-8398df0a8178(a)web.de> > Content-Type: text/plain; charset=utf-8; format=flowed > > Sorry, but I've run out of ideas now :( > > On 16.07.20 10:24, Michael Kuhn wrote: > > Hi Katrin > > > > > hard to debug remote... next things I'd check is probably the System > > > information tab on the about page and emptying out the > > > BorrowerMandatoryField and BorrowerUnwantedField system preferences to > > > see if anything there makes a difference. > > > > Thanks for the hints... > > > > The Koha menu "About Koha > System information" shows "No warnings". > > > > The Koha system preference "BorrowerUnwantedField" is empty. > > > > The Koha system preference "BorrowerMandatoryField" only contained > > "surname". I removed that and tried again to save a new patron, but it > > made no difference and didn't work. > > > > Best wishes: Michael > > > ------------------------------ > > Message: 3 > Date: Sat, 18 Jul 2020 11:38:45 -0500 > From: Alvaro Cornejo <cornejo.alvaro(a)gmail.com> > To: Koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Unable to create patron > Message-ID: > <CAO55aG_WdWkycHuJ1X== > 6Lq5G9qfN7wm-U+6ZYJ8MWjOYxE7Cw(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi Miichael > > I´ll go back to js and delete all js content added opan/admin and test > without them. > > I had an issue where a missing ' in a js killed the save button in the > record edit page even though the js had nothing to do with the record edit > function. > > note that this kind of error might come from a css / js missing ' " or or > an unescaped character. > > If it works, then add each js one by one until find the error. > > Hope helps > > Alvaro > > > |----------------------------------------------------------------------------------------| > Stay safe / Cuídate/ Reste sécurisé > *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à > mesure. > *q *Recycle always / Recicla siempre / Recyclez toujours > P Print only if absolutely necessary / Imprime solo si es necesario / > Imprimez seulement si nécessaire > > > Le jeu. 16 juil. 2020 à 03:24, Michael Kuhn <mik(a)adminkuhn.ch> a écrit : > > > Hi Katrin > > > > > hard to debug remote... next things I'd check is probably the System > > > information tab on the about page and emptying out the > > > BorrowerMandatoryField and BorrowerUnwantedField system preferences to > > > see if anything there makes a difference. > > > > Thanks for the hints... > > > > The Koha menu "About Koha > System information" shows "No warnings". > > > > The Koha system preference "BorrowerUnwantedField" is empty. > > > > The Koha system preference "BorrowerMandatoryField" only contained > > "surname". I removed that and tried again to save a new patron, but it > > made no difference and didn't work. > > > > 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 > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 4 > Date: Sat, 18 Jul 2020 20:20:54 +0200 > From: Michael Kuhn <mik(a)adminkuhn.ch> > To: Alvaro Cornejo <cornejo.alvaro(a)gmail.com>, Koha > <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Unable to create patron > Message-ID: <0c0ed85c-1a93-1ebf-7c7e-09bfc9be0ebf(a)adminkuhn.ch> > Content-Type: text/plain; charset=utf-8; format=flowed > > Hi Alvaro > > > I´ll go back to js and delete all js content added opan/admin and test > > without them. > > > > I had an issue where a missing ' in a js killed the save button in > > the record edit page even though the js had nothing to do with the > > record edit function. > > > > note that this kind of error might come from a css / js missing ' " > > or or an unescaped character. > > > > If it works, then add each js one by one until find the error. > > Thanks for the tip! I emptied both system preferences "IntranetUserJS" > and "OPACUserJS", then tried again to save a new patron. But it still > didn't work. > > 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 > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 177, Issue 19 > ************************************* >

1 0

Re: [Koha] Unable to create patron
by Katrin Fischer 18 Jul '20

18 Jul '20

Hi Michael, hard to debug remote... next things I'd check is probably the System information tab on the about page and emptying out the BorrowerMandatoryField and BorrowerUnwantedField system preferences to see if anything there makes a difference. Katrin On 13.07.20 10:43, Michael Kuhn wrote: > Hi Katrin > > > I think I misread thinking that the patron edit form didn't open at > > all, but it does. > > > > Could your problem be browser related? > > > > *Bug 25803* > > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25803> - > > Internet Explorer: unable to save patron edits or view patron checkouts > > Thanks for the hint! > > But no, the problem is not browser-related. We have tested with > Mozilla Firefox (which is officially supported by Koha) and also with > various versions of the Internet Explorer. > > Besides, as said before, we have two instances of Koha 18.11.05 > residing on the same host - only one of these two instances shows the > described problem where it is not possible to save a patron. > > Best wishes: Michael

3 4

Error message in Koha
by Larisa Snabi 18 Jul '20

18 Jul '20

Please help. When logging in to Koha and going to About Koha I am getting the following error "Can't locate object method " structured_requirements_for_module" via package "CPAN: : Meta: :Requirements " at /usr/share/koha/lib/C4/Installer/PerlModules.pm line 66 Thank you for your help Larisa Snabi

2 1

Wrong order wehen sorting public list by copyright year
by Michael Kuhn 16 Jul '20

16 Jul '20

Hi We are working with Koha 18.11.05 on Debian GNU/Linux 8. In our library we found in the OPAC it is not possible to sort public lists correctly by copyright date. As far as I know sorting by copyright date would follow the content of MARC 008 position 7-10. But looking at an actual sorting we see the sorting is as follows 2018 2017 2016 2015 2015 2014 2014 2013 2011 2017 <-- here it starts getting wrong 2019 2018 2016 2018 2016 ... Alle these records have correct content in MARC 008 and MARC 264$c. Strangely we found if a record has content in MARC 260$c and 264$c it changes the sort order - even if only MARC 008 should be relevant for the sort order. How can we achieve the correct sort order? 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

4 7

EMAIL NOTICES
by Nalisha Tamang 16 Jul '20

16 Jul '20

Dear all, please help me to solve the problem my email notification was running fine but after march i didnt do any circulation and today i tried the check out and check in but email wasn't send to a patron. please help me out to solve this problem... thank you

2 2

ids exist in both tables *borrowers* and *deletedborrowers*
by Heinrich Hartl 16 Jul '20

16 Jul '20

From koha/about <System Information> Problems found Patrons The following ids exist in both tables *borrowers* and *deletedborrowers*: 57 Yes, there is a borrowernr 57 in the table deletedborrowers with surname "test". And there is also a borrowernr. 57 in the table borrowers (this one is a real user of the library) What should I do to get rid of the deleted borrower 57? Regards Heinrich

3 2