[Koha] Z39.50 problem

Greg Vickers daehenoc at optusnet.com.au
Fri May 12 14:53:16 NZST 2006


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


More information about the Koha mailing list