Bug 23871: data inconsistencies - check title exists
authorFridolin Somers <fridolin.somers@biblibre.com>
Tue, 22 Oct 2019 12:31:08 +0000 (14:31 +0200)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 14 Apr 2020 15:55:13 +0000 (16:55 +0100)
commitec6c143f1b26f219f1e9ab5852436da09c857758
tree47dc00bb7836ceba2c1f8c1ace34cdad6cd56709
parent74c63d27c7f250da99255d7e64cfdad08a1702aa
Bug 23871: data inconsistencies - check title exists

In biblio records, a field must be linked to biblio.title.
200$a in UNIMARC, 100$a MARC21 (and other).

If this field is undefined, some pages like checkouts table can fail.

Test plan :
1) Remove biblio title in SQL :
   UPDATE biblio SET title='' WHERE biblionumber=XXX
2) Run misc/maintenance/search_for_data_inconsistencies.pl
3) You see the record as an inconsistency
4) Reset a title
   UPDATE biblio SET title='50 shades of Grey' WHERE biblionumber=XXX
5) Run misc/maintenance/search_for_data_inconsistencies.pl
6) Record is no longer an inconsistency

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
misc/maintenance/search_for_data_inconsistencies.pl