[Koha-bugs] [Bug 4246] Koha support for Itiva Talking Tech phone notification service

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4246

--- Comment #19 from Paul Poulain <paul.poulain at biblibre.com> ---
Trying to apply this patch, I get a SQL constraint error:

INSERT INTO message_transports
    ->              (message_attribute_id, message_transport_type, is_digest,
letter_module, letter_code) VALUES
    ->              (4, 'phone', 0, 'reserves', 'HOLD_PHONE'),
    ->              (2, 'phone', 0, 'circulation', 'PREDUE_PHONE')
    -> ;
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint
fails (`lecannetdesmaures`.`message_transports`, CONSTRAINT
`message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES
`message_attributes` (`message_attribute_id`) ON DELETE CASCADE)
portable lecannetdesmaures>select * from message_attributes;

Investigating a little show that the message_transports table does not contain
message_attribute_id 4 and 2

Investigating more, it's my sample database that is wrong.

Adding the values that I don't have fixes the problem

will push now

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.