https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33671 --- Comment #16 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Pablo responded:
If the fix of this issue not apply to 22.05, then there is a confusion right from the start.
This is again a misunderstanding! The fix is part of 22.11. So if you are upgrading from 22.05 to 22.11 you will be affected. You are referring to 22.11.02. Please use the latest 22.11 now.
Maybe worth to mention that that Koha was a fresh installation on 20.05, and never touched directly the db, so if there was a NULL guarantor_id on borrower_relationships, Koha create it. On a few days I will get the VM rollbacked to check, but on a very similar instance SELECT COUNT(*) FROM borrower_relationships WHERE guarantor_id IS NULL; return zero rows.
Koha does not create guarantors out of the blue. It should be impossible to have FK constraint error on an empty table. Any comments on Koha version, SQL version, SHOW CREATE TABLE borrower_relationships, and its records, etc. may help us further. Please repeat with the latest 22.11 and report back. -- You are receiving this mail because: You are watching all bug changes.