http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4246
--- Comment #19 from Paul Poulain <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
