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