[Koha] Problem adding biblio records - Biblio.pm at line 1440

CrossroadsDude Livingston_john at lilly.com
Mon Sep 17 16:03:50 NZST 2007

I just installed a new Koha system for a Children’s library in a church and
I'm having trouble adding biblio records. 

Koha 2.2.9
Debian 2.6.18-5-686
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
Perl 5.008008 
Apache 2

I'm trying to look up MARC record via the z3950 interface and then adding
them using the "Add Bibliographic Record and go to Items" button.

When I try to add the record, the Biblio script fails and I get a document
save dialog box in my browser with an option to save an addbiblio.pl file.
On thread suggested looking at the /usr/local/koha/log/koha-error_log file.
I found that I the last entry has a problem in Biblio.pm at line 1440. I
looked at the Biblio.pm file and line 1440 and the line is  


I've gone through this many times and get consistent errors importing from
several z3950 sources and using several different books.

I found lots of posts with similar problems that refer to line 1440 but
unfortunately, no solutions... Some threads suggest that it might be an
Apache problem and others suggest that this may be related to the format of
the MARC record we are trying to import. 

Has anyone solved this one? I'm running out of leads on what to check next. 

Thanks in advance for your help, 

Crossroads Community Church
Fishers IN

Here's an excerpt from the script and error log file...

Biblio.pm line 1430 - 1440

        # biblionumber & biblioitemnumber are in the same field (can't be
<10 as fields <10 have only 1 value)
        } else {
                my $newfield = MARC::Field->new(
                        $tagfield1, '', '', "$tagsubfield1" => $oldbibnum,
                        "$tagsubfield2" => $oldbibitemnum
                # drop old field and create new one...
                my $old_field = $record->field($tagfield1);

>From the koha-error_log file

[Sun Sep 16 21:58:01 2007] [error] [client] 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 'parable' and
m1.tagsubfield in ('245a'))and (m2.word like 'of' and m2.tagsubfield
in('245a'))and (m3.word like 'lily' and m3.tagsubfield in('245a'))and
(m4.word like 'Higgs' and m4.tagsubfield in('245b'))and (m5.word like 'Liz'
and m5.tagsubfield in('245b'))and (m6.word like 'Curtis' and m6.tagsubfield
in('245b'))and (m7.word like '21' and m7.tagsubfield in('100a'))and (m8.word
like 'cm' and m8.tagsubfield in('100a'))and (m9.subfieldvalue = 'Thomas
Nelson Books,'  and concat(m9.tag,m9.subfieldcode) in ('300c'))) order by
biblio.title ASC term is  The parable of the lily   Higgs  Liz Curtis  21 cm 
Thomas Nelson Books, at /usr/local/koha/intranet/modules/C4/SearchMarc.pm
line 274., referer:
[Sun Sep 16 21:58:01 2007] [error] [client] Arguments must be
MARC::Field object at /usr/local/koha/intranet/modules/C4/Biblio.pm line
1440, referer:
[Sun Sep 16 21:58:01 2007] [error] [client] Premature end of
script headers: addbiblio.pl, referer:

View this message in context: http://www.nabble.com/Problem-adding-biblio-records---Biblio.pm-at-line-1440-tf4464182.html#a12729066
Sent from the Koha - Discuss mailing list archive at Nabble.com.

More information about the Koha mailing list