[Koha-bugs] [Bug 18265] Followup to Bug 17196. deletedbiblio_metadata is not used. biblioitemnumber was forgotten
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Mar 15 14:05:19 CET 2017
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18265
Olli-Antti Kivilahti <olli-antti.kivilahti at jns.fi> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #61098|0 |1
is obsolete| |
--- Comment #8 from Olli-Antti Kivilahti <olli-antti.kivilahti at 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.
More information about the Koha-bugs
mailing list