- Koha - lists.katipo.co.nz

Error when tryin to log in to the Staff Interface
by Tomasz 03 Jan '20

03 Jan '20

Hi, My name is Tomasz and I am new to Koha community. I have run into a problem when installing Koha for the first time. I have failed on step when after initial setup, web installer and on-boarding tool I tried to log in to the Staff Interface. This is the error I get: Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_rasuwacommunity.library_groups' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 129 I did koha-upgrade-schema, koha-rebuild-zebra, but nothing worked. I am using Ubuntu19.10, stable latest Koha and mysql 8.0.18. Can you please help? Thank you in advance. Happy Christmas all!!! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 4

Cataloging tables, chairs, etc.
by Mark Alexander 01 Jan '20

01 Jan '20

Our little library is planning to lend out things like folding tables, folding chairs, cake pans, tools, and all sorts of other equipment. I'm trying to figure out the best way to set up circulation rules for these things. My initial thought was to minimize the number of items types, and hence circulations rules. So we could have item types called "EQUIPMENT-3DAYS", "EQUIPMENT-1WEEK", and "EQUIPMENT-1MONTH", the names of which reflect how long the circulation period would be. Then the various things we could lend out would fall into one of these buckets. But this means that if a user was searching for items by item type in the OPAC, cake pans might be listed next to power drills, and so forth. Maybe that's OK; I don't know. I was wondering how other libraries deal with this kind of thing. Thanks in advance!

2 2

Happy New Year
by Alvaro Cornejo 31 Dec '19

31 Dec '19

Hi All / kia ora Just a few lines to thanks all Koha team for their 2019 hard work and to wish to all the community a happy new year and a 2020 full of successes. 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

2 1

January 2020 koha-US meeting dates
by Jason Robb 30 Dec '19

30 Dec '19

Due to the New Year's holiday, the January koha-US meetings as regularly scheduled have been pushed forward one week. *koha-US board meeting:* Wednesday, January 8, 2020 @ 10:30 CST (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+board+mee…> ) https://kslib.zoom.us/j/450230564 *koha-US general meeting:* Wednesday, January 15, 2020 @ 10:30 CST (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+general+m…> ) https://kslib.zoom.us/j/110290143 View additional upcoming meetings and events on our Google calendar: https://calendar.google.com/calendar/embed?src=koha-us.org_dmqojds19fu8l8bd… koha-US meetings are open to any and all. Meetings are held via Zoom video conferencing. A microphone and camera 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 <https://support.zoom.us/hc/en-us/categories/200101697>* If you have topics for discussion at either meeting, please send them to secretary(a)koha-us.org. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Show analytics
by Petritsch Barbara 28 Dec '19

28 Dec '19

Dear Koha Community, I am a new koha user and have browsed your lively communication. It is good to see that this is a fine worling community. Mirko Tietgen has set up our application and is hosting and maintaining it. I don't want to bother him with every little problem I have though. So here comes my first issue: When linking to records I use the 773 to link the child record tot he parent record. This works just fine. Linking back to the child record (show analytics; Zeige unslebstständige Werke) from the parent record doesn't work regularly. I couldn't find out why it sometimes does or why it doesn't. Did anybody have the same issue and found the solution? I am happy with any clue. Best, Barbara Barbara Petritsch Bibliothek Museen der Stadt Wien Wien Museum 1040 Wien, Karlsplatz Liefer- und Büroadresse während der Sanierung am Karlsplatz: Arcade Meidling Eingang Wilhelmstraße 64, 3.OG Portier 1120 Wien T: +43 (0)1 505 87 47 84038 M: +43 (0)664 8829 3884 E: barbara.petritsch(a)wienmuseum.at W: www.wienmuseum.at

2 1

Experimenting with Authorities LinkerOptions and Elasticsearch
by Myka Kennedy Stephens 28 Dec '19

28 Dec '19

Hello, I'm doing some testing/refining of authority record mapping in Elasticsearch and thought that I would also try the broader_headings setting for LinkerOptions as described here: https://wiki.koha-community.org/wiki/Bug7284_authority_matching_improvement I'm noticing some strange things and inconsistencies. Could someone who is more familiar with using broader_headings in LinkerOptions tell me if this is unusual or normal? 1. When adding a bibliographic record: the linker did not automatically link on a broader heading (i.e., it didn't strip the free-floating subdivision to find a match); it worked when there was an exact match. 2. When editing the bibliographic record with the basic editor and clicking the link icon next to the heading that didn't automatically link: the authority search box comes up with the entire heading + free floating subdivision; removing the free-floating subdivision and performing the search finds the authority record for the broader heading. Select the heading to link and the heading + syntax remains the same in the basic editor. Save changes and the heading is now linked to the authority record for the broader heading. (Without broader_headings in LinkerOptions, the free-floating subdivision disappears when I try this.) 3. When editing the record with the advanced editor and using ctrl+shift+L: do an authority search same as above. Selecting the heading to link will change the syntax in the advanced editor, stripping the free-floating subdivision and punctuation. I'm testing this using Koha Testing Docker on master with ES enabled. It seems that broader_headings is partially working (see observation from action #2), but I'd really like it to link automatically on the broader heading. Is it supposed to? If so, is it not working for me because of ES or perhaps something else? I think the behavior I'm seeing with linking in the advanced editor (#3) is a separate issue. Thanks for your help, Myka -- Deaconess Myka Kennedy Stephens, MDiv, MSLIS Seminary Librarian and Assistant Professor of Theological Bibliography Lancaster Theological Seminary 555 West James Street Lancaster, PA 17603 717-290-8704 mkstephens(a)lancasterseminary.edu https://library.lancasterseminary.edu

2 2

Update for Demo page
by Jason Boyer 28 Dec '19

28 Dec '19

Hi, I’m Jason Boyer with the Equinox Open Library Initiative. I was hoping have our information updated on the Koha Demo server page at https://koha-community.org/demo/ <https://koha-community.org/demo/> . The current information for our demo server is now: MARC Flavor: MARC21 Version: 19.05 OPAC: opac-kohademo.equinoxinitiative.org <http://opac-kohademo.equinoxinitiative.org/> Staff Interface: staff-kohademo.equinoxinitiative.org <http://staff-kohademo.equinoxinitiative.org/> Staff login: demo / demo Provider: Equinox Open Library Initiative (USA) In other words, everything changes except MARC flavor and login. :) Thanks Jason -- Jason Boyer Senior System Administrator Equinox Open Library Initiative phone: +1 (877) Open-ILS (673-6457) email: JBoyer(a)EquinoxInitiative.org web: https://EquinoxInitiative.org/

2 1

Koha Community Newsletter: December 2019
by kohanews 28 Dec '19

28 Dec '19

The Koha Community Newsletter for December 2019 is here: https://koha-community.org/koha-community-newsletter-december-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

Deletion of books from purchase suggestion
by vinod mishra 27 Dec '19

27 Dec '19

Hello Can we restrict patrons to delete the record of those books which is recommended by him/her but now it is available/ordered?. It will help to maintain the records of the requester permanently in the system. Presently system allows patrons to delete the books online which they have request although it is ordered/available in the library. 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*

3 4

Re: [Koha] [koha] Unresolved Edited barcodes not saving
by Jonathan Druart 26 Dec '19

26 Dec '19

Hello, It was not me, and I do not understand what your problem is. You get a foreign constraint error when the item is inserted into the DB, which mean data you are trying to insert is not valid. In your case it refers to the homebranch, so you should either correct the homebranch value before you insert the item, or create a new library. Also, we still do not know the exact version of Koha you are using. If you are on 17.05 you must use the latest, 17.05.14 Regards, Jonathan PS: Please avoid cross-posting. Le mar. 24 déc. 2019 à 05:49, muirunyeri <muirunyeri(a)gmail.com> a écrit : > > Hello team, > > I have yet to resolve saving items aftet editing. Earlier, Druart wrote:- > > "It seems like Koha is trying to set homebranch to 'THK | THK' because the homebranch field is duplicated in the html form. That will fail the foreign key check. The fix for that is probably to verify the value for homebranch in the database for that itemnumber, and if that doesn't looks right then try removing the duplicate field from the html form." > > Can anyone help on how to remove the duplicate field from the html form please. > > I wish you all happy holidays. > > Thank you > > > > > > Sent from my Samsung Galaxy smartphone. > -------- Original message -------- > From: muirunyeri <muirunyeri(a)gmail.com> > Date: 23/11/2019 07:58 (GMT+03:00) > To: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> > Cc: koha <koha(a)lists.katipo.co.nz>, Koha Devel <koha-devel(a)lists.koha-community.org> > Subject: [koha] Edited barcodes not saving > > > Hi Druart, > > Thank you for your assistance on this issue. I have tried everything I know to remove the duplicate field from the html form without success. > How do I do it please? > > Thank you > > > Sent from my Samsung Galaxy smartphone. > > > > > Sent from my Samsung Galaxy smartphone. > -------- Original message -------- > From: Michael Hafen <michael.hafen(a)washk12.org> > Date: 22/11/2019 20:52 (GMT+03:00) > To: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> > Cc: Alvaro Cornejo <cornejo.alvaro(a)gmail.com>, muirunyeri <muirunyeri(a)gmail.com>, koha <koha(a)lists.katipo.co.nz>, Koha Devel <koha-devel(a)lists.koha-community.org> > Subject: Re: [Koha-devel] [Koha] [koha] Edited barcodes not saving > > It seems like Koha is trying to set homebranch to 'THK | THK' because the homebranch field is duplicated in the html form. That will fail the foreign key check. The fix for that is probably to verify the value for homebranch in the database for that itemnumber, and if that doesn't looks right then try removing the duplicate field from the html form. > > On Fri, Nov 22, 2019 at 1:51 AM Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> wrote: >> >> 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 >> _______________________________________________ >> Koha-devel mailing list >> Koha-devel(a)lists.koha-community.org >> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >> website : http://www.koha-community.org/ >> git : http://git.koha-community.org/ >> bugs : http://bugs.koha-community.org/ > > > > -- > Michael Hafen > Washington County School District Technology Department > Systems Analyst >

1 0