- Koha - lists.katipo.co.nz

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

Installing v 2.0* on Mac os x
by Philip Sturman 19 Mar '04

19 Mar '04

Hi all, I've just downloaded Koha (2.0.0RC4) and installed it, but haven't managed to get it running yet. It seems the installation documents on the Koha site is a bit out of date, and not applicable to the mac-version of Apache-filestructure. I can't make sense of the instructions in the manual at: http://koha.org/manual/book1_library_it_support.html Stuff like this: "koha distro koha\* into /pathto/cgi-bin/oadmin (including C4 directory and its contents)." The C4 directory is not in the root of the koha-directory anymore, and what files are referred by koha\* ? I would be immensely thankful for anyone to straighten this out for me. What do I have to change in the httpd.conf file, and what files are supposed to be in what directories? regards P. Sturman

2 1

Koha on Mac OS X?
by Paul Bentley 19 Mar '04

19 Mar '04

Hi - has anyone installed Koha on Mac OS X? pb

1 0

Z3950 "Still ?? requests to go"
by Charles Erwin 18 Mar '04

18 Mar '04

Hello, I tried to add a biblio on the intranet menu for Koha 2.00RC4 and I get the message "Still ?? requests to go". What does this mean? It acts like it's not even processing the ISBN I entered. Thanks, Charles Erwin

2 1

z3950 server/client problem
by Serge RENAUX 18 Mar '04

18 Mar '04

Hi, I try to test a z3950 server and a z3950 client . My z3950 server runs well ./zed-koha-server.pl daemon I run the ./processz3950queue daemon in my z3950 client When it try to search from a title or an ISBN from my z3950 client it did not find anything. I got the Error message below from my ./processz3950queue daemon DBD::mysql::st execute failed: Unknown column 'z3950random' in 'field list' at /usr/share/perl5/C4/Breeding.pm line 115. Do you know where is the mistake ? Regards Serge -- Serge Renaux Groupe ESIEE / CCI Paris EMail:s.renaux@esiee.fr Tel:(33)1.45.92.67.46

2 1

Re: Re: [Koha] Data being stored in incorrect fields
by baljkas＠mts.net 16 Mar '04

16 Mar '04

Monday, March 15, 2004 16:00 CST Stephen, Silly question maybe, but why would item types have anything to do with the MARC mixing up like that? Just curious. Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada > From: "Stephen Hedges" <shedges(a)skemotah.com> > Date: 2004/03/15 Mon AM 09:35:12 CST > To: "T & J Kotula" <tjkotula(a)paradise.net.nz> > CC: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Data being stored in incorrect fields > > Tomasz - > > Have you set up your item types in the parameters? That was the solution > to Michael's problem. > > Stephen > > T & J Kotula said: > > Michael and Stephen > > > > I'm glad you found it too. I just discovered it too a couple of days ago, > > but haven't had a chance to finish my email. > > > > When I use z3950search and then hit the link to import that info, > > everything > > looks fine. I can go and click on each numeric link, hit reload - no > > problems. However when I search for this newly added book most of the > > fields > > are out of sync, as follows: > > > > 010|a LC --- OK > > 020|a ISBN --- OK > > 100|a Name --> 852|k Call Number > > 245|a Title --> 100|g Miscellaneous information > > 260|c Date of publication -->245|a Title > > 300|a Extent --> 260|c Date of publication > > 300|c Dimension --> 300|a Extent > > > > In my case I haven't fiddled with any MARC stuff and my MARC flavor is > > MARC21 (as well as for each z3950.server). > > > > Looking forward to your replies. > > > > PS. In my desperation I was just about to reinstall koha, but finding out > > that it's not just me, I'll wait for the next release :-) > > > > tomasz kotula. > > > > > > > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > -- > Stephen Hedges > Skemotah Solutions, USA > www.skemotah.com -- shedges(a)skemotah.com > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

2 1

Re: [Koha] Data being stored in incorrect fields
by T & J Kotula 15 Mar '04

15 Mar '04

Michael and Stephen I'm glad you found it too. I just discovered it too a couple of days ago, but haven't had a chance to finish my email. When I use z3950search and then hit the link to import that info, everything looks fine. I can go and click on each numeric link, hit reload - no problems. However when I search for this newly added book most of the fields are out of sync, as follows: 010|a LC --- OK 020|a ISBN --- OK 100|a Name --> 852|k Call Number 245|a Title --> 100|g Miscellaneous information 260|c Date of publication -->245|a Title 300|a Extent --> 260|c Date of publication 300|c Dimension --> 300|a Extent In my case I haven't fiddled with any MARC stuff and my MARC flavor is MARC21 (as well as for each z3950.server). Looking forward to your replies. PS. In my desperation I was just about to reinstall koha, but finding out that it's not just me, I'll wait for the next release :-) tomasz kotula.

2 1

Migrating from ISIS to Koha
by Baiju M 13 Mar '04

13 Mar '04

Hi, I am helping a librarian for converting his CDS/ISIS Data to Koha. Have anyone experiance with this kind of convertion? Any easy tools available for convertion? I started studying perl and MARC module. The migration guide posted to this list was very helpful. With thank and regards, Baiju M Punnasserikandi, Kizhuparamba P.O Areecode - 673639 Malappuram Kerala, India ____________________________________________________________ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.as…

3 2

INSTALLING KOHA IN AN EXISTING WEBSITE !!!
by Adalid Ortiz 13 Mar '04

13 Mar '04

Any procedure to install Koha in an existing functional website without affect it? The first time I'installed Koha on Windows, the installer change my apache configuration file and default start pages, etc. Then create another instance of apache to run only Koha for testing porpuses. I'have a virtual domain in a Debian Linux Server and want to install without affect anything. Some years ago I read in the list that can be done but don't remember the link. Gracias, LIC. FELIPE ADALID ORTIZ ANZALDO Area de Medios Electrónicos Biblioteca Loyola http://www.loyola.tij.uia.mx UNIVERSIDAD IBEROAMERICANA TIJUANA Ave. Centro Universitario 2501 Playas de Tijuana Tijuana, B.C., México 22200 Tel. 664 630-1577 Ext. 623 Fax 664 630-1591 eMail adalid(a)tij.uia.mx "No sobreviven los más fuertes, ni los más inteligentes, sino aquellos que tienen una mayor capacidad para adaptarse a los cambios." --Charles Darwin--

2 1