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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com