- Koha - lists.katipo.co.nz

koha-US general meeting reminder: Wednesday, August 12th
by Jason Robb 11 Aug '20

11 Aug '20

Our next koha-US general meeting is *tomorrow, *Wednesday, August 12th. Please note the updated Zoom link. If asked for a passcode, it is: 111581 When: 8:30a PT / 11:30a ET / 3:30p UTC (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+August+ge…> ) Where: https://us02web.zoom.us/j/648572897?pwd=TUpsRE1TYlFPWWxTWFl4TVovSTJ3Zz09 Agenda: https://docs.google.com/document/d/1g2EyIR9mckHum5k4dcSzzijf1iyKFSKCbgQK0A8… On the agenda this month: a reminder about submitting conference proposals, results from the development vote, and more. As always, we'll have plenty of time for open discussion of bugs and issues. If you have additional topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are always free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Re: [Koha] BULK EDIT BARCODES
by muirunyeri 11 Aug '20

11 Aug '20

Hello, On the above subject earlier, I wrote Ians suggestion solved my case. It sure did once but am still stuck at one point where the query finds matches but changes none with no warnings. The hyphen is just one character I'm trying to change among others. I believe the query is similar. Why aren't the changes effecting or what am I missing? My query: UPDATE items SET barcode = REPLACE(barcode, '--', '-') WHERE barcode LIKE '%--%'; RESULTS: Rows matched 1290: changed 0: Warnings 0 Please assist RegardsJames Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Ian Bays <ian.bays(a)ptfs-europe.com> Date: 29/07/2020 23:43 (GMT+03:00) To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] BULK EDIT BARCODES Hi. I think you do not need the % characters in the REPLACE patterns. You could use something like: UPDATE items SET barcode = REPLACE(barcode, '--', '-') WHERE barcode LIKE '%--%'; assuming you want to change all barcodes with "--". Hope this helps. On 29/07/2020 20:45, muiru james wrote: > Hi Team, > > I need to edit barcodes to replace a double hyphen (--) with a single > hyphen (-). The barcodes are many and will take long using the item editor > which allows me to edit one after the other. > > Is there a SQL command I could use to edit from the terminal? I tried > running the query below. It is matching the records but changing none. Is > there something I am missing? > > MariaDB[koha_library]> > UPDATE items SET barcode = REPLACE(barcode, '%--%', '%-%') WHERE itemnumber > IN (377,378,391,.....); > > I am using koha version 19.11 on Ubuntu 16.04 and mysql Ver 15.1 Distrib > 10.0.38-MariaDB > > Please assist > > Warm Regards > James > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Maintenance of the mailing list server
by Jonathan Druart 11 Aug '20

11 Aug '20

Hello devs, I have been in touch with Biblibre's sysop, Laurent. We are planning an upgrade of the mailing list server (move), in order to fix the problems we are facing for several months. It will make all the mailing lists listed there unavailable: https://lists.koha-community.org/cgi-bin/mailman/listinfo (all Koha MLs but the general one koha(a)lists.katipo.co.nz) It will be done on August 11th (Tuesday) starting at 7 UTC (for about 1 or 2 hours). I will send an update message when it is finished. Cheers, Jonathan

2 2

Quarantine / Cart problem with 18.11.04 version.
by Raymund Delahunty 10 Aug '20

10 Aug '20

We are testing using the Cart functionality as we prepare to open the libraries again (looking to use a 72 hour quarantine) and are puzzled that only sometimes does the location change back from Cart to the former location which should be temporarily stored in the permanent_location field. Sometimes the reversion happens, sometimes the items stay at Cart, and sometimes (mostly!) the location left after the cart_to_shelf script runs is <undefined> and the data field is left empty. Anyone else finding this? (Every item in our database has the location data field populated.) Ray Delahunty University of the Arts London . 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

3 2

Cache and languange change not working
by Alvaro Cornejo 09 Aug '20

09 Aug '20

Hi Folllowing some advise from https://www.webpagetest.org/ and https://lighthouse-dot-webdotdevsite.appspot.com/ for optimizing koha. I´ve found small issues that I was able to fix locally and some, well,are too complex fro my knowledge and guess require changes in koha code. Note that lighthouse detected that jQuery(a)3.4.1 <https://snyk.io/vuln/npm:jquery?lh=3.4.1&utm_source=lighthouse&utm_medium=r…> have two medium risk vulnerabilities. The issue I'm trying to fix is regarding the cache. I had y servier with no cache header so max-age was not setup. I´addedd header cache max-age 3600 public to apache header and now after two language changes I'm unable to change it again. If I clear my browser cache, completely disable cache header or wait the 3600 seconds, I can again change the language for two times. How can I avoid browser to cache only language change part? I guess there is a way to exclude from cache specific files. 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 0

Koha and OS upgrade procedure
by vinod mishra 08 Aug '20

08 Aug '20

Hello I am running Koha 16.11.11 on Debian 8 and Mysql DB. Please suggest how to upgrade OS, Koha, as well as from MySql to MariaDB. Will it be ok/easy to Install the latest Version of Debian Koha and Restore the MYSql backup over MariaDB? OR Should I upgrade step by step on the same current server? 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*

1 0

Koha 20.05, Ubuntu 18.04 and MariaDB
by Isabel Pineda 07 Aug '20

07 Aug '20

Hi. I don't want to shred Michael Kuhn's question, but I have a similar one: I am using Koha 20.05 on Ubuntu 18.04, and I updated MariaDB to versión 10.3. This is working. But I am curious to know, if it would work with MariaDB 10.4 or 10.5 as well. Thanks Isabel Pineda

7 11

Windows 10 causing trouble with upgrade to 20.05
by Elaine Bradtke 07 Aug '20

07 Aug '20

I noticed this problem when we were testing the upgrade before installing it in the production site. I thought it was a fluke with the PC I tested it on, but now a colleague is reporting the same problem - with a windows 10 OS. Searches seem to proceed normally, until you click through to the biblio record and then it says 'not found'. This problem could not be replicated on a mac. Things we tried that did not make a difference. In Chrome: Clearing browser history / cache, browsing anonymously, and a completely new installation of Firefox (had never been installed on this computer). What appears to have fixed it: Windows update. Our working theory is that the update cleared some cache somewhere on the PC. Has anyone else seen this? And if so, is there a better way to fix it instead of waiting for an update? Elaine Bradtke VWML Our income is severely diminished in these exceptionally uncertain times. Please help us to survive beyond this national crisis. Donate now <https://www.efdss.org/support-us>. 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 1

August String Freeze (August 18)
by Lucas Gass 06 Aug '20

06 Aug '20

Hello All, Just a quick note that since the 22nd is on a Saturday this month we are pushing the maintenance release date back a couple of days. It will be August 25th. Therefore string freeze will start on August 18. -- Lucas Gass Web Developer

1 0

Z39.50/SRU search not working (only when language set to English)
by zefanja 06 Aug '20

06 Aug '20

Hi, if I enter an ISBN in "Search the catalog", on the next page, the "Z39.50/SRU search" button is not working (it does not open the popup for the Z39.50/SRU search). In the web console I get this error: Uncaught SyntaxError: expected expression, got ';' search.pl:636:29 This happens, when I set the language to german (haven't tests other non-english languages). When I set the language to English, everything works fine. Any ideas? Regards, Stephan

3 7