https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 76533 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=76533&action=edit 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. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |20509 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20509 [Bug 20509] Data consistency - authority types -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #76533|0 |1 is obsolete| | --- Comment #2 from Josef Moravec <josef.moravec@gmail.com> --- Created attachment 76536 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=76536&action=edit 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> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Some help with -h would be nice, but not blocker. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #76537|0 |1 is obsolete| | --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 77385 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=77385&action=edit Bug 21011: (follow-up) Fix pod, fix missing homebranch condition, change mode to executable Signed-off-by: Josef Moravec <josef.moravec@gmail.com> Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 --- Comment #7 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to Katrin Fischer from comment #4)

Some help with -h would be nice, but not blocker.

Yes, the idea is to collect ideas first. Then it will certainly rewritten depending on the needs we found. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 --- Comment #9 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to Katrin Fischer from comment #8)

Idea: no itemtype set. :)

I have opened bug 21150 for item types. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks|21150 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21150 [Bug 21150] Data inconsistencies - item types -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21011 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com Status|Pushed to Master |Pushed to Stable --- Comment #11 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Enhancement pushed to 18.05.x for 18.05.03. This only introduces a new command line script which may be helpful to system administrators. As such, with zero outwardly facing changes, I felt it both safe and helpful to backport. -- You are receiving this mail because: You are watching all bug changes.