Mailing List Archive

[DBMail 0001096]: There is a duplicate FK name that causes install failure in mysql script
The following issue has been SUBMITTED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=1096
======================================================================
Reported By: jytou
Assigned To:
======================================================================
Project: DBMail
Issue ID: 1096
Category: installation scripts
Reproducibility: always
Severity: tweak
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 01-Jul-18 19:03 CEST
Last Modified: 01-Jul-18 19:03 CEST
======================================================================
Summary: There is a duplicate FK name that causes install
failure in mysql script
Description:
The file sql/mysql/create_tables.mysql contains:
FOREIGN KEY user_idnr_fk (user_idnr)
two times, one for dbmail_auto_notifications and one for the next table
dbmail_auto_replies.
I have renamed the first to user_idnr_fkn and the second to user_idnr_fkr
and the create_table script runs fine. As there is no reason those FK names
would be used elsewhere, I suppose the fix is straightforward and safe.
======================================================================

Issue History
Date Modified Username Field Change
======================================================================
01-Jul-18 19:03 jytou New Issue
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail-dev