[Koha-bugs] [Bug 21901] Foreign keys are missing on the serials and subscriptions tables

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Jan 31 13:31:22 CET 2020


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

--- Comment #11 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
I tested on 4 large clones of production Databases.. none of them failed in the
way you are suggesting.. but it may not be a terrible idea to add a line for
each foreign key addition to 'clean' the bad data.

I did find that in a fair few cases that malformed date fields would crash the
update... I'm not sure whether to fold in a check and clean for such fields
into this patch or open another bug to be honest.. I think I'm inclined to fold
it in here to ensure the DB update will actually run.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list