z3950 problem in 2.0.0pre2
Hi, I'm trying to get koha 2.0.0pre2 running. I got through the basic installation and even figured out a few of the bugs along the way (missing Event.pm, some hardcoded paths, etc). Now I run the processz3950queue deamon and try to add an acquisition using a z3950 ISBN search. However, I get a "Still ?? requests to go" message. If I inspect the processz3950queue log file I see first a number of lines resembling : Malformed UTF-8 character (1 byte, need 2, after start byte 0xd0) at /usr/local/koha/C4/Biblio.pm line 2265. Malformed UTF-8 character (1 byte, need 2, after start byte 0xd8) at /usr/local/koha/C4/Biblio.pm line 2266. Then I get the following : starting loop Library ==> at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Processing isbn="0201648652" at Library (1 forks) Library ERROR: Can't call method "option" on an undefined value at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 157. done. To me it seems like the connection to the database failed (the option method is being called on $conn). In fact I did a bit of debugging and it seems (I could be wrong) that the servername, database, user, etc variables are never set correctly. In the parameters, the z3950.loc.gov server is listed with the default values after installation. (checked =1) Where did I go wrong? Thanks, Chris
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. [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. [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. I imagine they may be related... Chris On Wed, 2003-07-16 at 12:05, Krzysztof Michalak wrote:
Hi,
I'm trying to get koha 2.0.0pre2 running. I got through the basic installation and even figured out a few of the bugs along the way (missing Event.pm, some hardcoded paths, etc). Now I run the processz3950queue deamon and try to add an acquisition using a z3950 ISBN search. However, I get a "Still ?? requests to go" message.
If I inspect the processz3950queue log file I see first a number of lines resembling :
Malformed UTF-8 character (1 byte, need 2, after start byte 0xd0) at /usr/local/koha/C4/Biblio.pm line 2265. Malformed UTF-8 character (1 byte, need 2, after start byte 0xd8) at /usr/local/koha/C4/Biblio.pm line 2266.
Then I get the following :
starting loop Library ==> at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. Processing isbn="0201648652" at Library (1 forks) Library ERROR: Can't call method "option" on an undefined value at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 157.
done.
To me it seems like the connection to the database failed (the option method is being called on $conn). In fact I did a bit of debugging and it seems (I could be wrong) that the servername, database, user, etc variables are never set correctly.
In the parameters, the z3950.loc.gov server is listed with the default values after installation. (checked =1)
Where did I go wrong?
Thanks,
Chris
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On Thu, Jul 17, 2003 at 12:39:02, Krzysztof Michalak wrote: Hi Krzysztof, I have expirienced exactly the same as you have described below, only I cannot seem to get the result into Koha, are you successfully importing data via Z3950? When I do a search I can se the following in my log: LOC ==> at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. LOC ==> answered : 1 found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 170. Processing isbn="0201896842" at LOC z3950.loc.gov:7090 voyager (1 forks) z3950.loc.gov:7090 done. But after that nothing happens. I would love to hear how you got it working. Best wishes, Lars
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Lars Anderson mailto:lsa@business.auc.dk Department of Business Studies http://www.business.auc.dk/~lsa/ Aalborg University Voice: +45 96358225, Fax: +45 98153505 Denmark Office: Fib4-117
Lars, Yes I am able to import data from a z3950 server. I'm very new to Koha and library software in general so my experience is limited. I tried about a half dozen different things and I don't remember everything I did. Of those things I'm sure only 1-2 had anything to do with my success! One change I remember making is setting the MARC type field for the LOC server to USMARC (it defaults to a NULL value). You may want to try doing this if you haven't already. For the record, here is what I get in the processz3950queue log file after a successful lookup : LOC ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. LOC ==> answered : 1 found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 170. Processing isbn="0201648652" at LOC z3950.loc.gov:7090 voyager USMARC (1 forks) z3950.loc.gov:7090 done. If I decide to do a clean install again I will try to document exactly what I do to get things to run and send you the info. However I'm probably going to set this project aside for a little while and wait for a future release of Koha. I hope things work out for you! Chris On Fri, 2003-07-18 at 02:50, Lars Anderson wrote:
On Thu, Jul 17, 2003 at 12:39:02, Krzysztof Michalak wrote:
Hi Krzysztof,
I have expirienced exactly the same as you have described below, only I cannot seem to get the result into Koha, are you successfully importing data via Z3950?
When I do a search I can se the following in my log:
LOC ==> at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. LOC ==> answered : 1 found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 170. Processing isbn="0201896842" at LOC z3950.loc.gov:7090 voyager (1 forks) z3950.loc.gov:7090 done.
But after that nothing happens.
I would love to hear how you got it working.
Best wishes, Lars
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On Fri, Jul 18, 2003 at 19:08:21, Chris Michalak wrote: Hi, Chris,
Yes I am able to import data from a z3950 server. I'm very new to Koha and library software in general so my experience is limited. I tried
Well, me too.
about a half dozen different things and I don't remember everything I did. Of those things I'm sure only 1-2 had anything to do with my success!
One change I remember making is setting the MARC type field for the LOC server to USMARC (it defaults to a NULL value). You may want to try doing this if you haven't already.
I had set it for UNIMARC, but setting it to USMARC helped, thanks. Lars
For the record, here is what I get in the processz3950queue log file after a successful lookup :
LOC ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. LOC ==> answered : 1 found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 170. Processing isbn="0201648652" at LOC z3950.loc.gov:7090 voyager USMARC (1 forks) z3950.loc.gov:7090 done.
If I decide to do a clean install again I will try to document exactly what I do to get things to run and send you the info. However I'm probably going to set this project aside for a little while and wait for a future release of Koha.
I hope things work out for you!
Chris
On Fri, 2003-07-18 at 02:50, Lars Anderson wrote:
On Thu, Jul 17, 2003 at 12:39:02, Krzysztof Michalak wrote:
Hi Krzysztof,
I have expirienced exactly the same as you have described below, only I cannot seem to get the result into Koha, are you successfully importing data via Z3950?
When I do a search I can se the following in my log:
LOC ==> at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. LOC ==> answered : 1 found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 170. Processing isbn="0201896842" at LOC z3950.loc.gov:7090 voyager (1 forks) z3950.loc.gov:7090 done.
But after that nothing happens.
I would love to hear how you got it working.
Best wishes, Lars
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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Lars Anderson mailto:lsa@business.auc.dk Department of Business Studies http://www.business.auc.dk/~lsa/ Aalborg University Voice: +45 96358225, Fax: +45 98153505 Denmark Office: Fib4-117
participants (4)
-
Chris Michalak -
Jerome Vizcaino -
Krzysztof Michalak
-
Lars Anderson