[Bug 21010] New: Add a script to search for data inconsistencies
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Bug ID: 21010 Summary: Add a script to search for data inconsistencies Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs@lists.koha-community.org Reporter: jonathan.druart@bugs.koha-community.org QA Contact: testopia@bugs.koha-community.org CC: robin@catalyst.net.nz -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |20509 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20509 [Bug 20509] Data consistency - authority types -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |21011 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 [Bug 21011] Data inconsistencies - items.holdingbranch | items.homebranch -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |21150 --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Bug 20509 - Data consistency - authority types Bug 21011 - Data inconsistencies - items.holdingbranch | items.homebranch Bug 21150 - Data inconsistencies - item types Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21150 [Bug 21150] Data inconsistencies - item types -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |21169 --- Comment #2 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Bug 21169 - Data inconsistencies - records without a MARC subfield mapped with biblio.biblionumber Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21169 [Bug 21169] Data inconsistencies - records without a MARC subfield mapped with biblio.biblionumber -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com --- Comment #3 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- It would be great to run these with each upgrade and set a flag if bad data is detected to raise a warning on the About page. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Victor Grousset/tuxayo <victor.grousset@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |victor.grousset@biblibre.co | |m --- Comment #4 from Victor Grousset/tuxayo <victor.grousset@biblibre.com> --- I'm not sure what could be relevant to take from, but at BibLibre we have a script to check data: https://git.biblibre.com/biblibre/tools/blob/master/koha/db_check_data.sh - items.onloan without issue - Orphan deletedbiblioitems or deletedbiblio - marcxml empty - ethnicity - tables MyISAM - MARC to Koha mappings : duplicates - MARC to Koha mappings : unknown column - MARC to Koha mappings : not like default framework - Merge sysprefs - Need merge authorities - Authorised values duplicates And also to check for auto increment issues: https://git.biblibre.com/biblibre/tools/blob/master/koha/db_check_ai.sh Some of the checks output the SQL to run to fix the issue. (e.g. to remove orphan/invalid data) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Victor Grousset/tuxayo <victor.grousset@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |21264 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21264 [Bug 21264] Data inconsistencies - "Item type" and "item type for older issues" in subscriptions -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Lisette Scheer <lisetteslatah@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lisetteslatah@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Bug 21010 depends on bug 21011, which changed state. Bug 21011 Summary: Data inconsistencies - items.holdingbranch | items.homebranch https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Stable |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Bug 21010 depends on bug 20509, which changed state. Bug 20509 Summary: Data consistency - authority types https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20509 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Stable |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Bug 21010 depends on bug 21150, which changed state. Bug 21150 Summary: Data inconsistencies - item types https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21150 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Stable |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |21466 --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Bug 21466 - Data inconsistencies - items.location values must have a corresponding authorised value Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21466 [Bug 21466] Data inconsistencies - items.location values must have a corresponding authorised value -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Jonathan Druart from comment #5)
Bug 21466 - Data inconsistencies - items.location values must have a corresponding authorised value
What if they are not mapped to LOC? I think I remember patches to display as is in this case a while ago (Biblibre?) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lars@catalyst.net.nz --- Comment #7 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- *** Bug 4879 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |23871 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23871 [Bug 23871] data inconsistencies - check title exists -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add a script to search for |Script to search for data |data inconsistencies |inconsistencies [omnibus] -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010 Bug 21010 depends on bug 23871, which changed state. Bug 23871 Summary: Add check for 'title exists' to `search_for_data_inconsistencies.pl` https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23871 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org