Serge Renaux wrote:
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 /
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. Stephen Hedges Nelsonville Public Library
Stephen Hedges wrote:
Serge Renaux wrote:
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 /
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.
100% exact. Nothing to add, nothing to drop. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
participants (2)
-
paul POULAIN -
Stephen Hedges