Bug 26911: (bug 18936 follow-up) Remove invalid data before copying the circ rules
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 3 Nov 2020 15:45:33 +0000 (16:45 +0100)
committerLucas Gass <lucas@bywatersolutions.com>
Mon, 16 Nov 2020 21:49:24 +0000 (21:49 +0000)
commit5cba820797f8cc83dfd271efb208da676da12eec
tree7972e17b424329f6cefe30eaf2701020be6eb593
parentaeef2fadc39ce019e4f665621d282b088f9a2704
Bug 26911: (bug 18936 follow-up) Remove invalid data before copying the circ rules

UPDATE: changed queries to not touch * values

To test:
 1 - Checkout 19.11.x and reset_all
 2 - Add a new patron category, itemtype, and branch to your system
 3 - Create issuing rules using thise 3 values, and others
 4 - Delete the new category, itemtype and branch
 5 - Checkout master
 6 - Restart_all
 7 - updatedatabase
 8 - you get errors
 9 - repeat 1-5
10 - apply patch
11 - restart_all
12 - updatedatabase
13 - no errors!

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com>
Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 31e38bc371943d1e76f49aacd1dd159a254f71e7)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
installer/data/mysql/updatedatabase.pl