[Koha] What happened to my database?

George Adams g_adams27 at hotmail.com
Fri Apr 18 08:37:32 NZST 2008


Hi, all.  I've upgraded from Koha 3 alpha to the beta, which in the
process upgraded the database from 3.0000052 to 3.0000067.  Everything
has been fine up till now - searching for records works fine, check-in
and check-out is fine, etc.

But today, I noticed that when I tried to update an item in the catalog
(the first time I'd tried it since the upgrade), the resulting entry
was a mess.  To boil the problem down to its essence, look at this:

Here is the MARC entry for our "HOW SHOULD WE THEN LIVE" DVD

000:   02065nam a22002297a 4500
001:  
003:   OSt
005:   20080402003158.0
006:  
007:  
008:   080402t        xxu||||| |||| 00| 0 eng d
040
   c:  DSW
100
   a:  Schaeffer, Dr. Francis
245
   a:  How Should We Then Live?
260
   b:  Gospel Films
   c:  1961
300
   a:  10 episodes on 2 DVDs - 6 hours total
500
   a:  Dr. Schaeffer's sweeping epic on the rise and decline of ...
520
   a:  After 40 years of intense study and world-wide ministry, ...
650
   a:  History  
942
   2:  ddc
   c:  DVD  

-------------------------------------------------

Now I do the following steps:

- Go to the Cataloguing page, find the "Chariots of Fire" entry, and
  click "Edit Biblio" 

- On the next page ("Edit MARC Record Number 35..."), I make no
  changes, but simply hit the "Save" button.

That's all.  And here is the MARC record that is stored as a result:

-------------------------------------------------

000:   02380nam a22004937a 4500
001:  
003:   OSt
005:   20080402003158.0
006:  
007:  
008:   080402t        xxu||||| |||| 00| 0 eng d
040
   c:  DSW
100
   a:  4
110
   a:  b
111
   a:  c
130
   a:  l
245
   a:  How Should We Then Live?
260
   b:  Gospel Films
   c:  1961
300
   a:  10 episodes on 2 DVDs - 6 hours total
440
   a:  n
500
   a:  Dr. Schaeffer's sweeping epic on the rise and decline of ...
520
   a:  After 40 years of intense study and world-wide ministry, ...
600
   a:  b
610
   a:  b
611
   a:  c
630
   a:  e
648
   a:  v
650
   a:  History
651
   a:  e
654
   a:  b
655
   a:  b
662
   a:  b
690
   a:  b
700
   a:  b
710
   a:  b
711
   a:  c
730
   a:  l
800
   a:  b
810
   a:  b
811
   a:  c
830
   a:  l
942
   2:  ddc
   c:  DVD

-------------------------------------------------

As you can see, a lot of MARC fields have been added that I hadn't used
before (or needed).  But even worse, some of the correct fields have
been replaced with incorrect data.  For instance 100a has changed from
"Schaeffer, Dr. Francis" to "4".

Can anyone tell me what's going on?  As it stands right now, I am
completely unable to make any changes to existing biblio items without
the record becoming corrupt.

And I also noticed that if I try to enter a new Biblio, certain fields
like 100a (Personal Name) are greyed-out (i.e. disabled), so I can't
create proper new records either.

Please help!  And thank you!


More information about the Koha mailing list