https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40057 --- Comment #1 from Pedro Amorim <pedro.amorim@openfifth.co.uk> --- Created attachment 182919 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=182919&action=edit Bug 40057: Fix db revision Test plan (ktd): 1) reset_all 2) Run first part of the 241200017.pl atomicupdate manually koha-mysql kohadev ALTER TABLE illrequests DROP FOREIGN KEY illrequests_bnfk; 3) Create an ILL request linked to a borrower that doesn't exist (simulate old data): INSERT INTO illrequests (, , ) VALUES ('Standard', '99999', 'CPL'); 4) Run the 2nd part of the atomicupdate manually: ALTER TABLE illrequests ADD CONSTRAINT illrequests_bnfk FOREIGN KEY() REFERENCES () ON DELETE SET NULL ON UPDATE CASCADE; 5) Notice you get the error: ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (., CONSTRAINT FOREIGN KEY () REFERENCES () ON DELETE SET NULL ON UPDATE CASCADE) 6) Run the added query in the patch: UPDATE illrequests SET borrowernumber = NULL WHERE borrowernumber NOT IN (SELECT borrowernumber FROM borrowers); 7) Repeat step 4) 8) Notice there's no errors -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.