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)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 24 Aug 2018 11:49:17 +0000 (12:49 +0100)
commitb5b74454cd0c5f8cb5b46ac60ca94b37e1503fc8
tree5e07a7faca80901b3dda559d5aaeeb9e15ffffd0
parent8b1944bbd876d2928536b0c457922eb71e9aa54b
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>
misc/maintenance/search_for_data_inconsistencies.pl [new file with mode: 0644]