- Koha - lists.katipo.co.nz

Koha Version 3.9
by jackymasibo 21 Sep '12

21 Sep '12

Hi guys, My Koha system is up and running but am just wondering which Koha version am I running is it a stable release or development because after clicking on about Koha button I got the following information: About Koha Server information Koha version: 3.09.00.022 OS version ('uname -a'): Linux LIBRARY 2.6.32-5-686 #1 SMP Sun May 6 04:01:19 UTC 2012 i686 GNU/Linux Perl interpreter: /usr/bin/perl Perl version: 5.010001 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . MySQL version: mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using readline 6.1 Apache version: Server version: Apache/2.2.16 (Debian) Zebra version: Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU Please advise me if this version is the best for a production environment or if it’s not the best what should I do to change it to the current stable release? Thanks in advance

2 1

No search results?
by Seth Mayo 21 Sep '12

21 Sep '12

So I've found a really strange problem today... After starting work we realised that Koha would not give search results for any record in the database today. This includes searches in the catalogue and in the opac. I've seen similar things before so I checked that zebrasrv and mysqld are running...they are...even restarted the server a few times to prove they would start and a reboot wouldn't make a difference... I then told it to manually rebuild zebra - it seemed to do so fine but still no change. (Note: we have a cron that runs every 15 minutes and does this rebuild anyway) Looking at the log files I get the following. If anyone has an idea, please let me know - I'm out of them at the moment. koha-error_log: [Wed Sep 19 14:27:06 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:06 2012] circulation.pl: Use of uninitialized value in string gt at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 464., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl [Wed Sep 19 14:27:06 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:06 2012] circulation.pl: Use of uninitialized value in string gt at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 464., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl [Wed Sep 19 14:27:06 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:06 2012] circulation.pl: Use of uninitialized value in string gt at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 464., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl [Wed Sep 19 14:27:06 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:06 2012] circulation.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 644., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl [Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:23 2012] circulation.pl: Reference found where even-sized list expected at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 97., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl [Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:23 2012] circulation.pl: Use of uninitialized value $print in string eq at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 163., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl [Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:23 2012] circulation.pl: Use of uninitialized value in string eq at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 168., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl [Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:23 2012] circulation.pl: Use of uninitialized value $print in string eq at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 175., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl [Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:23 2012] circulation.pl: Use of uninitialized value in hash element at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 644., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl [Wed Sep 19 14:27:23 2012] [error] [client 172.16.255.226] [Wed Sep 19 14:27:23 2012] circulation.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 644., referer: http://tux-koha:8080/cgi-bin/koha/circ/circulation.pl koha-opac_log: [Wed Sep 19 13:32:53 2012] [error] [client 172.16.255.175] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha.stpeters.nsw.edu.au/ [Wed Sep 19 13:33:29 2012] [error] [client 172.16.255.226] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha.stpeters.nsw.edu.au/ [Wed Sep 19 13:35:30 2012] [error] [client 172.16.1.12] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha/ [Wed Sep 19 13:35:30 2012] [error] [client 172.16.1.12] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha/ [Wed Sep 19 13:35:33 2012] [error] [client 172.16.254.94] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha/ [Wed Sep 19 13:51:05 2012] [error] [client 172.16.4.222] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha.stpeters.nsw.edu.au/ [Wed Sep 19 14:07:30 2012] [error] [client 172.16.255.175] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha.stpeters.nsw.edu.au/ [Wed Sep 19 14:44:29 2012] [error] [client 172.16.254.230] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha.stpeters.nsw.edu.au/ [Wed Sep 19 23:03:43 2012] [error] [client 172.16.1.1] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha/ [Wed Sep 19 23:03:51 2012] [error] [client 172.16.1.1] File does not exist: /usr/share/koha/opac/htdocs/NoImage.png, referer: http://tux-koha/cgi-bin/koha/opac-search.pl?q=101 koha-zebradaemon.err: 20120703 17:38:53 koha-zebra-ctl.kohadb: client (pid 850) killed by signal 15, stopping 20120703 17:39:41 koha-zebra-ctl.kohadb: client (pid 848) killed by signal 15, stopping 20120712 11:27:24 koha-zebra-ctl.kohadb: client (pid 884) killed by signal 15, stopping 20120806 08:42:55 koha-zebra-ctl.kohadb: client (pid 866) killed by signal 15, stopping 20120806 09:21:50 koha-zebra-ctl.kohadb: client (pid 876) killed by signal 15, stopping 20120918 15:16:03 koha-zebra-ctl.kohadb: client (pid 864) killed by signal 15, stopping 20120918 15:42:42 koha-zebra-ctl.kohadb: client (pid 837) killed by signal 15, stopping 20120918 16:21:31 koha-zebra-ctl.kohadb: client (pid 856) killed by signal 15, stopping 20120919 11:55:14 koha-zebra-ctl.kohadb: client (pid 889) killed by signal 15, stopping 20120919 22:51:23 koha-zebra-ctl.kohadb: client (pid 899) killed by signal 15, stopping koha-zebradaemon-output.log: 22:07:15-19/09 zebrasrv(14) [warn] ir_session (exception) 22:07:20-19/09 zebrasrv(15) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/norm..LCK [Permission denied] 22:07:20-19/09 zebrasrv(15) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/shadow..LCK [Permission denied] 22:07:20-19/09 zebrasrv(15) [warn] ir_session (exception) 22:07:25-19/09 zebrasrv(16) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/norm..LCK [Permission denied] 22:07:25-19/09 zebrasrv(16) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/shadow..LCK [Permission denied] 22:07:25-19/09 zebrasrv(16) [warn] ir_session (exception) 23:03:50-19/09 zebrasrv(1) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/norm..LCK [Permission denied] 23:03:50-19/09 zebrasrv(1) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/shadow..LCK [Permission denied] 23:03:50-19/09 zebrasrv(1) [warn] ir_session (exception) koha-zebraqueue.err: 20120703 17:38:53 koha-zebraqueue-ctl-kohadb: client (pid 857) killed by signal 15, stopping 20120703 17:39:41 koha-zebraqueue-ctl-kohadb: client (pid 868) killed by signal 15, stopping 20120712 11:27:24 koha-zebraqueue-ctl-kohadb: client (pid 911) killed by signal 15, stopping 20120806 08:42:55 koha-zebraqueue-ctl-kohadb: client (pid 875) killed by signal 15, stopping 20120806 09:21:50 koha-zebraqueue-ctl-kohadb: client (pid 883) killed by signal 15, stopping 20120918 15:16:03 koha-zebraqueue-ctl-kohadb: client (pid 876) killed by signal 15, stopping 20120918 15:42:42 koha-zebraqueue-ctl-kohadb: client (pid 852) killed by signal 15, stopping 20120918 16:21:31 koha-zebraqueue-ctl-kohadb: client (pid 881) killed by signal 15, stopping 20120919 11:55:14 koha-zebraqueue-ctl-kohadb: client (pid 899) killed by signal 15, stopping 20120919 22:51:23 koha-zebraqueue-ctl-kohadb: client (pid 905) killed by signal 15, stopping koha-zebraqueue-output.log: DBD::mysql::db commit failed: MySQL server has gone away at /usr/share/koha/bin/zebraqueue_daemon.pl line 135. DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 758 DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 758 DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 758 DBD::mysql::st execute failed: MySQL server has gone away at /usr/share/koha/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/bin/zebraqueue_daemon.pl line 125. DBD::mysql::db commit failed: MySQL server has gone away at /usr/share/koha/bin/zebraqueue_daemon.pl line 135. DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 758 DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 758 DBI connect('dbname=kohadb;host=localhost;port=3306','koha',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line 758 Thanks, Seth Mayo IT Technical Manager Email: smayo(a)stpeters.nsw.edu.au ------------------------------------------------------- St Peter's Anglican Primary School Howe Street Campbelltown NSW 2560 PH: 02 4627 2990 DID: 02 8203 1368 Website: http://www.stpeters.nsw.edu.au

5 6

Would pls help us
by Dagne Woldie, MS/HS Library Assistant 21 Sep '12

21 Sep '12

Hello all, we are using koha 3.8. when we add new records to koha, the personal name text box is not enabled in 100a tag. is there a way to enable or how do we add personal author name. The same problem for adding series statement i.e 440a, Subject add enty personal name 600a, & add entry for personal name 700a, Dagne Woldie ICS library Addis Ababa

2 1

How to create CAS and SDI service
by sushant panigrahi 21 Sep '12

21 Sep '12

Dear Sir/Madam, How to generate the Current Awareness Service (CAS) and Selective Dissemination of Information (SDI) in Koha 3.0 Sushant

1 0

Acquisitions module
by Cab Vinton 20 Sep '12

20 Sep '12

We have never used Koha's acquisitions module. If you're on version 3.4 or higher & are using the module, I'd be curious to learn more about your experience. Has it worked well for you? Any tips, caveats or glitches to be aware of? Happy to compile & share any off-list responses. Thank you! Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast!

1 0

Acquisitions - seeing someone else's Basket
by Maxine Murphy 20 Sep '12

20 Sep '12

As a 'superlibrarian' I can see all Baskets that have been loaded by other staff. I have one staff member who helps me with acquisitions who can not see a Basket that I have generated via my logon. The staff member has all the (Acquisition) options ticked in her 'privileges'. Is there other option/s that also required ticks, so that she can see the Basket that I generated. Maxine Murphy

2 1

Incremental fine system in Koha
by Vimal Kumar V. 20 Sep '12

20 Sep '12

Dear Friends, In our library, move to Koha from SOUL ILS is in progress. Library staff alone are doing the migration process. We have no technical support from outside. We successfully transfered bibliographical details and patron details to Koha. One problem is with incremental fine system. Our fine system is that, first ten days .50 paise per day. After that Rs. 1 per day. Anybody made customization to run incremental fine system? Pls. share how it solved and help us to work out it. Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Browse by hierarchy - Links not working
by anjoze 20 Sep '12

20 Sep '12

Hi. I'm trying to set up the *Browse by hierarchy* on OPAC I have 2 problems: 1 - Links don't work For example, it shows: */classification 3/* (10 biblios) Than, when I click on /classification 3/ link, it says: No results found! 2 - The *Classification* names doesn’t show I've read http://wiki.koha-community.org/wiki/Opac_browse_feature and, it says: /The browser feature will build a browsable view of your catalogue. It will, for example, tell you that your catalogue contains : 1353 biblios about “Science” 5624 biblios about “Geography” 9835 biblios about “Spirituality” / On my page it doesn’t show the name (ex: Science) but the corresponding number, like in my first problem above: Shows /"Classification 3"/ instead of /"3 SOCIAL SCIENCES"/ I know this is experimental and for French Dewey catalogue, but, can anyone please provide detailed instructions to set it up correctly and, if possible, in other systems different of French Dewey? Is there anyone with this feature working? Thank you, ----- Koha version: 3.08.04 - - José Anjos -- View this message in context: http://koha.1045719.n5.nabble.com/Browse-by-hierarchy-Links-not-working-tp5… Sent from the Koha-general mailing list archive at Nabble.com.

6 9

Question about getting information for statistical reports
by Diedre Conkling 20 Sep '12

20 Sep '12

I am assuming this is a good place to ask this question. We, Chinook Library Network, are pretty new to Koha and are still working on fully understand how to do some things using Koha. One area where we could use a little more help is in pulling out information for statistical reports. This question probably particularly applies to those in the U.S. Every year we need to fill out statistical reports for the state libraries and, ultimately, the IMLS (Institute of Museum and Library Services). I am sure other libraries have had to do the same thing. From Koha we need to get information about how many items we have and how many patrons we have. We also need to know the circulation for the year. The items are broken out in categories like adult books, dvd's, etc. and children's books, dvd's, etc. Can those of you who have done this give us some clues on the best ways to pull together this information? We need the information for each library in our network. We do not need it for the network as a whole. This year we are only looking at a few weeks of information so it is not a major issue. The rest of our statistics we already pulled off of our old ILS. However, we would like to be able to pull together some of this information for each month and for next year. We also are interested in finding out the best way to create reports of daily circulation that would include checking out items at the library for that library's patrons and the items we send on intralibrary loan to other libraries in our network. Thanks for any information you can send our way. -- *Diedre Conkling** Lincoln County Library District P.O. Box 2027 Newport, OR 97365 Phone & Fax: 541-265-3066 Work email**: **diedre(a)lincolncolibrarydist.org*<diedre(a)lincolncolibrarydist.org> * Home email: **diedre08(a)gmail.com* <diedre08(a)gmail.com> "If you don't like something, change it. If you can't change it, change your attitude."--Maya Angelou

2 1

Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed
by Doug Dearden 20 Sep '12

20 Sep '12

Hi all, No issues here, just following up in case someone is looking at this thread in the future. I updated the database using the sql statement below, and it deleted most of the 852 datafields. I thought all was well but a week or so later found a record that still had some 852 datafields in it. Upon investigation I found a number of records - around 400, and all of them had multiple 852 datafields - at least two per record. I did some experimentation and the sql statement below only works on those records where there is a single 852 datafield. I tried some variations and found that if I ran this one it would remove the first 852 datafield: update biblioitems set marcxml = UpdateXML(marcxml, '//datafield[@tag="852"][1]', ''); I did a backup, ran the sql statement above several times until it returned 0 records changed (17 in fact, as I had one record with 16 852 datafields). Each time it ran it stripped off the leading 852 datafield. I then ran this one to check for any leftovers: SELECT ExtractValue (marcxml ,'//datafield[@tag="852"]/*') FROM biblioitems WHERE marcxml RLIKE '<datafield tag="852"'; It returned zero results. Ran touch_all_biblios.pl Zebra indexes rebuilt that night as part of our regular cron job. All looks good. - Doug -----Original Message----- From: Galen Charlton [mailto:gmc@esilibrary.com] Sent: Tuesday, August 28, 2012 3:42 PM To: Doug Dearden Subject: Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed Hi, No, whitespace between datafield elements is irrelevant as far as Koha's parsing of the MARCXML records is concerned. Regards, Galen On 08/28/2012 04:27 PM, Doug Dearden wrote: > Hi Galen, > > I ran the sql command against my test DB to delete the 852 tag limiting it to one record. It takes out the 852 datafield but leaves behind some blank space - example below. Is this going to matter? - Thanks, Doug > > <datafield tag="700" ind1=" " ind2=" "> > <subfield code="a">Hymes, Dell, editor.</subfield> > </datafield> > > <datafield tag="942" ind1=" " ind2=" "> > <subfield code="c">BK</subfield> > </datafield> > > -----Original Message----- > From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Galen Charlton > Sent: Tuesday, August 28, 2012 12:59 PM > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Fwd: Re: Barcode info and maybe SQL/MARCXML help needed > > Hi, > > On 08/28/2012 02:56 PM, Galen Charlton wrote: >> Unless you had changed your MARC frameworks to use the 852 field for >> item data rather than the 952, if the 852s are from your previous >> system, I'd suggest that you actually *delete* them. A bib export from >> Koha will include the item data in 952 fields if you need them for >> record interchange or union catalog purposes, and getting rid of the >> legacy 852s avoids the risk of confusing staff about the state of an >> item record. > > And you can delete the 852 fields in two steps (or three, counting the > backup you should make first :) ). First, run the following SQL update: > > update biblioitems set marcxml = UpdateXML(marcxml, > '//datafield[@tag="852"]', ''); > > Then run touch_all_biblios.pl, which will (in addition to signalling > that the bibs should be reindexed) synchronize biblioitems.marc with > biblioitems.marcxml. > > Regards, > > Galen > -- Galen Charlton Director of Support and Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

2 1