http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2871 Summary: updatedatabase.pl fails when upgrading to 3.00.00.091 with foreign key message_transports_ibfk_3 Product: Koha Version: unspecified Platform: PC OS/Version: All Status: NEW Severity: normal Priority: P3 Component: Database AssignedTo: galen.charlton@liblime.com ReportedBy: Andrew.moore@liblime.com QAContact: koha-bugs@lists.koha.org I believe that a relatively recent change to kohastructure.sql causes this error during updatedatabase.pl: Upgrade to 3.00.00.090 done (added several circ rules tables) ERROR 1452 (23000) at line 1: Cannot add or update a child row: a foreign key constraint fails (`acm_koha/message_transports`, CONSTRAINT `message_transports_ibfk_3` FOREIGN KEY (`letter_module`, `letter_code`) REFERENCES `letter` (`module`, `code`) ON DELETE CASCADE ON UPDATE CASCADE) Upgrade to 3.00.00.091 done (Table structure for table `message_queue`, `message_transport_types`, `message_attributes`, `message_transports`, `borrower_message_preferences`, and `borrower_message_transport_preferences`. Alter `borrowers` table, Upgrade to 3.00.00.092 done (added new AllowOnShelfHolds syspref) ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.