Bug 35687: Upgrade to 23.06.00.013 may fail
authorKyle M Hall <kyle@bywatersolutions.com>
Wed, 3 Jan 2024 14:07:49 +0000 (14:07 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Mon, 29 Jan 2024 09:08:52 +0000 (10:08 +0100)
commitdd0057472b4a7cbb53cfe676d28425e6c03cde36
tree352335e275c0fc9a8f0a25cbb79878a19ec5a892
parent07097737e6fb70bc6527e439102e5443fbb650ad
Bug 35687: Upgrade to 23.06.00.013 may fail

There are reports that this update triggers the error Cannot change column 'itemnumber': used in a foreign key constraint 'tmp_holdsqueue_ibfk_1'

Test Plan:
1) Upgrade to post 23.06.00.013
2) Note the failure
3) Apply this patch set
4) Run updatedatabase.pl
5) Update should succeed!

Signed-off-by: Emily Lamancusa <emily.lamancusa@montgomerycountymd.gov>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
(cherry picked from commit a644f41a924ba40254f6c7ef073d33c7eb7d383b)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/atomicupdate/bug_35687.pl [new file with mode: 0755]