[Koha] Z39.50 problem

[Greg Vickers]

Hi Stephen,

Stephen Hedges wrote:
> Greg, what is the search term you are using (ISBN, title, etc.)?  I assume
> the Z3950 daemon is started and running, right?

I was just using trash to search, i.e. title 'fred' - does this
information have to be real?

You know, I don't think the daemon is running ... *blush* This will be
the client daemon that will talk to an external z3950 server, correct? I
assume it is included in the yaz toolkit? If so, what is the name of the
daemon executable and is there an init script provided to start it at
boot time?

Thanks,
Greg

> Stephen
> 
> Greg Vickers wrote:
> 
>>Hi all,
>>
>>The installation of Koha that I administer (Debian, Koha 2.2.5, yaz
>>toolkit installed) is having a problem with their Z39.50 client.
>>
>>When they try to perform a Z39.50 search (Catalog -> Add Biblio ->
>>Create Empty -> Z39.50 Search) the Z39.50 Search Results window appears
>>and I see the following in the log file
>>/var/log/apache/koha/koha-error.log:
>>x.x.x.x - - [12/May/2006:12:43:43 +1000] "GET
>>/cgi-bin/koha/z3950/search.pl?bibid=&random= HTTP/1.1" 200 1526
>>x.x.x.x - - [12/May/2006:12:43:43 +1000] "GET
>>/intranet-tmpl/default/en/includes/common-style.css HTTP/1.1" 200 7431
>>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/Breeding.pm line 167.
>>DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at
>>/usr/local/koha/intranet/modules/C4/Breeding.pm line 168.
>>(Sanitised of IP addresses)
>>
>>Now my perl is a bit rusty and my SQL knowledge is even rustier, so I'm
>>guessing that this loop tries to get data from the sql database, would
>>the be correct?
>>168:        while (my $data = $sth->fetchrow_hashref) {
>>169:                        $results[$count] = $data;
>>170:                        $count++;
>>171:        } # while
>>
>>I don't know where to go from here, so any pointers to where in TFM to
>>read or knowledge that will help me figure out how to fix this would be
>>very appreciated!
>>
>>Thanks,
>>Greg
>>_______________________________________________
>>Koha mailing list
>>Koha at lists.katipo.co.nz
>>http://lists.katipo.co.nz/mailman/listinfo/koha
>>
> 
> 
>