[Koha-bugs] [Bug 21010] Add a script to search for data inconsistencies

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21010

Victor Grousset/tuxayo <victor.grousset at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |victor.grousset at biblibre.co
                   |                            |m

--- Comment #4 from Victor Grousset/tuxayo <victor.grousset at 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.