[Koha] z3950 problem in 2.0.0pre2

[Jerome Vizcaino]

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