Hello people Has somebody succeeded in running a koha-2.2.9 recently installed on etch? My problem: I can't add new biblios. I had posted some of my problems before. Now I thougt I'd start again from the buttom up. I deleted the koha-database in MySQL did a rm -r /usr/lokal/koha and installed koha again. After entering some library branches, some itemtypes, some borrower catagories, some z3950-servers and _nothing_ _else_ I tried to add a work (ISBN 3170183338) and got the same error again: [Mon Oct 29 20:32:16 2007] [error] [client 192.168.1.50] Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_word as m2,marc_word as m3,marc_word as m4,marc_word as m5,marc_word as m6,marc_word as m7,marc_word as m8,marc_subfield_table as m9 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid and m1.bibid=m3.bibid and m1.bibid=m4.bibid and m1.bibid=m5.bibid and m1.bibid=m6.bibid and m1.bibid=m7.bibid and m1.bibid=m8.bibid and m1.bibid=m9.bibid) and ((m1.word like 'Neutestamentliches' and m1.tagsubfield in ('245a'))and (m2.word like 'Arbeitsbuch' and m2.tagsubfield in('245a'))and (m3.word like 'f\xc3\xbcr' and m3.tagsubfield in('245a'))and (m4.word like 'Religionsp\xc3\xa4dagogen' and m4.tagsubfield in('245a'))and (m5.word like 'Becker' and m5.tagsubfield in('245b'))and (m6.word like 'Ulrich' and m6.tagsubfield in('245b'))and (m7.word like '24' and m7.tagsubfield in('100a'))and (m8.word like 'cm' and m8.tagsubfield in('100a'))and (m9.subfieldvalue = 'W. Kohlhammer,' and concat(m9.tag,m9.subfieldcode) in ('300c'))) order by biblio.title ASC term is Neutestamentliches Arbeitsbuch f\xc3\xbcr Religionsp\xc3\xa4dagogen Becker Ulrich 24 cm W. Kohlhammer, at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 274., referer: http://bibliotheksverwaltung.kollegium-sarnen.ch/cgi-bin/koha/acqui.simple/a ddbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1 [Mon Oct 29 20:32:17 2007] [error] [client 192.168.1.50] Arguments must be MARC::Field object at /usr/local/koha/intranet/modules/C4/Biblio.pm line 1440, referer: http://bibliotheksverwaltung.kollegium-sarnen.ch/cgi-bin/koha/acqui.simple/a ddbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1 [Mon Oct 29 20:32:17 2007] [error] [client 192.168.1.50] Premature end of script headers: addbiblio.pl, referer: http://bibliotheksverwaltung.kollegium-sarnen.ch/cgi-bin/koha/acqui.simple/a ddbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1 I have the feeling koha won't work on etch ... Any hints ... Beda
Hi Beda et al, I've been trying to track this down for about 8 weeks now. Same issue. Apparently the caveats exist in the list archives someplace but I'd sure like them to be pointed out to me. My install works fine except for the addbiblio.pl module. It doesn't matter if I get a record from the "Reservoir or a Z39.50m search I get the same error. The log's don't help me much - But I may not be reading or understanding them properly. Let's keep in touch re this issue - I need to implement on a large scale and need to get this working. Cheers -- F. Grant Johnson 566-0630 / fgjohnson@upei.ca Skype ID = jetsongeorge Systems/Web Coordinator Robertson Library University of Prince Edward Island *************** Attitude is IT!
On 10/29/2007 at 4:47 PM, in message <20071029194741.14634.qmail@www.ksobwalden.ch>, "Beda Szukics" <beda@muri-gries.ch> wrote: Hello people
Has somebody succeeded in running a koha-2.2.9 recently installed on etch?
My problem: I can't add new biblios. I had posted some of my problems before. Now I thougt I'd start again from the buttom up. I deleted the koha-database in MySQL did a rm -r /usr/lokal/koha and installed koha again. After entering some library branches, some itemtypes, some borrower catagories, some z3950-servers and _nothing_ _else_ I tried to add a work (ISBN 3170183338) and got the same error again:
[Mon Oct 29 20:32:16 2007] [error] [client 192.168.1.50] Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_word as m2,marc_word as m3,marc_word as m4,marc_word as m5,marc_word as m6,marc_word as m7,marc_word as m8,marc_subfield_table as m9 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid and m1.bibid=m3.bibid and m1.bibid=m4.bibid and m1.bibid=m5.bibid and m1.bibid=m6.bibid and m1.bibid=m7.bibid and m1.bibid=m8.bibid and m1.bibid=m9.bibid) and ((m1.word like 'Neutestamentliches' and m1.tagsubfield in ('245a'))and (m2.word like 'Arbeitsbuch' and m2.tagsubfield in('245a'))and (m3.word like 'f\xc3\xbcr' and m3.tagsubfield in('245a'))and (m4.word like 'Religionsp\xc3\xa4dagogen' and m4.tagsubfield in('245a'))and (m5.word like 'Becker' and m5.tagsubfield in('245b'))and (m6.word like 'Ulrich' and m6.tagsubfield in('245b'))and (m7.word like '24' and m7.tagsubfield in('100a'))and (m8.word like 'cm' and m8.tagsubfield in('100a'))and (m9.subfieldvalue = 'W. Kohlhammer,' and concat(m9.tag,m9.subfieldcode) in ('300c'))) order by biblio.title ASC term is Neutestamentliches Arbeitsbuch f\xc3\xbcr Religionsp\xc3\xa4dagogen Becker Ulrich 24 cm W. Kohlhammer, at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 274., referer: http://bibliotheksverwaltung.kollegium-sarnen.ch/cgi-bin/koha/acqui.simple/a ddbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
[Mon Oct 29 20:32:17 2007] [error] [client 192.168.1.50] Arguments must be MARC::Field object at /usr/local/koha/intranet/modules/C4/Biblio.pm line 1440, referer: http://bibliotheksverwaltung.kollegium-sarnen.ch/cgi-bin/koha/acqui.simple/a ddbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
[Mon Oct 29 20:32:17 2007] [error] [client 192.168.1.50] Premature end of script headers: addbiblio.pl, referer: http://bibliotheksverwaltung.kollegium-sarnen.ch/cgi-bin/koha/acqui.simple/a ddbiblio.pl?oldbiblionumber=0&z3950=1&breedingid=1
I have the feeling koha won't work on etch ...
Any hints ... Beda
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Grant
I've been trying to track this down for about 8 weeks now. Same issue.
Lucky I'm not the only one. I was questioning my mental health :-)
Apparently the caveats exist in the list archives someplace but I'd sure like them to be pointed out to me.
My install works fine except for the addbiblio.pl module. It doesn't matter if I get a record from the "Reservoir or a Z39.50m search I get the same error.
Same with me. Unfortunately adding new records is what I intend to do every day :-(
Let's keep in touch re this issue - I need to implement on a large scale and need to get this working.
I was upgrading a sarge server to etch. Afterwards I tried to install koha on it and had quite some problems with at least one of the required perl modules (I don't quite remember witch one, it had something to do with a new version, witch was buggy). With some help I managed to succeed the installation process. But now I have the mentioned problem. My guess is it has something to do with one of the perl modules, but I have no idea witch one. Unfortunately I wasn't very careful with documenting my steps. It looks like Koha would be the solution witch suited my needs quite well but maybe I have to consider some other solution ... (Do you know one?) Greetings Beda
participants (2)
-
Beda Szukics -
Grant Johnson