- Koha - lists.katipo.co.nz

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

missing circulation history (old_issues table lost 96% of records)
by Benjamin Anderson 09 May '19

09 May '19

Hi, About 4 months ago we upgraded from version 3.18.05.100 to 18.11.01.000. Just recently, our librarian let me know that the circulation history now only has the last month or so, whereas it used to have everything since the library began circulating books. She is convinced that this issue was not manifest after the initial upgrade, but only started a few weeks ago (some months after the upgrade). She doesn't know if it happened all at once or incrementally. Unfortunately, I only have db backups going back 2 days and by the time I was alerted to the problem, those backups also were missing the full old_issues set. I'm not familiar with the db schema, but in taking a look I noticed that the db snapshot from before the migration had 16,255 records: administrator@sjbs-library-server:~$ mysql -D koha_sjbs -u koha_sjbs -e "select count(*) from old_issues;" +----------+ | count(*) | +----------+ | 16255 | +----------+ meanwhile the current db only has 598 records. In googling, I came across the auto increment issue, but I'm pretty sure that's what I'm dealing with here. Questions: 1) Any idea how we lost all these records? Is there a configuration setting somewhere that would explain this? Or is something else going on? 2) Can I re-import the old_issues from the db snapshot I have with 16k rows into the current db? I understand this would take a little finessing because there isn't an id in the old schema and the auto increment is on the issues table (not old_issues). Assuming I got all of that worked out, is this a reasonable thing to do? 3) How do I keep more than 2 snapshots of db backups? I'd prefer to keep a month or so. Thanks, Ben

2 1

Regarding DBMS Auto increment fix
by Sambhunath Sahoo 09 May '19

09 May '19

Dear friends, *Is DBMS auto increment fix required for Koha 18.11.05 (Current version)? Yes/No* In Koha wiki site, it shows only for Koha 16.05, 16.11, and 17.05. There is nothing written for Koha 18.05 and Koha 18.11. Regards, Sambhunath Sahoo/सम्भुनाथ साहु Information Scientist, Central Library, Tezpur University, Tezpur-784028 Assam Mobile: 9085252152, 8895488636 Phone : 03712-27-3229 E-Mail : sambhumlis(a)gmail.com, sambhu(a)tezu.ernet.in *ORCID ID:* 0000-0001-9162-879X *Researcher ID:* K-4446-2018

4 3

Run opac and intranet on different domains
by Coehoorn, Joel 09 May '19

09 May '19

We're looking at running our opac at catalog.york.edu and our intranet at circulation.york.edu. Both addresses will resolve to the same server when we go live, and I already have the Apache virtual host configuration working internally. I even have http => https redirection working. What else do I need to do to configure Koha to support this? For example, the "Open in OPAC" links when browsing the catalog from the intranet need to know the other name; where would I set that? What else should I watch for? 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

4 3