Re: [Koha] Problems with Z3950 search

dmoses2@uwo.ca wrote:

>>I just installed koha2.0.0RC2 but I'm having problems with z3950 searching.
>>I ran z3950-daemon-launch.sh first, then typed an ISBN number into
>>acqui.simple/addbooks.pl, then 'Go' followed by 'Add New Biblio' and finally
>>'z3950 search' button.
>>
>>Well I get the same message I always used to get in the past "Still ??
>>requests to go".
>>
>>koha-error.log contains:
>>search.pl :  /  /  /  at /usr/local/koha/intranet/cgi-bin/z3950/search.pl
>>line 52.
>>NO RANDOM at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 59.
>>DBD::mysql::st execute failed: You have an error in your SQL syntax near ''
>>at line 1 at /usr/local/koha/intranet/modules/C4/Search.pm line 2480.
>>DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at
>>/usr/local/koha/intranet/modules/C4/Search.pm line 2481.
>>
>>I really would like to get z3950 working so I can start cataloguing books.
>>Can someone please help me.
>>    
>>
After a look in Search.pm, I see 2 possibilities :
* did you type an ISBN, or a title, or an author, BEFORE clicking on 
"z3950 search". Because the search can be done only on those 3 fields 
for instance.
* did you "link" ISBN & title & author MARC21 field to the corresponding 
biblio or biblioitems in mySQL table.
A 3rd possibility : what's the structure of marc_breeding table.
For me it contains a z3950random varchar(40) field (even on 200RC2 DB 
installed from scratch. i don't think there is a bug here)

-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)