[Koha-bugs] [Bug 2871] New: updatedatabase.pl fails when upgrading to 3.00.00.091 with foreign key message_transports_ibfk_3

[bugzilla-daemon at pippin.metavore.com]

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 at liblime.com
        ReportedBy: Andrew.moore at liblime.com
         QAContact: koha-bugs at 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.