[Koha] Continuting z3950 madness

[Greg Vickers]

Hi Chris,

Chris Cormack wrote:
> On Fri, Jun 16, 2006 at 01:07:52PM +1000, Daehenoc said:
>> Thanks for the reply. We're running Koha 2.2.5 and since I don't know
>> what npl is I guess we're running default templates. :p Actually, we
>> installed the Canevas templates now I come to think about it.
>>
>> I'm fairly sure that this problem existed prior to installing the
>> Canevas templates... but the Canevas installation and when we first
>> tried to use the z39.50 daemon was a while ago.
>>
> Canevas?? Thats a new one for me :)
> 
> It looks to me like BreedingSearch is not being passed anything to search on
> If you look at Breeding.pm
> 
> Line 167 is 
> $sth->execute(@bind);
> 
> Before that, could you put
> 
> warn "query=$query title=$title isbn=$isbn";
> 
> And then try a z3950 search and check the error logs it should hopefully
> show us if the title and/or isbn are being passed through ok.

OK I did this and got the following in the apache koha-error.log file:
220.239.73.84 - - [21/Jun/2006:21:30:16 +1000] "GET 
/cgi-bin/koha/z3950/search.pl?bibid=&random= HTTP/1.1" 200 1526
query=Select id,file,isbn,title,author from marc_breeding where  title= 
isbn= at /usr/local/koha/intranet/modules/C4/Breeding.pm line 167.
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 168.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at 
/usr/local/koha/intranet/modules/C4/Breeding.pm line 169.

So it looks like the title and isbn are not being passed to Breeding.pm :(

> Altho this is just searching the results of previous z3950 searches, so this
> wont help the actual z3950 searches work. The problem there was the other
> error.
> 
> Ive attached a processz3950queue file that may (or may not) fix your
> disappearing server problem

I backed up the original processz3950queue script, installed this new 
script, killed the running process and removed the pid file. I then used 
z3950-daemon-launch.sh to start the daemon up again and got the same log 
result:

220.239.73.84 - - [21/Jun/2006:21:41:41 +1000] "GET 
/cgi-bin/koha/z3950/search.pl?bibid=&random= HTTP/1.1" 200 1526
query=Select id,file,isbn,title,author from marc_breeding where  title= 
isbn= at /usr/local/koha/intranet/modules/C4/Breeding.pm line 167.
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 168.
DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at 
/usr/local/koha/intranet/modules/C4/Breeding.pm line 169.

So where else should I look to see why BreedingSearch isn't being passed 
anything? Are we using the z39.50 search function incorrectly?

Thanks,
Greg