[Koha] Z39.50 problem

[Stephen Hedges]

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

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
>


-- 
Stephen Hedges
Skemotah Solutions, USA
www.skemotah.com  --  shedges at skemotah.com