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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27534 --- Comment #12 from Jonathan Druart <jonathan.druart@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.