]> git.koha-community.org Git - koha.git/commit
Bug 37000: (Bug 36120 follow-up) Improve reliability of database update
authorMartin Renvoize <martin.renvoize@ptfs-europe.com>
Tue, 4 Jun 2024 10:58:54 +0000 (11:58 +0100)
committerLucas Gass <lucas@bywatersolutions.com>
Thu, 27 Jun 2024 22:12:04 +0000 (22:12 +0000)
commita4d7767fa4d6a7cb2cd3058108878e745edc4037
tree1941908ec18a0de3218449b7fa5aab80afdecd19
parent710e002b32a879a6064f103b2caeaf646b2b5ab3
Bug 37000: (Bug 36120 follow-up) Improve reliability of database update

This patch adds a series of fallthroughs to ensure pickup_library_id is
always set prior to adding the NOT NULL constraint.

We initially only looked at items.homebranch but as that's a nullable
field itself, we now look at items.holdingbranch before finally
defaulting to the first available branch in the branches table in the
worst case.

Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
(cherry picked from commit 8cedcfd5c86f97e75586870c5e758872f8bc9ba9)
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
installer/data/mysql/db_revs/231200044.pl