[Koha-bugs] [Bug 19016] Add a script to fix corrupted data

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

--- Comment #7 from Tomás Cohen Arazi <tomascohen@gmail.com> ---
Created attachment 65710
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65710&action=edit
Bug 19016: Check and fix 'biblioitems'

This patch adds 'biblioitems' to the list of tables to be evaluated and fixed.

To test the problem exists:
- reset_all
- Run:
  $ sudo koha-mysql kohadev
  > SELECT biblionumber FROM biblio ORDER BY biblionumber DESC LIMIT 1;
- From the staff UI, delete the biblio with that biblionumber
- Restart mysql:
  $ sudo systemctl restart mysql.service
- Add a new biblio record
- Run:
  $ sudo koha-shell kohadev
 k> cd kohaclone
 k> misc/cronjobs/cleanup_database.pl --list-corrupted-data
=> FAIL: biblioitems issue is not higlighted
- Apply this patch
- Run:
  $ sudo koha-shell kohadev
 k> cd kohaclone
 k> misc/cronjobs/cleanup_database.pl --list-corrupted-data
=> SUCCESS: biblioitems issue is highlighted

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>

-- 
You are receiving this mail because:
You are watching all bug changes.