[Koha] Corrupted record

[Beda Szukics]

Hi Frederic

Frederic Demians schrieb:
>
>> OK - just to be shure: there is no way to delete this currupted 
>> record in Koha. I have to do that using the tools of MySQL itself?
>
> Usually you delete biblio records directly in Koha but you've 
> explained you can't (I don't know why). Did you use this procedure ?
>
>    * you search a biblio record
>    * you display it
I can't search the record. The only way to make it appear is to use the 
inventory. There it shows up. Trying to display the record clicking on 
the blue title I get the answer:


  Koha error

The following fatal error has occurred:

|Can't call method "fields" on an undefined value at /usr/share/koha/intranet/cgi-bin/catalogue/MARCdetail.pl line 123.
|

Apache 	Server version: Apache/2.2.3 Server built: Jan 27 2008 18:13:21
Koha 	3.00.00.067
Koha DB 	3.0000067
MySQL 	mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using 
readline 5.2
OS 	Linux web-kso1.eduilz.ch 2.6.18-6-486 #1 Thu May 8 06:59:18 UTC 2008 
i686 GNU/Linux
Perl 	5.008008



>    * you choose Edit > Edit Items
>    * you delete each item
>    * then, you choose Edit > Delete record
>
>
>> How many tuplets in what tables do I have to delete? Do I understand 
>> you rightly assuming there are 3 records to delete?
>
> In MySQL, I would do something like:
>
>    DELETE FROM biblio WHERE biblionumber = 1234;
>    DELETE FROM biblioitems WHERE biblionumber = 1234;
>    DELETE FROM items WHERE biblionumber = 1234;
I did that. I had to search first the record in the biblioitems table.

There in biblioitems.marcxml I see:

<?xml version="1.0" encoding="UTF-8"?>
<record
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.loc.gov/MARC21/slim 
http://www.loc.gov/ standards/marcxml/schema/MARC21slim.xsd"
    xmlns="http://www.loc.gov/MARC21/slim">

  <leader>00521nam a2200133   4500</leader>
  <controlfield tag="008">  
960105s1970||||||||||||||||||||||||||||ger</controlfield>
  <datafield tag="245" ind1="0" ind2="4">
    <subfield code="a">Die schönsten Helden- und Rittersagen des 
Mittelalters /</subfield>
    <subfield code="c">[Für die Jugend bearb. von] Gerhard Aick ; Mit 
vielen Zeichnungen von Erich Hölle</subfield>
  </datafield>
  <datafield tag="260" ind1=" " ind2=" ">
    <subfield code="a">Wien :</subfield>
    <subfield code="b">Tosa Verlag,</subfield>
    <subfield code="c">[ca. 1970]</subfield>
  </datafield>
  <datafield tag="300" ind1=" " ind2=" ">
    <subfield code="a">508 S. :</subfield>
    <subfield code="b">Ill. ;</subfield>
    <subfield code="c">23 cm</subfield>
  </datafield>
  <datafield tag="700" ind1="1" ind2=" ">
    <subfield code="a">Aick, Gerhard</subfield>
  </datafield>
  <datafield tag="700" ind1="1" ind2=" ">
    <subfield code="a">Hölle, Erich</subfield>
  </datafield>
  <datafield tag="942" ind1=" " ind2=" ">
    <subfield code="c">BUCH</subfield>
    <subfield code="k">SCHÖ</subfield>
  </datafield>
  <datafield tag="952" ind1=" " ind2=" ">
    <subfield code="7">0</subfield>
    <subfield code="p">160</subfield>
    <subfield code="4">0</subfield>
    <subfield code="0">0</subfield>
    <subfield code="6">SCH

The record is obviously incomplete. Have you any idea why? (It's the 
only record with a non-ASCII-character in the callnumber.

> A better method method would be using Koha API in a Perl script...
>
That's a whole lot of learning to do ... :-)

cu                    Beda