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
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
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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 And don't feel too bad, I did the exact same thing. Kyle -- IT Tech Crawford County Federated Library System On 5/18/06, Greg Vickers <daehenoc@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- IT Tech Crawford County Federated Library System
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@optusnet.com.au <mailto:daehenoc@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@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > > _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
-- IT Tech Crawford County Federated Library System
------------------------------------------------------------------------
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Greg Vickers a écrit :
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@optusnet.com.au <mailto:daehenoc@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?
Just to remind you that any Koha script is based on a KOHA_CONF environment variable and PERL5LIB must contains path to koha/intranet/modules. so pls, do an export KOHA_CONF=/path/to/my/koha.conf export PERL5LIB=/path/to/koha/intranet/modules before launching the script.
-- Henri-Damien LAURENT
participants (4)
-
Greg Vickers -
Henri-Damien LAURENT -
Kyle Hall -
Stephen Hedges