[Koha-bugs] [Bug 33671] Database update 22.06.00.048 breaks update process

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33671

--- Comment #16 from Marcel de Rooy <m.de.rooy at 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.