- Koha - lists.katipo.co.nz

Re: [Koha] [koha] Edited barcodes not saving
by muirunyeri 20 Nov '19

20 Nov '19

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.

2 1

Background cron tasks
by Coehoorn, Joel 20 Nov '19

20 Nov '19

We're working through setting up a new koha server, and as we go through all the settings a number of them reference needing a background cron job enabled in order to work properly. Is there a central list of all of these jobs somewhere we can review, in order to make sure we haven't missed anything important? Joel Coehoorn Director of Information Technology 402.363.5603 *jcoehoorn(a)york.edu <jcoehoorn(a)york.edu>* *Please contact helpdesk(a)york.edu <helpdesk(a)york.edu> for technical assistance.* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society

2 1

Books Copies MARC21
by Mahmoud 20 Nov '19

20 Nov '19

Hallo all, Second question is I am just importing some books from SRU server after connecting our university's Koha library to the main country's library in Germany which is K10plus. The main point is that Koha is not reading the barcode of the books from the MARC data that comes out in not creating book copies (we have from every book more than one copy with different signature, already in the MARC data). Thank you Best regards -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 4

Koha User csv export/import
by Mahmoud 20 Nov '19

20 Nov '19

Hallo all, I've just created some users on 1 koha installation and then I exported the patrons as CSV data. I tried importing the patrons into other koha installation but unfortunately it was failing due to some missing fields, how could be that there is missing fields if those patrons were already created in a koha system and all required fields were filled? Note: The 2 Koha installations are of the recent version. Thank you Best Regards -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 2

delete serial subscription
by Nalisha Tamang 20 Nov '19

20 Nov '19

How do I delete serial subscription as I have made a duplicate and i want to delete the old one and edit the new but it is not happening. especially I want to delete serial subscription of a particular journal. please help me out. thanks and regards, Nalisha

2 4

How to upgrade Koha from 17.05 to Latest stable release on Ubuntu 14.04
by yasiriqbal1 20 Nov '19

20 Nov '19

Dear All, I am new to Koha. Please help me to upgrade Koha from 17.05 to Latest stable release on Ubuntu 14.04. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

1 0

SQL for mass auto-generating barcodes for items
by Father Vlasie 19 Nov '19

19 Nov '19

Hello everyone! I wrote an SQL command to generate barcodes for all items in Koha. I did not find a command like this that was already written so I thought I might publish it on this list in case anyone else might find it useful. You will need to find your mysql username and password in your /etc/koha/sites/library/koha-conf.xml ("library" is your Koha instance name). In the commands below replace username with your username, of course, and koha_library with your database name. (You can show all databases in msql by entering: show databases; ) msql -u username -p use koha_library; set @bnum = 524580000000;update items set barcode=(@bnum:=@bnum+1) where barcode is not null; This will set a barcode of 524580000001 for the first book and each subsequent book will be assigned a number that is one higher than the last so the second will be 524580000002 and so on. I am not sure it is necessary but I also did a zebra reindex afterwards. (Again "library" is your Koha instance name.) sudo koha-rebuild-zebra -f -v library Thank you, Father Vlasie IT Director St. Photios Orthodox Theological Seminary 510 Collier Way, Etna, CA 96027, U.S.A. Website: www.spots.school

1 0

Loan Period
by Ma. Victoria H. Silva-Manuel 19 Nov '19

19 Nov '19

Hi. Our loan period is fixed at 7 hours, even if I changed the "loan period" and "unit" in the "Circulation and Fine Rules". Please help. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 1

Problem with patron cards - no barcode or image
by Rick Conrad 19 Nov '19

19 Nov '19

Hi, I’m trying to create patron cards that have barcodes as well as the library’s logo, but the barcode and the image never seem to show up. Can anybody see what I’m doing wrong? (It seemed like a bug to me, so I filed that here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23654 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23654>.) Thanks for any help! -Rick Conrad PS - In my first version of this email, I included screenshots of my settings so maybe somebody could see what the problem is. Unfortunately that put it over the size limit for the listserv, so it got held for moderation and, as far as I can tell, nobody ever looked at it. So I sent a second version in which I wrote out all the details of my layout settings and template settings with the same goal. That email was rejected by the mailserver as spam…. So… I really want to provide all the details in case someone can help, but it appears to be impossible. The best I can do is humbly ask anyone who might be able to help to follow the link to the bug report where you can find all the details.

2 1

Education meeting summary
by Caroline Cyr-La-Rose 19 Nov '19

19 Nov '19

Hello everyone! We had an interesting meeting today with colleagues who do training or who are interested in Koha education. Here are the main points we talked about : - None of us have used the training resources wiki pages we created last time, but we figured we'd leave them there as reference in case other people are using them. - We talked about how the Documentation Plan might support training and the production of training material. - We would like to be able to easily reuse the manual as training manual; David Nind will do a test with something simple like loans to see if we can export the manual as custom training material - David Nind will also check about how licensing can affect this process. - Ideally, we would like to reformat the manual to make it easily reusable as training material by taking different approaches (such as how-to's for single tasks, reference sections, concept explanations and troubleshooting sections) and also cater to different learning styles by incorporating screenshots, (links to) videos if available, and text. - Also, we would like the docs team to find a way to create permanent links to topics in the manual in order to refer to those topics regardless of the version in blog posts or other materials. - Finally, it was suggested that we incorporate a Glossary in the manual to make searching easier when users are not sure of the terminology. - And lastly, though it is not directly tied to training, we talked about the idea of creating promotional texts or FAQ's for decision makers looking to switch to Koha. The next meeting will take place on April 14 at 19 UTC. Thanks to all those who participated and thanks to ByWater Solutions for hosting the meeting in Zoom! -- Caroline Cyr La Rose, M.L.I.S. Librarian | Product Manager Phone: 1-833-465-4276, ext. 221 Caroline.Cyr-La-Rose(a)inLibro.com <mailto:caroline.cyr-la-rose@inLibro.com> INLiBRO | Document Technologies Specialists | www.inLibro.com <http://www.inLibro.com>

1 0