- Koha - lists.katipo.co.nz

Who is the borrower?
by talia.alton＠iird.vic.gov.au 30 Mar '04

30 Mar '04

We are happily using KOHA 1.2.3. How do I find out, who is the borrower of a certain book? Thanks, Talia Alton Business Information and Research Unit Department of Innovation, Industry and Regional Development talia.alton(a)iird.vic.gov.au _____________________________________________________________ Department of Innovation, Industry and Regional Development Government of Victoria, Victoria, Australia. This e-mail and any attachments may contain privileged and confidential information. If you are not the intended recipient, you may not distribute or reproduce this e-mail or the attachments. If you have received this message in error please notify us by return e-mail. ______________________________________________________________

2 1

(no subject)
by lcurrie＠calacademy.org 29 Mar '04

29 Mar '04

1 0

(no subject)
by pate＠eylerfamily.org 26 Mar '04

26 Mar '04

1 0

Howard Dahdah/Australia/IDG is on Holidays
by Howard_Dahdah＠idg.com.au 26 Mar '04

26 Mar '04

I will be out of the office starting 26/03/2004 and will not return until 06/04/2004. Any questions for IDG Online can be directed to Nadia Cameron nadia_cameron(a)idg.com.au or Steven Deare steven_deare(a)idg.com.au Thanks, Howard

2 1

Solved: Z3950 Searches Stopped Working
by Ken & Brenda Voelker 25 Mar '04

25 Mar '04

Just for the record, I was able to fix the problem, thanks to a message posted by Mike Taylor (the author of Net::Z3950) to the Net-Z3950 mailing list (see October 23, 2003). Don't understand why others haven't run into this problem, nor do I understand why it appeared so suddenly on my installation. In any event, in order to get it captured into this archive, here's a synopsis: Problem: MARC searches suddenly quit working altogether - the ISBN's remained in the search list, and Koha would continue to query the L.O.C. servers until the list was manually cleared. The z3950-daemon log in /var/log/koha showed an error message of the form: ERROR: Can't call method "option" on an undefined value at /var/www/library/koha/intranet/scripts/z3950daemon/processz3950queue line 163, <KC> line 22. Here's Mike's reply to someone who ran into the same problem: >Net::Z3950 is not guilty! The culprit here is the Library >of Congress's, <ahem> somewhat eccentric Z39.50 server. > >Remember that, as documented, the default record-syntax requested by >Net::Z3950 programs is GRS-1. The LoC server doesn't support GRS-1 >records. > >To fix your problem, you need to tell Net::Z3950 that you want to >fetch USMARC records from this connection. CURE: in the module /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue, look for the line that creates the new Z3950 connection: eval { $conn= new Net::Z3950::Connection($servername, $port, databaseName => $database); }; and modify it to explicitly spell out the record syntax you want, i.e. USMARC: eval { $conn= new Net::Z3950::Connection($servername, $port, databaseName => $database, preferredRecordSyntax => 'USMARC'); }; (Actually, you'll make this correction twice, because the command appears in the module twice, once with and once without password authentication). Don't forget to halt and re-start the Z3950 daemon, in order for the changes to take effect. (Or just reboot).

2 1

Adding Serials to Koha
by Bernadette Cassidy 25 Mar '04

25 Mar '04

Hi, I'm using the simple acquisitions module in Koha and I have a question re serials. Once I've created the biblio record and added the first issue, how can I then add subsequent issues without having to create another biblio?!! I know this can be done, I just don't know how to do it. Many thanks, Bernadette ___________________________________________ Bernadette Cassidy Library & Learning Coordinator Allan Bean Centre for Research and Learning in Rehabilitation Private Bag 4708 Burwood Hospital Christchurch New Zealand Tel: (03) 383 9492 Fax: (03) 383 7500

2 1

MARC opac searching
by Michael Watson 24 Mar '04

24 Mar '04

Greetings, I am looking at customizing the public search interface of Koha 2.0.0RC4, and would like to confirm my understanding of how it works before charging into it. It looks to me as if Koha stores bibliographic records in a sort of "Koha-native", non-MARC format in the biblio table, as well as storing MARC records in the marc_subfield_table. When an end user performs an "advanced" search of the catalog on a newly-installed system, the page he sees is generated by opac-search.pl; the search form on that page has as its action the perl script opac-searchresults.pl. I'm still dissecting the flow of the program, but it looks like opac-search.pl and opac-searchresults.pl use the templates opac-search.tmpl and opac-searchresults.tmpl, in which I see references to functions in Search.pm. As I look at the sql statements in Search.pm, these functions do seem to hit only the "biblio" table. I also see a "SearchMarc.pm". I'm wondering if this is where the marc-searching functionality used in the staff (intranet) portion of Koha is hidden. If I wanted to modify Koha so that, for example, the publicly available interface does all author searches against 100 | a and 110 | a in the marc_subfield_table , instead of simply against the author field in the "biblio" table, am I correct in concluding that what I need to do is to edit opac-searchresults.pl, opac-searchresults.tmpl, and possiblly SearchMarc.pm? Thanks, Mike Watson thornswabbler(a)earthlink.net

2 1

More re: Z3950 Searches Stopped Working
by Ken & Brenda Voelker 20 Mar '04

20 Mar '04

Further to my original posting, the lookup failures all have entries in the z3950-daemon-xxxxx.log that have the following form: Processing isbn="0310250641" at 1 z3950.loc.gov:7090 voyager (1 forks) Q: @attr 1=7 "0310250641" ERROR: Can't call method "option" on an undefined value at /var/www/library/koha/intranet/scripts/z3950daemon/processz3950queue line 163, <KC> line 22. z3950.loc.gov:7090 done. What is this trying to tell me?

1 0

Z3950 Searches Stopped Working
by Ken & Brenda Voelker 20 Mar '04

20 Mar '04

Anyone have any hints for troubleshooting Z3950 searches? I've been using Koha's MARC search function for many months, and have retrieved MARC records for hundreds of books. Then, it suddenly quit working a couple of weeks ago. Everything else works - all the rest of Koha, my internet connection, etc. If I use Ethereal to monitor the LAN traffic, I can see my computer connecting to the Voyager server at Library of Congress, getting an acknowledgement, sending the ISBN number, and then getting a fairly short response. Then the whole sequence repeats, every five seconds or so, until I clear the search list. This happens even with ISBN's that have worked in the past. I've made no significant changes to the computer in this time frame, have rebooted numerous times, and even downloaded the latest version of Net::Z3950. I'm using Koha-1.2.3. Anyway, I guess my next approach is to try and understand the bits being sent/received during the Z3950 transaction, and see what my computer is being told by LOC. If anyone has any ideas for translating the protocol PDU's back into plain English, (or other troubleshooting hints), I'd appreciate hearing them.

1 0

Koha 2.0.0RC4 MYSQL Errors
by Erwin 19 Mar '04

19 Mar '04

Hello, I am getting these errors in the koha-error_log file in /var/log/apache2: library apache2 # cat koha-error_log [Fri Mar 19 13:34:58 2004] [error] [client 10.20.3.14] DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/local/koha/intranet/modules/C4/Search.pm line 2479., referer: http://library.cs.transy.edu:8080/cgi-bin/koha/acqui.simple/addbiblio.pl?is… [Fri Mar 19 13:34:58 2004] [error] [client 10.20.3.14] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Search.pm line 2480., referer: http://library.cs.transy.edu:8080/cgi-bin/koha/acqui.simple/addbiblio.pl?is… I do not know what they mean, but they appeared when I attempted the z3950 search function (which still presents the "Still ?? requests to go" message). I've run the z3950-daemon-launch.sh but it just immediately returns me to the prompt. A log file appeared in /usr/local/koha/log/ but it has nothing in it. I'm sorry for all the posts but we really have no idea what is going on here and help would be really appreciated. Thanks, Charles Erwin

2 1