[Koha] Z39.50 problem

[Greg Vickers]

Kyle,

Kyle Hall wrote:
> The daemon is included with koha. If you used the default settings for
> your install, you can launch it by running z3950-daemon-launch.sh from
> /usr/local/koha/intranet
> /scripts/z3950daemon

Thanks for the information!

> And don't feel too bad, I did the exact same thing.

OK the daemon is running (twice? ps output below) and the z39.50 query
still fails with the same output in the koha apache error log file.

I'll look through Breeding.pm to see where this SQL query is failing -
but I have no idea what I'm looking for!

Greg

> On 5/18/06, *Greg Vickers* < daehenoc at optusnet.com.au
> <mailto:daehenoc at optusnet.com.au>> wrote:
> 
>     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 <mailto:Koha at lists.katipo.co.nz>
>     >> http://lists.katipo.co.nz/mailman/listinfo/koha
>     >>
>     >
>     >
>     >
>     _______________________________________________
>     Koha mailing list
>     Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>     http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> 
> 
> -- 
> IT Tech
> Crawford County Federated Library System
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha