- Koha - lists.katipo.co.nz

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

27 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 26 Nov '18

26 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 26 Nov '18

26 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

DATA MIGRATION
by Igbudu Tersoo 22 Nov '18

22 Nov '18

Hi Great Ones, Had a problem with my old koha server machine. i have currently installed koha 18.04 with mysql 5.7 database on ubuntu 18.11. on the old server machine, koha 17.11 with mariadb database was running on ubuntu 16.11. now i have a backup of the old server and i used this command *mysqldump -uroot -p koha_library<koha_library.sql* to import the backup to the new server. the mysqldump command runs without an error but no data is migrated to the new server. please any help on what do do? Thank you. Murphy Igbudu Systems Librarian Benue State University Library & Information Services, Benue State University Makurdi. Nigeria.

3 3

Print 082b field on label
by Hira Akram 22 Nov '18

22 Nov '18

Hi All, I have been trying to print 082b field on label. I have added it in label layout.. but nothing is getting printed. Is there anyway to print it on label? Thanks in advance. Regards, Hira

1 0

Authority results in opac
by Mohamed Megahed 21 Nov '18

21 Nov '18

Hi to all I am asking about how to visible the link 865$u in authority page at opac, The link is already appear but did not able to click on it and open in new window. the page source is opac /cgi-bin/koha/opac-authoritiesdetail.pl?authid=14416<http:///cgi-bin/koha/opac-authoritiesdetail.pl?authid=14416> this in page [% IF( tag_856_u ) %] <span class="results_summary"><span class="label">online resource: </span>[% tag_856_u %]</span> [% END %] thank you <http://www.miuegypt.edu.eg/> [https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-anima…]<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Virus-free. www.avast.com<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…>

2 1