- Koha - lists.katipo.co.nz

RESTORING DATABASE TO NEW INSTALLATION OF KOHA
by Jack Boulier 22 Mar '18

22 Mar '18

I have just installed the Ubuntu Xenia 16.04 with the latest updates and installed Koha 17.11.03, to my system. I did the install of Koha using apt-get install koha-common. did a transfer of my database with mysql -uroot -p < path/koha.sql. My database with all data is installed in my koha_jackslibrary. I am unable to see my library at localhost:80, it displays under maintenance, and 8080 is asking for a username and password. None of the logins work to gain access to the system. My browser is Chromium. I just don't care for Firefox. I am at a lost for the next step. Any ideas would be appreciated. Thanks,Jack

3 2

Library Attendance Monitoring
by Ma. Victoria H. Silva-Manuel 21 Mar '18

21 Mar '18

Hi. Can Koha be used as library attendance monitoring? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

3 2

Delete Authorized values category
by Narcis Garcia 21 Mar '18

21 Mar '18

(Koha 17.11) In Administration -> Authorized values I've created a category with a wrong name. How can I remove it? Thanks.

4 5

Koha Performance
by JanM 20 Mar '18

20 Mar '18

Hi, i'm new to Koha and at the university i'm working at we have a small library with about 50 items. We have a small server where Koha is running on. Plack is also enabled. We are running a Mariadb on an other server. The problem is, that it takes about 10 seconds for a request to be answered. In example a User is searching for "Alters-Konzentrations-Test" and the result takes about 10 seconds. Also the whole navigation on the page feels slow. Per search request there are about 4000 queries sent to the database server, is this normal? What else can I check? Kind regards Jan -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

4 20

SQL expertise ...
by Carl Thompson 20 Mar '18

20 Mar '18

Can anyone help verify if these queries will work? Don't have access to system to verify and trying to help other Koha users complete these questions on the PLDS Annual Survey. /* calculate annual average days of circulation of items by item type */ SELECT r.itemtype, sum(r.datetime-b.datetime)/count(r.datetime) as *avg_days_of_circ* FROM statistics r, statistics b WHERE r.type='return' and b.type='issue' AND r.itemnumber=b.itemnumber AND r.borrowernumber=b.borrowernumber AND year(r.datetime)=2017 GROUP BY r.itemtype; /* the number of original circulations (not including renewals) by item type */ SELECT itemtype, count(*) as *intitial_circ* FROM statistics WHERE type='issue' AND year(datetime)=2017 GROUP BY itemtype; /* the number of renewals by item type */ SELECT itemtype, count(*) as *renewals* FROM statistics WHERE type='renewal' AND year(datetime)=2017 GROUP BY itemtype; Thanks! -- Carl Thompson <cthompson(a)countingopinions.com> Counting Opinions <http://www.countingopinions.com/> (866) 994-0904 <+18669940904>

1 0

cataloguing in koha according to RDA
by Javed Sahil 19 Mar '18

19 Mar '18

Hi all, Can we make catalogue entries in koha according to RDA? if yes plz guide where to select or chooseRDA in koha? Regards, Javed Shoukat Lahore University of Management Sciences (LUMS), Lahore, Pakistan.

3 3

Upgrading from Ubuntu 14.04 to 16.04
by Tim Auld 19 Mar '18

19 Mar '18

Hi Everyone, I am running Koha 16.05 on Ubuntu 14.04. I'm planning on upgrading the OS to Ubuntu 16.04. Can anyone who has done this please share your experiences with me? Will I need to upgrade Koha at the same time for everything to work? Regards, Tim Auld Northern Philatelic Library.

1 0

Title search caching oddity
by Barton Chittenden 19 Mar '18

19 Mar '18

I've been working with one of our partner libraries trying to explain the difference between title search by phrase and title keyword search the example that he gave me was ti,phr: Little Women This returned 39 results. Running the same search without using 'phr' ti: Little Women yielded the same 39 results. After poking around at all of the possible marc fields indexed as title, I determined that there were indeed exactly 39 records containing the exact string "Little Women" -- it struck me as odd that there would not be more results in the keyword search... so I reversed the search terms: ti: Women Little returned 110 results and ti,phr: Women LIttle returned none. This is more like what I expected. I went to file this as a bug, and on my next pass through, the keyword search for 'LIttle Women' (in the original order) returned 110 results. It's obvious that there's some sort of caching going on, but I have no idea where.

1 0

Report help
by Mutasem Al Shami 19 Mar '18

19 Mar '18

Hi, any one can help me, i need report to count number of search book in koha. thank, Mutasem -- ------------------------------ Disclaimer: This message and its attachment, if any, are confidential and may contain legally privileged information. If you are not the intended recipient, please contact the sender immediately and delete this message and its attachment, if any, from your system. You should not copy this message or disclose its contents to any other person or use it for any purpose. Statements and opinions expressed in this e-mail are those of the sender, and do not necessarily reflect those of Al Maarefa College (MCST). All opinions and/or views expressed in this email are solely those of the author and do not necessarily represent those of MCST, MCSTaccepts no liability for damage caused by any virus transmitted by this email. تنويه: هذه الرسالة ومرفقاتها (إن وجدت) تمثل وثيقة سرية قد تحتوي على معلومات تتمتع بحماية وحصانة قانونية. إذا لم تكن الشخص المعني بهذه الرسالة يجب عليك تنبيه المُرسل بخطأ وصولها إليك، وحذف الرسالة ومرفقاتها. ولا يجوز لك نسخ هذه الرسالة أو مرفقاتها أو أي جزء منها، أو البوح بمحتوياتها لأي شخص أو استعمالها لأي غرض. علماً بأن الآراء والإفادات التي تحويها هذه الرسالة تعبر فقط عن رأي المُرسل وليس بالضرورة رأي كلية المعرفة، ولا تتحمل كلية المعرفة أي مسئولية عن الأضرار الناتجة عن أي فيروسات قد يحملها هذا البريد.

2 1

koha-sitemap
by Rubeno Fernández 19 Mar '18

19 Mar '18

Hello all, I'm trying to have crawl bots keep off my catalogue. Has anybody ever used the command koha-sitemap? On Koha 17.11 for Debian it seems to be broken: root@biblioteko:~# koha-sitemap --generate biblioteko Sitemap directory for biblioteko doesn't exist. Creating. Can't locate Koha/Exceptions/Exception.pm: ./Koha/Exceptions/Exception.pm: Permission denied at /usr/share/perl/5.22/base.pm line 97. ...propagated at /usr/share/perl/5.22/base.pm line 106. BEGIN failed--compilation aborted at (eval 16) line 3. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Exceptions.pm line 69. Compilation failed in require at /usr/share/koha/lib/Koha/DateUtils.pm line 22. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/DateUtils.pm line 22. Compilation failed in require at /usr/share/koha/lib/C4/Log.pm line 30. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Log.pm line 30. Compilation failed in require at /usr/share/koha/lib/Koha/Config/SysPref.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Config/ SysPref.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Context.pm line 105. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Context.pm line 105. Compilation failed in require at /usr/share/koha/lib/C4/Koha.pm line 26. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Koha.pm line 26. Compilation failed in require at /usr/share/koha/lib/C4/Biblio.pm line 32. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Biblio.pm line 32. Compilation failed in require at /usr/share/koha/bin/cronjobs/sitemap.pl line 26. BEGIN failed--compilation aborted at /usr/share/koha/bin/cronjobs/sitemap.pl line 26. I tried to run the script sitemap.pl by hand, without success: perl -I /usr/share/koha/lib /usr/share/koha/bin/cronjobs/sitemap.pl --url biblioteko.esperanto.cat unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. Use of uninitialized value in concatenation (.) or string at /usr/share/koha/ lib/C4/Templates.pm line 154. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. Use of uninitialized value in concatenation (.) or string at /usr/share/koha/ lib/C4/Auth_with_cas.pm line 42. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/ C4/Context.pm line 243. Can't call method "config" on unblessed reference at /usr/share/koha/lib/Koha/ Database.pm line 56. The config file it doesn't find may be the one located at /etc/koha/sites/ biblioteko/koha-conf.xml.

1 0