Re: [Koha] Problems with Z3950 search
dmoses2@uwo.ca wrote:
Thanks Paul:
I've checked the items you suggested. And as far as I know all appears to be set correctly. - I am doing an ISBN search. - as far as I know the fields are linked. - I've checked my marc_breeding table and it has the correct field.
Hey ... I've just got it working ... Oh my god.... The ISBN number has to be entering in the ISBN field of the addbiblio.pl page as well.
:-)
That is foolish ... the ISBN is carried in the url, why doesn't it get dumped to the form. I'm going to rewrite it so the value get passed into the form too. I bet that's the problem that the other folks are having too. Thanks for all the help Paul. I feel REALLY stupid.
You're not stupid. I agree it's really poor not to carry ISBN to the addbiblio.pl screen too. But it's really a pain to do, as Koha support any MARC flavour, and ISBN/title/author is NOT in the same field/subfield in every MARC flavour. So we had to find in which subfield the ISBN/title/author is hidden... for T. Kotula :
DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 136.
No, I don't know why this happends. I sometimes (rarely) had this problem, and haven't found a solution yet. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
for T. Kotula :
DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 136.
No, I don't know why this happends. I sometimes (rarely) had this problem, and haven't found a solution yet.
You could try setting your mysql connection timeout higher. http://www.mysql.com/doc/en/Server_parameters.html It sounds like the server connection is timing out, a better fix would be fix the code so that if the server connection times out, we create a new connection. Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Chris Cormack wrote:
for T. Kotula :
BD::mysql::st execute failed: MySQL server has gone away at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 136.
No, I don't know why this happends. I sometimes (rarely) had this problem, and haven't found a solution yet.
You could try setting your mysql connection timeout higher.
http://www.mysql.com/doc/en/Server_parameters.html
It sounds like the server connection is timing out, a better fix would be fix the code so that if the server connection times out, we create a new connection.
/me agree. I was investigating too, & have another idea : The line 107 my $dbh = C4::Context->dbh; connects only once to the DB. The while(1) loop never checks or reconnect. Please, copy the line 107 after the while(1), on line 131, just after print "starting loop\n"; and tell us if it fixes the problem. (with this patch, the connection is done every 10 seconds) thanks -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
participants (2)
-
Chris Cormack -
paul POULAIN