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)
committerKatrin Fischer <katrin.fischer@bsz-bw.de>
Fri, 26 Jan 2024 14:13:46 +0000 (15:13 +0100)
commita644f41a924ba40254f6c7ef073d33c7eb7d383b
tree56654d9df44cc9aef4863429553bdac6d4fd98be
parentaadb6172352c7e1dcdbfd6607d2ca9d3da4af090
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>
installer/data/mysql/atomicupdate/bug_35687.pl [new file with mode: 0755]