| Summary: | Script to search for data inconsistencies [omnibus] | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Jonathan Druart <jonathan.druart> |
| Component: | Command-line Utilities | Assignee: | Bugs List <koha-bugs> |
| Status: | NEW --- | QA Contact: | Testopia <testopia> |
| Severity: | enhancement | ||
| Priority: | P5 - low | CC: | lars, lisette, martin.renvoize, robin, victor |
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
| Bug Depends on: | 21169, 21264, 20509, 21011, 21150, 21466, 23871 | ||
| Bug Blocks: | |||
|
Description
Jonathan Druart
2018-06-27 18:25:22 UTC
Bug 20509 - Data consistency - authority types Bug 21011 - Data inconsistencies - items.holdingbranch | items.homebranch Bug 21150 - Data inconsistencies - item types Bug 21169 - Data inconsistencies - records without a MARC subfield mapped with biblio.biblionumber 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. 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) Bug 21466 - Data inconsistencies - items.location values must have a corresponding authorised value (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?) |