[Koha-bugs] [Bug 27534] koha upgrade throws SQL error while applying Bug 25333 - Change message transport type for Talking Tech from "phone" to "itiva"

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

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

--- Comment #12 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Jonathan Druart from comment #11)
> (In reply to Manos PETRIDIS from comment #10)
> > If I read correctly the patch you supplied, you drop FOREIGN KEY
> > message_transport_type_fk in letter table. As far as I know though, one
> > doesn't need to drop the FOREIGN KEY altogether, just drop the CONSTRAINT
> > and re-create it, including the missing CASCADE clause. 
> 
> It's exactly what the patch does :)

It drops the FK and recreate it it with the correct CONSTRAINT. AFAIK it's not
possible to do it without removing the FK.

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