- Koha - lists.katipo.co.nz

Patron categories automatically reverting (3.18.11)
by TCC_Beth 13 May '19

13 May '19

We have an old installation (3.18.11), and have recently started seeing patrons who used to be listed as one category (Staff) all reverting to a different category (Student). We'll go in via admin and manually change them back, and then the next time we check them, it's reverted back to Student again. This is really messing up our stats and is also problematic because different categories have different borrowing privileges. Without a drastic update to the newest release of Koha (skipping many in between which I worry would cause a lot of problems), does anyone know if there were any bug fixes released for 3.18 that might fix this issue? Or is there some setting that might be causing this that we could tweak? I'm new to my position and to Koha, so I'm not sure how to remedy this issue. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 5

Error while using Acquisition Module vendors search (Koha 18.11.05 on Ubuntu 18.04 LTS)
by Ata ur Rehman 13 May '19

13 May '19

Dear All Ref to Bug: 22869 I got the following error message while searching a vendor (which is available) or adding a new vendor: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081. I've migrated database from an old version to 18.11.05 (Ubuntu 18.04 LTS). Intranet Error log says: [Thu May 09 01:31:31.751639 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: DBD::mysql::st execute failed: Out of sort memory, consider increasing server sort buffer size [for Statement ": /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.752809 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SELECT aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753108 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(aqorders.quantity) AS total_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753281 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753555 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF ( aqorders.orderstatus = 'cancelled', aqorders.quantity, 0 ): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753784 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS total_items_cancelled,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754027 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: COUNT(DISTINCT aqorders.biblionumber) AS total_biblios,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754164 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754361 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754741 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754920 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755064 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755235 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS expected_items: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755404 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: FROM aqbasket: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755786 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.756914 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: WHERE booksellerid = ? GROUP BY aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items HAVING (closedate IS NULL OR (: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757067 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757268 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757644 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757851 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757993 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762276 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) > 0))" with ParamValues: 0=1] at /usr/share/koha/lib/C4/Acquisition.pm line 705.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762667 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl Screenshot may please be found at: https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89479 Any help/advice would be appreciated, pl. Regards, Ata ur Rehman NCP - Islamabad

3 2

Re: [Koha] Enabling https only using SSL
by TechOut Solutions 12 May '19

12 May '19

Hi Joel, I couldn't find the four entries of virtual hosts but I did the following by searching for similar problems but others are using letsencrypt certificates. # OPAC <VirtualHost *:80> Include /etc/koha/apache-shared.conf # Include /etc/koha/apache-shared-disable.conf Include /etc/koha/apache-shared-opac.conf ServerName ssb SetEnv KOHA_CONF "/etc/koha/sites/ssb/koha-conf.xml" SetEnv MEMCACHED_SERVERS "" SetEnv MEMCACHED_NAMESPACE "" AssignUserID ssb-koha ssb-koha ErrorLog /var/log/koha/ssb/opac-error.log # TransferLog /var/log/koha/ssb/opac-access.log # RewriteLog /var/log/koha/ssb/opac-rewrite.log SSLEngine on SSLProtocol +TLSv1.2 +TLSv1.1 +TLSv1 SSLCipherSuite "ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA" SSLHonorCipherOrder on SSLCompression off SSLCertificateFile /etc/apache2/ssl/apache.crt SSLCertificateKeyFile /etc/apache2/ssl/apache.key </VirtualHost> I couldn't make the https protocol to load the OPAC using the above configuration. Do I need to use the letsencrypt certificate for it to work? Thanks! On Sun, May 12, 2019 at 10:43 AM Coehoorn, Joel <jcoehoorn(a)york.edu> wrote: > I'm not at a place where I can check, but if you look at your Apache site > .conf file, there will likely be 4 virtual host entries: an http and https > option for both the opac and staff client. You can remove most everything > from inside the http entries and replace them with Redirect directives > which point to the correct https urls. > > On Sat, May 11, 2019, 11:41 PM TechOut Solutions < > techoutsolutions00(a)gmail.com> wrote: > >> Hi there, >> >> I am trying to setup Koha OPAC and Staff-Client using https protocol only >> using SSL and want to disable http access to Koha. I'd appreciate if I >> could get the sample apache virtualhost site configuration to achieve the >> result. Thank you. >> >> Regards, >> Nirvana >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >

1 0

Enabling https only using SSL
by TechOut Solutions 12 May '19

12 May '19

Hi there, I am trying to setup Koha OPAC and Staff-Client using https protocol only using SSL and want to disable http access to Koha. I'd appreciate if I could get the sample apache virtualhost site configuration to achieve the result. Thank you. Regards, Nirvana

1 0

SQL Report - Authorities. List duplicate values based on 010$a
by Craig Butosi 11 May '19

11 May '19

Hi all, Koha 18.11 on Ubunti 16.04 May I request help for an SQL report that does the following, please: Identify and list by authid and main heading all authority records that have a tag 010$a with duplicate values? I am attempting to located all authority records that can be merged (or de-duped via merge). Many thanks! Craig Butosi, MA, MLIS, B Mus (Hons) Library: library.craigbutosi.ca

2 1

upgrade from koha-17.05.06 to koha-latest
by vijay kumar 11 May '19

11 May '19

Dear all, We have koha-17.05.06, installed using tarball method. I have followed the following methods for upgrading from koha-17.05.06 to koha-latest 1. Updated koha-list source accordingly koha-stable 2. Update all perl dependencies and cpan module vijay@debian:/usr/share/koha-18.11.04$ perl Makefile.PL /usr/share/koha-17.05.06/misc/koha-install-log /usr/share/koha/misc/koha-install-log and also vijay@debian:/usr/share/koha-18.11.04$ sudo perl Makefile.PL /usr/share/koha-17.05.06/misc/koha-install-log /usr/share/koha-18.11.04/misc/koha-install-log vijay@debian:/usr/share/koha-18.11.04$ sudo make vijay@debian:/usr/share/koha-18.11.04$ sudo make upgrade ------------------------------------------------------------------------------------ Getting the following error during upgrade Kindly suggest the proper method for up-gradation of koha-latest With regards, Vijay Kumar ::::error:::: vijay@debian:/usr/share/koha-18.11.04$ sudo make upgrade Can't locate C4/Installer/UpgradeBackup.pm in @INC (you may need to install the C4::Installer::UpgradeBackup module) (@INC contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 /usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base). BEGIN failed--compilation aborted. Makefile:22908: recipe for target 'make_upgrade_backup' failed make: *** [make_upgrade_backup] Error 2

1 0

Adding new "Sort 3" field for patrons
by drojup 10 May '19

10 May '19

Hi there, I would like to ask 1) how I can add a new e.g. "Sort 3" fields for patrons. 2) and If I can change the labels e.g. "Sort 1" to "Class" Thank you for your help. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 4

Problem in fine calculation in Koha LMS Release 16.11
by Dr. SK Gupta 10 May '19

10 May '19

Sir/Madam we are facing problem with fine calculation in Koha LMS. Even though all the information is filled in circulation and fine parameters, Koha is not calculating fine for patrons. Kindly help in resolving the issue Thanks & Regards -- *C**e**ntral Library* *SKUAST-Jammu* *Main Campus, Chatha-180009* *e-mail: clskuastj(a)gmail.com <clskuastj(a)gmail.com>* *Telefax: 0191-2262037* *Confidentiality Notice: *T*his electronic message transmission, including any attachment(s), may contain confidential, proprietary, or privileged information from the sender on behalf of Sher-e-Kashmir University of Agricultural Sciences and Technology of Jammu . If you are not the intended recipient, be advised that any dissemination, copying, distribution, printing or use of the contents of the information contained in this electronic message is strictly prohibited. If you have received this electronic message by error, please destroy all copies of the message and contact the sender immediately by either replying to this message or calling 91-191-2262037/9419277711.*

3 2

Book cover display from Amazon india koha 18.5
by Yatheesh lis 10 May '19

10 May '19

Dear all, Koha 18.5 unable show few Book cover even these cover available on Amazon website special indian books. There is no option available (Amazon india)

2 1

help with SQL query for the existence of a MARC field?
by Jason Vasche 09 May '19

09 May '19

Greetings Koha Community! First-time poster here, I'm fairly new to Koha and SQL. I've been trying to write a specific report with no luck. Here's what's happening: We're updating series authorities for our fiction collection. To start, I need to create a list of all our romance novels that have series fields (490, 8XX). This query returns the list of all our romance novels: SELECT biblio.biblionumber, biblio.title FROM biblio_metadata JOIN biblio ON (biblio_metadata.biblionumber = biblio.biblionumber) WHERE ExtractValue (metadata, '//datafield[@tag="092"]/subfield[@code="a"]') = 'ROM' The obstacle is trying to figure out what syntax to use to indicate the presence of a field (the contents of the field are irrelevant to this task.) I've tried various AND WHERE and AND EXISTS lines, but I'm fumbling around in the dark. Can anyone point me in the right direction? Thanks for your time and attention. Regards, Jason Vasché Catalog Librarian Round Rock Public Library

2 1