<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Stephen Hedges wrote:<br>
<blockquote type="cite"
cite="mid200309302027.h8UKRjM18914@alma.athenscounty.lib.oh.us">
<pre wrap="">Serge Renaux wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I try to clean our Koha mysql database after that
a librarian 'played'
with the acquisitions module.
I deleted the bilblionumber in biblio,
biblioitems, items and marc_biblio .
I can see my biblionumber still in the database
after searching with
catalogue/marc search tool.
Do you know where can i find the biblionumber
that i have to delete /
</pre>
</blockquote>
<pre wrap=""><!---->
Serge, the marc_biblio table is a cross-reference between the original Koha
tables (biblio, biblioitems, items, etc) and the MARC tables
(marc_subfield_table and marc_word). Records in the original Koha tables have
a biblionumber, while records in the MARC tables have a bibid, and the
marc_biblio table keeps track of which biblionumber links to which bibid.
If you are importing and adding MARC records, your bibid will generally be the
same as your biblionumber. (Because of the nature of MARC records, you will
almost always have one biblio and one biblioitems record for each MARC record.)
I suspect what you are seeing with the MARC search tool is not the
biblionumber but the bibid. Try doing a SELECT * FROM marc_subfield_table
WHERE bibid = [?whatever the biblionumber was] and I bet you will see the same
record you are seeing on the MARC search screen.
</pre>
</blockquote>
100% exact. Nothing to add, nothing to drop.<br>
<br>
<pre class="moz-signature" cols="72">--
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre <a class="moz-txt-link-freetext" href="http://www.koha-fr.org">http://www.koha-fr.org</a>)
</pre>
</body>
</html>