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