- Koha - lists.katipo.co.nz

Omeka / OHMS issue
by Chad Roseburg 12 Mar '20

12 Mar '20

We have a new installation of Omeka. When I try to upload an OHMS XML file, whether zipped or not, I get the error: LogicException OHMS file must be validated before retrieving the list of columns. Along with a stack trace. Any Omeka users run into this one? Thanks! -- Chad Roseburg Assoc. Director / IT Automation Dept. North Central Regional Library

3 3

Re: [Koha] multiple Koha zebra problem
by dcook＠prosentient.com.au 12 Mar '20

12 Mar '20

Hi George, I notice that you didn't answer Katrin's questions. Answering those questions is really important, or we can't really help you very well. Now, it sounds to me like you've installed Koha from either a "git clone" or a tarball, and that you're running multiple Koha instances from multiple Koha codebases, which may or may not be running the same version. I'm guessing that you copied "misc/bin/koha-zebra-ctl.sh" to /etc/init.d/koha-zebra-daemon, /etc/init.d/koha1-zebra-daemon, etc. However, it sounds like you haven't updated the following line within that file: # Provides: koha-zebra-daemon You'll need to update that to match the filename. That's why you're getting that error. I think Ubuntu 14.04 used upstart as an init system while Ubuntu 16.04 should be using systemd. Systemd can be pretty strict when it comes to interpreting SysV style scripts like "misc/bin/koha-zebra-ctl.sh", so that's probably where the difference lies. Now, if you're only running 1 version of Koha (ie 3.22.21), I'd highly recommend that you don't use git/tarball installations, and instead switch to using Debian packages. It will make your life much easier (and it'll make it easier for you to get support from the Koha Community). Cheers, David Cook Systems Librarian Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Direct: 02 8005 0595 -----Original Message----- Date: Thu, 12 Mar 2020 12:11:08 +0400 From: George Mikuchadze <gmikuchadze(a)gmail.com> To: koha(a)lists.katipo.co.nz, katrin.fischer.83(a)web.de, Irakli Garibashvili <igar(a)hotmail.com> Subject: [Koha] multiple Koha zebra problem Message-ID: <CAJR6aCBHjT3XBNtvb_Unejw+5cUO9QU7JwfDatskrxPBEWDEnw(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Dear Katrin, Many thanks for Your reply. The problem is the following: We use multiple koha-s (with the same number of zebra daemons), now we want to install koha v3.22.21 on ubuntu 16.04. When I activate koha-zebra-daemon for the second instance of koha (koha1), I get the error: ---------------------------------------------------------------------------------------------------------------------- $ sudo update-rc.d koha1-zebra-daemon defaults insserv: script koha1-zebra-daemon: service koha-zebra-daemon already provided! insserv: exiting now! update-rc.d: error: insserv rejected the script header ----------------------------------------------------------------------------------------------------------------------- Here is the content of koha1-zebra-daemon: ............................................................................................................... .............the same as for instance of koha, koha2, koha3....................... USER=koha GROUP=koha DBNAME=koha1 NAME=koha-zebra-ctl.$DBNAME LOGDIR=/var/log/koha1 ERRLOG=$LOGDIR/koha-zebradaemon.err STDOUT=$LOGDIR/koha-zebradaemon.log OUTPUT=$LOGDIR/koha-zebradaemon-output.log KOHA_CONF=/etc/koha1/koha-conf.xml RUNDIR=/var/run/koha1/zebradb LOCKDIR=/var/lock/koha1/zebradb # you may need to change this depending on where zebrasrv is installed ZEBRASRV=/usr/bin/zebrasrv ZEBRAOPTIONS="-v none,fatal,warn" .................................................................................................... .............the same as for instance of koha, koha2, koha3........... The main strange is the following: it (the same version of koha and zebra) works without any problem on Ubuntu 14.04! Thanks in advance George Mikuchadze

1 0

[KOHA] SQL CIRCULATION REPORT
by muiru james 12 Mar '20

12 Mar '20

Dear All, My library uses DDC scheme of classification and we are looking for a report that will count items checked out allowing us to select day(s) of issue, select itemtype and group the statistics by DDC 10 broad classes. *EXAMPLE* IN a date range say 1st-31st March 2020. *DDC Class | NO. of books issued* 000 - 12 100 - 26 200 - 157 . . . 900 - 230 The report can generate statistics for a day, month, quarter, e.t.c. Any assistance however close will be greatly appreciated. Thank you as you prepare to help James

2 3

multiple Koha zebra problem
by George Mikuchadze 12 Mar '20

12 Mar '20

Dear Katrin, Many thanks for Your reply. The problem is the following: We use multiple koha-s (with the same number of zebra daemons), now we want to install koha v3.22.21 on ubuntu 16.04. When I activate koha-zebra-daemon for the second instance of koha (koha1), I get the error: ---------------------------------------------------------------------------------------------------------------------- $ sudo update-rc.d koha1-zebra-daemon defaults insserv: script koha1-zebra-daemon: service koha-zebra-daemon already provided! insserv: exiting now! update-rc.d: error: insserv rejected the script header ----------------------------------------------------------------------------------------------------------------------- Here is the content of koha1-zebra-daemon: ............................................................................................................... .............the same as for instance of koha, koha2, koha3....................... USER=koha GROUP=koha DBNAME=koha1 NAME=koha-zebra-ctl.$DBNAME LOGDIR=/var/log/koha1 ERRLOG=$LOGDIR/koha-zebradaemon.err STDOUT=$LOGDIR/koha-zebradaemon.log OUTPUT=$LOGDIR/koha-zebradaemon-output.log KOHA_CONF=/etc/koha1/koha-conf.xml RUNDIR=/var/run/koha1/zebradb LOCKDIR=/var/lock/koha1/zebradb # you may need to change this depending on where zebrasrv is installed ZEBRASRV=/usr/bin/zebrasrv ZEBRAOPTIONS="-v none,fatal,warn" .................................................................................................... .............the same as for instance of koha, koha2, koha3........... The main strange is the following: it (the same version of koha and zebra) works without any problem on Ubuntu 14.04! Thanks in advance George Mikuchadze

1 0

How to show contents?
by Rizwan Majeed 12 Mar '20

12 Mar '20

Dear All How I can show formatted contents of a book in OPAC? Regards!

2 1

Warning for the ClaimReturnedWarningThreshold
by Holly Interleaf 12 Mar '20

12 Mar '20

Hi All, I am just testing the enhancements to the Claims Returned lost status in the 19.11 release of KOHA, from this bug: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14697. Great feature, but I've had reports from some of the libraries that I support that the ClaimReturnedWarningThreshold may not be working correctly. Can I just check, how is the warning generated by that system preference supposed to look? For example, a client has saved the system preference as "Warn librarians that a patron has excessive return claims if the patron has claimed the return of more than 3 items." They then created a new patron and checked out a few items to them. When they marked the first item with the "Claim Return" option on the checkout table a note started to appear in the warning area under "Attention" on the upper right hand side of the circulation page: "Return claims: Patron has 1 RETURN CLAIMS." As they marked more items with "Claim Return", the number in the message rose, but no other warning appeared. Is this the warning a librarian will get? If so, shouldn't this have appeared only after 4 items had been marked as "Claim Return" on that patron account? Thanks, Holly <http://www.interleaf.ie/> *Holly Cooper* Systems Librarian hc(a)interleaf.ie <csq(a)interleaf.ie> +353-1-286-5855 A98 YD30 www.interleaf.ie <http://www.interleaf.ie/products-services/Library-Applications/Scooter> <http://www.interleaf.ie/products-services/Library-Applications/Koha> <http://www.interleaf.ie/products-services/PC-Reservation-and-Print-Manageme…>

2 1

Missing barcode number ascending order -SQL query
by Yatheesh lis 11 Mar '20

11 Mar '20

Hi Can anyone help me to get missing barcode number -SQL query. I tried one -SQL query available on koha wiki I am not getting in proper order it shows only starting ending

2 2

Koha Circulation not displaying anything after check out
by Admire Mutsikiwa 11 Mar '20

11 Mar '20

I have updated a Koha instance running on Ubuntu 18.04LTS to Koha version 19.11.03.000 from Koha version 19.02. When an Item is checked out it displays on the headings (Due date, title, ,) but with no corresponding information . On returns, it is behaving as is expected. Kind Regards, Admire Mutsikiwa University of Zimbabwe

2 1

Install fails: 19.11 on fresh Debian 9: table $SITE.zebraqueue doesn't exist
by Dwight Tuinstra 10 Mar '20

10 Mar '20

Hello all -- I'm volunteering some IT consulting at a small research library in Oaxaca, Mexico, that wishes to use koha. To start the project I'm trying to install a test instance of koha 19.11 on a fresh install of Debian 9, which the documentation suggests is one of the preferred platforms. I've carefully followed the wiki document "Koha on Debian" ( https://wiki.koha-community.org/wiki/Koha_on_Debian) performing all steps in the order indicated. So far I found one (known but unfixed) documentation bug and applied the workaround -- one needs to add a backports repository -- but this time I'm running up against something that isn't so easy. The problem manifests as the web UI seeming to hang after going through all the configuration screens and clicking on the button to create the database tables. After several minutes of no activity, the brower reports "Gateway Timeout" The gateway did not receive a timely response from the upstream server or application. There are two possible causes that I've been able to see so far: POSSIBILITY 1: There is an indexer problem that occurs even before the point where the web installer is run. The file /var/log/koha/opac (I'm calling my instance "opac") begins to fill up with error messages. The first few are: DBD::mysql::db do failed: Table 'koha_opac.systempreferences' doesn't exist [for Statement " SELECT * FROM systempreferences WHERE 1 = 0 "] at /usr/share/koha/lib/Koha/Database.pm line 114. DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='casauthentication'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='caslogout'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. DBD::mysql::st execute failed: Table 'koha_opac.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='casserverurl'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. DBD::mysql::db selectall_arrayref failed: Table 'koha_opac.marc_subfield_structure' doesn't exist [for Statement " SELECT * FROM marc_subfield_structure WHERE frameworkcode = ? AND kohafield > '' ORDER BY frameworkcode,tagfield,tagsubfield "] at /usr/share/koha/lib/C4/Biblio.pm line 1013. DBD::mysql::st execute failed: Table 'koha_opac.zebraqueue' doesn't exist [for Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 324. DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() [for Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 325. After this, the log continues to grow with the last two lines constantly added over and over. Curiously, though, this seems to stop about the time that the web installer is run. POSSIBILITY 2: The creation of database tables takes so long that the browser or installer times out, or race conditions arise. I watched table creation in another window as the web installer was running. Table creation seemed to go slow (roughly a table every second) even though there was plenty of free memory, free disk space (with low disk activity), and the CPUs were over 95% idle. Table creation stopped at 162 tables, at almost the exact same moment that the browser gave the timeout message, so I'm not sure if that's all the tables or if there are supposed to be more. What's odd here is that the web installer writes a good number of messages to /var/log/koha/opac/intranet-error.log, each saying that one of these database tables do not exist: language_descriptions, language_subtag_registry, or systempreferences. However, all of these tables *do* exist in the database when one examines it later, which suggests a race condition. OTHER INFO: - Virtualization: VirtualBox 5.2.34_Ubuntu r133883, 2 i7 CPUs, pre-allocated fixed disk (32Gb), 2GB RAM - Debian version: 4.9.0-12-686-pae #1 SMP Debian 4.9.210-1 (2020-01-20) i686 - Koha version: 19.11 - Following: stable - Database: mariadb, on same host as koha - During WebUI installer: - All Perl dependencies installed and OK - All DB settings look reasonable, connection established, and database koha_opac exists and can be accessed Please help! I've spent hours upon hours doing the installation over and over, making sure everything is clean and updated, and all changes and actions are exactly as the documentation requests. I've kept configuration changes to the minimum required by the documentation in order to avoid complications. What do I need to do to get koha installed? --Dwight (Memo)

2 3

koha-US general meeting reminder: Wednesday, March 11th, 2020
by Jason Robb 10 Mar '20

10 Mar '20

Our next koha-US general meeting is *tomorrow*, Wednesday, March 11th. When: 8:30 AM PDT / 9:30 MDT / 10:30 CDT / 11:30 EDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+March+gen…> ) Where: https://zoom.us/j/648572897 Agenda: https://docs.google.com/document/d/12u5AYt-HE6B7OCghtvXw4RQvj7bMyfB3aE8T5D2… This month we will discuss what's next with both Kohathon and the annual face-to-face conference, take a look at some of the special interest groups that are just getting started, and more! As always, there will be time to discuss Koha bugs, issues, and workflows so if you have a burning question or want to rally behind an issue, be sure to bring it! If you have specific topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam 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 These meetings are free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0