https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18265
Olli-Antti Kivilahti <olli-antti.kivila...@jns.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #61098|0 |1 is obsolete| | --- Comment #8 from Olli-Antti Kivilahti <olli-antti.kivila...@jns.fi> --- Created attachment 61101 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=61101&action=edit Bug 18265 - Followup to Buuug 17196. deletedbiblio_metadata is not used. biblioitemnumber was forgot. FK to wrong table. Exhibit 1: The MARCXML is lost when the biblio is deleted because the values in biblio_metadata-table from biblioitems-table are never moved to deletedbiblio_metadata-table. Previously the marcxml was preserved in the oldbiblioitems-table This is a challenge for gathering statistics For example item has been ordered, received, and removed from collection during the statistics period Information in marcxml is needed to accurately categorize the item Exhibit 2: [15:22:38] <kivilahtio> also. In Koha there once was a great idea that one biblio-entry can have multiple biblioitems [15:22:45] <kivilahtio> and the marcxml was tied to the biblioitems-table [15:23:11] <kivilahtio> this is a nice idea, but nobdy really cared for it and now biblionumber and biblioitemnumber are used interchangeably [15:23:22] <kivilahtio> except when they get out of sync during a data migration [15:23:41] <kivilahtio> then things start to work really interestingly [15:23:47] <kivilahtio> but the point is [15:23:57] <kivilahtio> biblio_metadata has a biblionumber-column [15:24:15] <kivilahtio> shouldn't it have a biblioitemnumber-column, just for old time's sake? In the biblioitems-table we had marcxml. primary keyed with biblioitemnumber. Now the marcxml is moved to biblio_metadata and the foreign key reference was simplified to biblionumber. This makes the existing FRBR-bug worse. Exhibit 3: Just noticed while doing DB changes, that biblio_metadata is linked to the biblio table instead of the biblioitems-table! No FRBR there. Is being fixed. REPLICATE ISSUE: Create biblio Delete biblio Where is deletedbiblio_metadata-row? TEST PLAN: perl misc/devel/update_dbix_class_files.pl perl t/db_dependent/Biblio_crud.t perl t/db_dependent/Holds/HoldFulfillmentPolicy.t + other tests from Buug 17196 -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/