https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17160 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Barton, I understand the problem but it does not look so easy to fix it. In the message_transports we have MariaDB [koha]> select message_transport_type, letter_module, letter_code from message_transports; +------------------------+---------------+-------------+ | message_transport_type | letter_module | letter_code | +------------------------+---------------+-------------+ | email | circulation | CHECKIN | | sms | circulation | CHECKIN | | email | circulation | CHECKOUT | | sms | circulation | CHECKOUT | | email | circulation | DUE | | sms | circulation | DUE | | email | circulation | DUEDGST | | sms | circulation | DUEDGST | | email | circulation | PREDUE | | sms | circulation | PREDUE | | email | circulation | PREDUEDGST | | sms | circulation | PREDUEDGST | | email | reserves | HOLD | | sms | reserves | HOLD | +------------------------+---------------+-------------+ 14 rows in set (0.10 sec) But the letter table does necessarily contain a sms template for CHECKIN or CHECKOUT (or whatever). If it does not exist, we won't be able to create the FK correctly. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.