- Koha - lists.katipo.co.nz

Koha 18.11.00 released
by Nick Clemens 29 Nov '18

29 Nov '18

Hello everybody, It is with great pleasure that the Koha community announces the release of Koha 18.11, a major release of the Koha open source integrated library system. This release (as always) is the work of many librarians, developers, and community members who donate their time and effort to the project. Their contributions help shape the release, and the project going forward. None of this would be possible without them, and my sincere thanks goes out to everyone who had a hand in the project Read the full release notes here: https://koha-community.org/koha-18-11-release/ Debian packages are available, if you are following a suite you will automatically upgrade to the next branch with this release, more info here: https://wiki.koha-community.org/wiki/Koha_on_Debian#Follow_a_suite:_stable.… Thank you all, Nick (kidclamp) -- Nick Clemens Sonic Screwdriver (Development Support) ByWater Solutions IRC: kidclamp

4 3

Removal from list
by RCDC Library 28 Nov '18

28 Nov '18

Please remove Raffles College Library form the mailing list as we are closing down Regards

2 1

18.11 Release
by Nick Clemens 28 Nov '18

28 Nov '18

HI All, Just a heads up the release is prepared, we are waiting on packages and final details. Will let you know once it is all set and ready to go. Your excited RM, Nick -- Nick Clemens Sonic Screwdriver (Development Support) ByWater Solutions IRC: kidclamp

4 4

Global Updating of Patron messaging preferences
by Mutsikiwa Admire 28 Nov '18

28 Nov '18

Hi I have recently imported close to 15 000 patrons records. I am interested in a script or SQL query that would enable me to modify Patron Messaging Preferences. Kind Regards, Admire Mutsikiwa ICT Projects Manager Libraries University of Zimbabwe <Tel:+263-4-303276> Tel:+263-4-303276 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp, 1880-1941, former director of the Bank of England

2 1

Error while creating new label batch
by dnj 27 Nov '18

27 Nov '18

When trying to create a new label batch and filling it with items (either by barcode or itemnumbers) I'm getting the following error: WARNING: An error was encountered: Item(s) not added to batch 3. Please have your system administrator check the error log for details. This happens when I'm pasting 1 or more barcodes in the textfield for adding items. It also happpens if I past 1 or more itemnummbers in that text field. It's a bit unexpected because I was able to create 1 label batch 1 month ago, but if I try to use the same procedure now I get the error. When I check the logs in intranet-error.log I find the following errors saying there was a problem with inserting the items in the batch in the database. [Mon Nov 26 15:42:01.661987 2018] [cgi:error] [pid 10354] [client 192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018] label-edit-batch.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE CASCADE) [for Statement "INSERT INTO creator_batches (batch_id, item_number, branch_code, creator) VALUES (?,?,?,?);" with ParamValues: 0='3', 1='230', 2="SH", 3='Labels'] at /usr/share/koha/lib/C4/Creators/Batch.pm line 69.: /usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer: http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batc… [Mon Nov 26 15:42:01.662619 2018] [cgi:error] [pid 10354] [client 192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018] label-edit-batch.pl: Database returned the following error on attempted INSERT: Cannot add or update a child row: a foreign key constraint fails (`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE CASCADE) at /usr/share/koha/lib/C4/Creators/Batch.pm line 71.: /usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer: http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batc… [Mon Nov 26 15:42:01.664480 2018] [cgi:error] [pid 10354] [client 192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018] label-edit-batch.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE CASCADE) [for Statement "INSERT INTO creator_batches (batch_id, item_number, branch_code, creator) VALUES (?,?,?,?);" with ParamValues: 0=3, 1='235', 2="SH", 3='Labels'] at /usr/share/koha/lib/C4/Creators/Batch.pm line 69.: /usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer: http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batc… [Mon Nov 26 15:42:01.665053 2018] [cgi:error] [pid 10354] [client 192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018] label-edit-batch.pl: Database returned the following error on attempted INSERT: Cannot add or update a child row: a foreign key constraint fails (`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE CASCADE) at /usr/share/koha/lib/C4/Creators/Batch.pm line 71.: /usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer: http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batc… [Mon Nov 26 15:42:01.667071 2018] [cgi:error] [pid 10354] [client 192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018] label-edit-batch.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE CASCADE) [for Statement "INSERT INTO creator_batches (batch_id, item_number, branch_code, creator) VALUES (?,?,?,?);" with ParamValues: 0=3, 1='231', 2="SH", 3='Labels'] at /usr/share/koha/lib/C4/Creators/Batch.pm line 69.: /usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer: http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batc… [Mon Nov 26 15:42:01.667630 2018] [cgi:error] [pid 10354] [client 192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018] label-edit-batch.pl: Database returned the following error on attempted INSERT: Cannot add or update a child row: a foreign key constraint fails (`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3` FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE CASCADE) at /usr/share/koha/lib/C4/Creators/Batch.pm line 71.: /usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer: http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batc… Any idea what is going wrong and/or how to solve this? Thanks in advance! Jan. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

1 1

Koha 18.05.06 release
by Renvoize, Martin 27 Nov '18

27 Nov '18

The Koha community is proud to announce the release of Koha 18.05.06. This is my final release as the 18.05.x maintainer, but I will be returning next cycle as the next stable (18.11) maintainer. The 18.05.x series will live on in the capable hands of Lucas Gass and Jesse Maseto. This is a maintenance release containing 67 bugfixes The full release notes are available at https://koha-community.org/koha-18-05-06-release/ Debian packages will be updated within a few days Many thanks to everyone involved, *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

keep on page when patrons login
by Hugo Agud 27 Nov '18

27 Nov '18

Good morning to all Before open a bug on bugzilla, we have a behaviour at koha that although it is logical it can't be desirable. When a un logged patron do a search on koha and get results, if he wish to create a list, it is mandatory to log in, but when it does it goes to account page and looses the search he has done. On other systems I have seen a conf that admin can decide what happens when a user login if he stays or goes to myaccount page, but I think thre is no syspref on admin for that, right? Am I right? thanks you in advance -- *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 Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 - Barcelona - 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

Koha 17.11.12 release
by Fridolin SOMERS 26 Nov '18

26 Nov '18

The Koha community is proud to announce the release of Koha 17.11.12. This is a maintenance release. The full release notes are available at https://koha-community.org/koha-17-11-12-release/ Debian packages will be upgraded in a few days. Regards, -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

1 0

Embedding reviews from Flipgrid
by Charlotte Stock 26 Nov '18

26 Nov '18

We are keen to display video reviews alongside the entry for the reviewed title, using Flipgrid. Would anyone be willing to share an example of how they have incorporated Flipgrid in this way, and an outline of the process involved? Thanks Charlotte -- * Charlotte Stock, Digital Librarian * -- *Halcyon London International School* 33 Seymour Place, London W1H 5AU +44 (0)20 7258 1169 <http://halcyonschool.com/?utm_source=email%20footer&utm_medium=email> <http://halcyonschool.com/visit?utm_source=email%20footer&utm_medium=email> <https://www.facebook.com/HalcyonLondonInternationalSchool?utm_source=email%…> <http://www.linkedin.com/company/halcyon-london-international-school?utm_sou…> <https://mydonate.bt.com/charities/halcyonlondoninternationalschool?utm_sour…> <https://twitter.com/HalcyonSchool?utm_source=email%20footer&utm_medium=email> -- +44 (0)20 7258 1169 *Halcyon London International School* 33 Seymour Place, London, W1H 5AU, UK <http://halcyonschool.com> <https://mydonate.bt.com/charities/halcyonlondoninternationalschool> <https://www.facebook.com/HalcyonSchool/> <http://instagram.com/halcyon_school> <http://twitter.com/halcyonschool> <https://mydonate.bt.com/charities/halcyonlondoninternationalschool> If you receive this email by mistake, please let us know and/or delete it. Please do not forward it. We believe that it is free of viruses, but even so we cannot be responsible for any electronic infection that it may have acquired.

1 0

Script to add Patron Records from another Database
by Mutsikiwa Admire 24 Nov '18

24 Nov '18

Hi I would like to add patrons from our Management Information System. I have a script which use to work before on lower version of Koha. Now I am running Koha version 17.11.11.000 and I am getting the following error: unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 245 I will appreciate any script that could run in the context of Koha i.e using my $dbh = C4::Context->dbh; Kind Regards, Admire Mutsikiwa ICT Projects Manager Libraries University of Zimbabwe <Tel:+263-4-303276> Tel:+263-4-303276 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp, 1880-1941, former director of the Bank of England

2 1