[Koha] z3950 problem in 2.0.0pre2
Lars Anderson
lsa at business.auc.dk
Mon Jul 21 19:59:39 NZST 2003
On Fri, Jul 18, 2003 at 19:08:21, Chris Michalak wrote:
Hi, Chris,
>
> Yes I am able to import data from a z3950 server. I'm very new to Koha
> and library software in general so my experience is limited. I tried
Well, me too.
> about a half dozen different things and I don't remember everything I
> did. Of those things I'm sure only 1-2 had anything to do with my
> success!
>
> One change I remember making is setting the MARC type field for the LOC
> server to USMARC (it defaults to a NULL value). You may want to try
> doing this if you haven't already.
>
I had set it for UNIMARC, but setting it to USMARC helped, thanks.
Lars
> For the record, here is what I get in the processz3950queue log file
> after a successful lookup :
>
> LOC ==> USMARC at
> /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156.
> LOC ==> answered : 1 found at
> /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 170.
> Processing isbn="0201648652" at LOC z3950.loc.gov:7090 voyager USMARC (1
> forks)
> z3950.loc.gov:7090 done.
>
> If I decide to do a clean install again I will try to document exactly
> what I do to get things to run and send you the info. However I'm
> probably going to set this project aside for a little while and wait for
> a future release of Koha.
>
> I hope things work out for you!
>
> Chris
>
>
>
> On Fri, 2003-07-18 at 02:50, Lars Anderson wrote:
> > On Thu, Jul 17, 2003 at 12:39:02, Krzysztof Michalak wrote:
> >
> >
> > Hi Krzysztof,
> >
> > I have expirienced exactly the same as you have described below, only I cannot
> > seem to get the result into Koha, are you successfully importing data via Z3950?
> >
> > When I do a search I can se the following in my log:
> >
> > LOC ==> at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156.
> > LOC ==> answered : 1 found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line
> > 170.
> > Processing isbn="0201896842" at LOC z3950.loc.gov:7090 voyager (1 forks)
> > z3950.loc.gov:7090 done.
> >
> > But after that nothing happens.
> >
> > I would love to hear how you got it working.
> >
> > Best wishes,
> > Lars
> >
> > >
> > > Thanks Jerome,
> > >
> > > I actually did add the z3950random column to the table after posting my
> > > message yesterday. I did not add an encoding column, I guess I should do
> > > that too.
> > >
> > > One other source of the problem I identified was that when a z3950
> > > server has a space in it's name the script gets confused. This is
> > > particularly a problem since the default install has a server named
> > > "Library of Congress". To fix the problem I simply renamed it to LOC. I
> > > guess the problem arises from line 99 of processz3950queue :
> > >
> > > foreach $serverinfo (split(/\s+/, $servers)) {
> > >
> > > Things seem to work ok now.
> > >
> > > Chris
> > >
> > >
> > > On Wed, 2003-07-16 at 23:32, Jerome Vizcaino wrote:
> > > >
> > > >
> > > > On Wed, 2003-07-16 at 22:04, Krzysztof Michalak wrote:
> > > > > Sorry to reply to my own message, but I wanted to add that I also get
> > > > > the following errors in the koha log :
> > > > >
> > > > > [Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] search.pl : / /
> > > > > / at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 52.
> > > >
> > > > The / / / means that the page failed to send the parameters
> > > > (isbn/title/author if I remember correctly) to the z3950 script.
> > > >
> > > > > [Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] Q : Select
> > > > > id,file,isbn,title,author from marc_breeding where z3950random =
> > > > > "378733019.883843" at /usr/local/koha/intranet/modules/C4/Search.pm line
> > > > > 2429.
> > > > > [Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] DBD::mysql::st
> > > > > execute failed: Unknown column 'z3950random' in 'where clause' at
> > > > > /usr/local/koha/intranet/modules/C4/Search.pm line 2431.
> > > >
> > > > This is due to an error in the database script creation. You'll have to
> > > > add the z3950random column to your marc_breeding table.
> > > >
> > > > In case I give you the command :
> > > > ALTER TABLE marc_breeding ADD COLUMN z3950random varchar(30);
> > > >
> > > > Also it seems the "encoding" column is missing too :
> > > > ALTER TABLE marc_breeding ADD COLUMN encoding varchar(40);
> > > >
> > > > > [Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] DBD::mysql::st
> > > > > fetchrow_hashref failed: fetch() without execute() at
> > > > > /usr/local/koha/intranet/modules/C4/Search.pm line 2432.
> > > > >
> > > >
> > > > Invalid SQL syntax => execute failed...
> > > >
> > > > Hope that helps.
> > > > Good luck.
> > > >
> > > > Jerome
> > > >
> > > >
> > > > _______________________________________________
> > > > Koha mailing list
> > > > Koha at lists.katipo.co.nz
> > > > http://lists.katipo.co.nz/mailman/listinfo/koha
> > >
> > >
> > > _______________________________________________
> > > Koha mailing list
> > > Koha at lists.katipo.co.nz
> > > http://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
--
Lars Anderson mailto:lsa at business.auc.dk
Department of Business Studies http://www.business.auc.dk/~lsa/
Aalborg University Voice: +45 96358225, Fax: +45 98153505
Denmark Office: Fib4-117
More information about the Koha
mailing list