Bug 21011: Search for items with not defined homebranch and/or holdingbranch
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 27 Jun 2018 18:32:56 +0000 (15:32 -0300)
committerFridolin Somers <fridolin.somers@biblibre.com>
Fri, 21 Sep 2018 13:46:48 +0000 (15:46 +0200)
commitf0db075dde813eae5b46df6f39decd7fc896d4a4
tree07f1132d979b415cd0ba3792c8cfa73edcdf9ad6
parent2a7f362d2030c242559146bf2f4d583031f81d0d
Bug 21011: Search for items with not defined homebranch and/or holdingbranch

From bug 5789: scripts can fail if items.homebranch and/or
items.holdingbranch is not defined

This script will help people catching these migration issues.

Test plan:
Update your items table to set some homebranch or holdingbranch to NULL
Run this script
It will display the different items with not defined values in these
fields.

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit 7d47bb311827298ddc30297bbd388e8f8905db48)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit b5b74454cd0c5f8cb5b46ac60ca94b37e1503fc8)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
misc/maintenance/search_for_data_inconsistencies.pl [new file with mode: 0644]