- Koha-devel - lists.koha-community.org

Security Releases 19.05.05 and 18.11.11
by Renvoize, Martin 03 Dec '19

03 Dec '19

Hello everyone, I would like to announce the immediate availability of the latest versions of Koha 19.05 and 18.11 respectively. These are combined bugfix and security releases and should be upgraded to at your earliest convenience. Release notes are available on the website at: https://koha-community.org/koha-19-05-05-release/ and https://koha-community.org/koha-18-11-11-release/ <https://koha-community.org/koha-18-11/> Many thanks to the release maintainers, *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

2 1

Koha Community Newsletter: November 2019
by Koha Newsletter 02 Dec '19

02 Dec '19

The Koha Community Newsletter for November 2019 is here: https://koha-community.org/koha-community-newsletter-november-2019/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. -- Chad Roseburg Editor, Koha Community Newsletter

1 0

errors in mysql log files
by philippe k 30 Nov '19

30 Nov '19

Hello, i found errors in the mysql log files. The server has koha 19.05.04, debian 10 and mariadb 10.3.18 installed. The log file is attached. I found out in mysql forums that it is related to the InnoDB engine limiting the row size to 8K. Some workarounds are related, such as in https://stackoverflow.com/questions/15585602/change-limit-for-mysql-row-siz… but i don't know the implications for koha. Have you noticed these errors ? Any idea ? Thank you !

1 0

Koha & Moodle
by Hugo Agud 29 Nov '19

29 Nov '19

Good morning I have just realized that koha 18.11 on release notes claims to be able to authenticate agains moodle and claims bugzilla 3511 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3511 But bug 3511 is closed as invalid, as far as I can see koha is able to authenticate against moodle, but using an invalid bug make me doubt. is koha able to authenticate agains moodle? I have figured out that Moodle can work as a CAS, then it is compliance, but invalid closed ;) kindest regards -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind> Director Passeig Comte Vilardaga, 118 3-3 08980 -Sant Feliu de Llobregat - Tel: 933 856 138 hagud(a)orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

4 3

Submitting Debian packages to Koha's APT repository
by dcook＠prosentient.com.au 29 Nov '19

29 Nov '19

Hi all, Joonas Kylmälä and I have been waiting about 2 months for a Debian package dependency on Bug 13193 - Make Memcached usage fork safe https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13193. I dont know if Mirko is just busy or hasnt seen it, but is there any way that we could build the package and submit it to the community repository? This is a critical bug in Koha, so it would be good to get this resolved ASAP. David Cook Systems Librarian Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Direct: 02 8005 0595

3 8

Re: [Koha-devel] [Koha] [koha] Edited barcodes not saving
by Jonathan Druart 22 Nov '19

22 Nov '19

Or, better: `koha-zebra --status $INSTANCE` Le mer. 20 nov. 2019 à 20:33, Alvaro Cornejo <cornejo.alvaro(a)gmail.com> a écrit : > > Hi > > Have you checked if zebra is running? > > use: > > ps -ef | grep zebra > > It should give you 4 results. > > Regards, > > Alvaro > > > > |-----------------------------------------------------------------------------------------------------------------| > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS > y GPRS online > Visitenos en www.perusms.com > > > Le mer. 20 nov. 2019 à 04:09, muirunyeri <muirunyeri(a)gmail.com> a écrit : > > > Hello Chris and all, > > I have been away for awhile the reason I have not responded to a thread I > > raised. The issue remains unresolved. > > I cleared the DBMS autoincrement error and from the system information > > page there's no warning. Barcodes and item edits are still not saving. This > > is really stressing us. The item editor has 2 subfields for permanent > > location as compared to 1 for add new item something that has not been > > there. > > Any assistance will be highly appreciated. > > Thank you > > > > > > Sent from my Samsung Galaxy smartphone.-------- Original message > > --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 07/11/2019 10:20 > > (GMT+03:00) To: Chris Cormack <chrisc(a)catalyst.net.nz> Cc: koha < > > koha(a)lists.katipo.co.nz>, koha-devel(a)lists.koha-community.org Subject: > > [koha] Edited barcodes not saving > > Hi team, > > System information page reports one error which has been there since the > > beginning. The error - Data Problems - Some of your tables have problems > > with their auto_increment values which may lead to data loss. InnoDB does > > not keep auto_increment across SQL server restarts ....... > > No other error besides that. > > I hvae one library set to code THK and still there in my libraries group. > > I do note something unusual in the edit items form for an item am trying > > to edit. There are two subfields for permanent location (subfield a) both > > populating the full name of my library and subfield b -current location > > also with the name of my library. > > Should this two similar subfields be there? Surprisingly theres only one > > subfield for permanent location under add new item. A new item is actually > > saving successfully > > Very grateful for any assistance > > James > > > > Sent from my Samsung Galaxy smartphone.-------- Original message > > --------From: Chris Cormack <chrisc(a)catalyst.net.nz> Date: 06/11/2019 > > 21:18 (GMT+03:00) To: koha(a)lists.katipo.co.nz, muirunyeri < > > muirunyeri(a)gmail.com> Subject: Re: [Koha] [koha] Edited barcodes not > > saving > > That might also be a problem, but the foreign key error before that > > definitely is. It means in that item record the value in homebranch doenst > > match a row in the branches table. > > That's why you can't update that item. Try changing the homebranch and > > save again (maybe try changing all the branch info on that item) > > > > It may be that somehow someone deleted a branch, check in administration, > > to see if all the libraries/branches are there that you expect to be > > > > Chris > > > > On 7 November 2019 2:56:32 AM NZDT, Alvaro Cornejo < > > cornejo.alvaro(a)gmail.com> wrote: > > Hi Muirunyeri > > > > The query used to update the barcode said it is finding several results > > "...Query returned more than one row..." > > > > This means that, when updating a record, msql is founding several records > > to update.... this might seems you have duplicated records in your > > database. > > > > Check on the about page whether you have something about that on system > > status. > > > > Regards, > > > > Alvaro > > > > > > > > |-----------------------------------------------------------------------------------------------------------------| > > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > > celular y Nextel > > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS > > y GPRS online > > Visitenos en www.perusms.com > > > > > > Le mer. 6 nov. 2019 à 03:37, muirunyeri <muirunyeri(a)gmail.com> a écrit : > > > > > > > Hi Vikram and team, > > Below is the error log I tried copying. > > AH01215: [Tue Nov 5 14:38:12 2019] additem.pl: ERROR in > > _koha_modify_item UPDATE items SET > > > > stack=?,price=?,itemnotes_nonpublic=?,replacementprice=?,notforloan=?,enumchron=?,stocknumber=?,itemnotes=?,withdrawn_on=?,datelastseen=?,dateaccessioned=?,restricted=?,copynumber=?,homebranch=?,barcode=?,ccode=?,replacementpricedate=?,holdingbranch=?,coded_location_qualifier=?,location=?,itemlost=?,materials=?,uri=?,booksellerid=?,itemcallnumber=?,itype=?,more_subfields_xml=?,permanent_location=?,items.cn_source=?,damaged=?,itemlost_on=?,withdrawn=?,items.cn_sort=? > > WHERE itemnumber=?: Cannot add or update a child row: a foreign key > > constraint fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_2` > > FOREIGN > > KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) > > at /usr/share/koha/lib/C4/Items.pm line 2029.: > > /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: > > > > http://192.168.67.5:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem&bi… > > [Tue Nov 05 14:38:12.848114 2019] [cgi:error] [pid 2832] [client > > 192.168.67.5:56592] AH01215: [Tue Nov 5 14:38:12 2019] additem.pl: > > DBIx::Class::Storage::DBI::select_single(): Query returned more than one > > row. SQL that returns multiple rows is DEPRECATED for ->find and ->single > > at /usr/share/koha/lib/Koha/Objects.pm line 92: > > /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: > > > > http://192.168.67.5:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem&bi… > > Any assistance will be highly appreciated. > > > > Sent from my Samsung Galaxy smartphone.-------- Original message > > --------From: vikram zadgaonkar <vikramczadgaonkar(a)gmail.com> Date: > > 04/11/2019 07:34 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com> Cc: > > Owen Leonard <oleonard(a)myacpl.org>, koha <koha(a)lists.katipo.co.nz> > > Subject: Re: [Koha] [koha] Edited barcodes not saving > > Will you be able to share screen shot of the error. > > Vikram Zadgaonkar > > > > On Mon, Nov 4, 2019 at 10:00 AM muirunyeri <muirunyeri(a)gmail.com> wrote: > > Hello Owen, > > > > Thanks for getting back to me on my query and sorry for not replying > > sooner. > > > > We are using version 17.05. > > > > There are no upgrades to koha, Mysql or the server. There are no changes > > whatsoever and no one has accessed the server. > > > > Kindly guide me on how to access the error logs and I will do so. > > > > Am very grateful for any assistance > > > > Thank you > > > > > > > > Sent from my Samsung Galaxy smartphone.-------- Original message > > --------From: Owen Leonard <oleonard(a)myacpl.org> Date: 31/10/2019 14:43 > > (GMT+03:00) To: muiru james <muirunyeri(a)gmail.com> Cc: koha < > > koha(a)lists.katipo.co.nz> Subject: Re: [Koha] [koha] Edited barcodes not > > saving > > > > Over the last few days, the new barcode is not saving i.e. after > > saving the old number is still showing instead of the new one. > > > > > > What version of Koha are you using? Has anything changed which might > > > > be linked to this problem? A server upgrade, Koha upgrade, MySQL > > > > upgrade? > > > > > > > > Do you have access to Koha's error logs? > > > > > > > > -- Owen > > > > > > > > -- > > > > Web Developer > > > > Athens County Public Libraries > > > > (740) 737-6006 > > > > https://www.myacpl.org Koha mailing list http://koha-community.org > > > > Koha(a)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 > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > > Sent from my Android device with K-9 Mail. Please excuse my brevity. > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)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 > https://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Minor koha-testing-docker behavior change
by Tomas Cohen Arazi 21 Nov '19

21 Nov '19

Hi all, this is a gentle warning for koha-testing-docker users. Since the very beginning the README.md clearly stated the need to do: $ cp env/defaults.env .env as part of the setup process. That .env file is where your changes to the defaults should be placed. But it wasn't using that file at all so it had no effect. And it didn't break if the file was absent. koha-testing-docker has been fixed to properly pick that file, and from now on it will explode because of it being missing if such was the case. So you've been warned, if you use koha-testing-docker and don't know about .env, then please read the README.md [1] or just ping me on IRC. -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F

1 0

Call for anyone who has worked with the Advanced Editor
by Hayley Mapley 17 Nov '19

17 Nov '19

Hi all, I'm working on writing some features involving the Advanced Editor, and have encountered issues which I have so far been unable to resolve. If anyone has written code for or around the Advanced Editor, please let me know! Cheers, Hayley -- *Hayley Mapley* Koha Developer Catalyst IT - Open Source Technologists DDI: +64 4 803 2233 |Mob: +64 27 501 9029 | www.catalyst.net.nz <http://www.catalyst.net.nz> Catalyst Logo CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267.

3 2

19.11 String Freeze
by Renvoize, Martin 14 Nov '19

14 Nov '19

Hi All, We are now officially in the string freeze period for Koha 19.11. The strings should be available for translation on translate.koha-community.org, please go forth and commence translating. Thanks for everyone's efforts this release. Martin

1 0

Call for news: November 2019
by kohanews 14 Nov '19

14 Nov '19

I'm collecting news for the November newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0