[Koha] z3950 problem in 2.0.0pre2

[Krzysztof Michalak]

Thanks Jerome,

I actually did add the z3950random column to the table after posting my
message yesterday. I did not add an encoding column, I guess I should do
that too.

One other source of the problem I identified was that when a z3950
server has a space in it's name the script gets confused. This is
particularly a problem since the default install has a server named
"Library of Congress". To fix the problem I simply renamed it to LOC. I
guess the problem arises from line 99 of processz3950queue :

foreach $serverinfo (split(/\s+/, $servers)) {

Things seem to work ok now.

Chris


On Wed, 2003-07-16 at 23:32, Jerome Vizcaino wrote:
> 
> 
> On Wed, 2003-07-16 at 22:04, Krzysztof Michalak wrote:
> > Sorry to reply to my own message, but I wanted to add that I also get
> > the following errors in the koha log :
> > 
> > [Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] search.pl :  /  / 
> > /  at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 52.
> 
> The / / / means that the page failed to send the parameters
> (isbn/title/author if I remember correctly) to the z3950 script.
> 
> > [Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] Q : Select
> > id,file,isbn,title,author from marc_breeding where z3950random =
> > "378733019.883843" at /usr/local/koha/intranet/modules/C4/Search.pm line
> > 2429.
> > [Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] DBD::mysql::st
> > execute failed: Unknown column 'z3950random' in 'where clause' at
> > /usr/local/koha/intranet/modules/C4/Search.pm line 2431.
> 
> This is due to an error in the database script creation. You'll have to
> add the z3950random column to your marc_breeding table.
> 
> In case I give you the command :
> ALTER TABLE marc_breeding ADD COLUMN z3950random varchar(30);
> 
> Also it seems the "encoding" column is missing too :
> ALTER TABLE marc_breeding ADD COLUMN encoding varchar(40);
> 
> > [Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] DBD::mysql::st
> > fetchrow_hashref failed: fetch() without execute() at
> > /usr/local/koha/intranet/modules/C4/Search.pm line 2432.
> > 
> 
> Invalid SQL syntax => execute failed...
> 
> Hope that helps.
> Good luck.
> 
> Jerome
> 
> 
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha