Hi all, I am helping a library in Brisbane to install Koha and we are seeing a strange error when trying to use the Z39.50 daemon. I have not touched Koha prior to this, neither this Z39.50 thingy :) Nor much MySQL. We are using Koha 2.2.4. The errors in /usr/local/koha/logs/koha-error_log: [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] 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. [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 168. I suppose there is an error in the Breeding.pm module - here is the code around these lines: 167 $sth = $dbh->prepare($query); 168 $sth->execute(@bind); 169 while (my $data = $sth->fetchrow_hashref) { Can anyone give us any pointers on this and advise us on what is happening and what we may have to do to fix it? Thanks, Greg
I was told that Z39.50 feature is not available to Windows 2.2.4 version but will be available in v3 to be released in early next year. Greg Vickers <daehenoc@optusnet.com.au> wrote: Hi all, I am helping a library in Brisbane to install Koha and we are seeing a strange error when trying to use the Z39.50 daemon. I have not touched Koha prior to this, neither this Z39.50 thingy :) Nor much MySQL. We are using Koha 2.2.4. The errors in /usr/local/koha/logs/koha-error_log: [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] 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. [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 168. I suppose there is an error in the Breeding.pm module - here is the code around these lines: 167 $sth = $dbh->prepare($query); 168 $sth->execute(@bind); 169 while (my $data = $sth->fetchrow_hashref) { Can anyone give us any pointers on this and advise us on what is happening and what we may have to do to fix it? Thanks, Greg _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.
Hi Carol, Carol Ku wrote:
I was told that Z39.50 feature is not available to Windows 2.2.4 version but will be available in v3 to be released in early next year.
We are running Koha on Debian Linux, not Windows. I've made sure that the Z39.50 daemon and tools are installed and accessible, but I'm not sure they are working.
*/Greg Vickers <daehenoc@optusnet.com.au>/* wrote:
Hi all,
I am helping a library in Brisbane to install Koha and we are seeing a strange error when trying to use the Z39.50 daemon. I have not touched Koha prior to this, neither this Z39.50 thingy :) Nor much MySQL. We are using Koha 2.2.4.
The errors in /usr/local/koha/logs/koha-error_log: [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] 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. [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 168.
I suppose there is an error in the Breeding.pm module - here is the code around these lines: 167 $sth = $dbh->prepare($query); 168 $sth->execute(@bind); 169 while (my $data = $sth->fetchrow_hashref) {
Can anyone give us any pointers on this and advise us on what is happening and what we may have to do to fix it?
Thanks, Greg
Greg Vickers wrote:
Hi Carol,
Carol Ku wrote:
I was told that Z39.50 feature is not available to Windows 2.2.4 version but will be available in v3 to be released in early next year.
We are running Koha on Debian Linux, not Windows. I've made sure that the Z39.50 daemon and tools are installed and accessible, but I'm not sure they are working.
They work quite good in France with BNF and other Z3950 servers. -- Henri-Damien LAURENT
Greg Vickers a écrit :
Hi all,
I am helping a library in Brisbane to install Koha and we are seeing a strange error when trying to use the Z39.50 daemon. I have not touched Koha prior to this, neither this Z39.50 thingy :) Nor much MySQL. We are using Koha 2.2.4.
The errors in /usr/local/koha/logs/koha-error_log: [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] 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. [Wed Nov 23 22:17:00 2005] [error] [client 127.0.0.1] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Breeding.pm line 168.
I suppose there is an error in the Breeding.pm module - here is the code around these lines: 167 $sth = $dbh->prepare($query); 168 $sth->execute(@bind); 169 while (my $data = $sth->fetchrow_hashref) {
May be due to the fact you don't entered a title/author/ISBN before clicking on z3950 button (in MARC editor) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
participants (4)
-
Carol Ku -
Greg Vickers -
Henri-Damien LAURENT -
Paul POULAIN