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