The following issue has been REOPENED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=409 ====================================================================== Reported By: windowsrefund Assigned To: paul ====================================================================== Project: DBMail Issue ID: 409 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: feedback target: ====================================================================== Date Submitted: 13-Sep-06 20:28 CEST Last Modified: 04-Oct-06 00:21 CEST ====================================================================== Summary: SQL script fails to create dbmail_envelope table Description: mysql version: 5.0.22-standard-log
====================================================================== ---------------------------------------------------------------------- windowsrefund - 13-Sep-06 20:31 ---------------------------------------------------------------------- This applies to 2268. Sorry for the typo. ---------------------------------------------------------------------- paul - 17-Sep-06 16:18 ---------------------------------------------------------------------- this any better: DROP TABLE IF EXISTS `dbmail_envelope`; CREATE TABLE `dbmail_envelope` ( `physmessage_id` bigint(20) NOT NULL default '0', `id` bigint(20) NOT NULL auto_increment, `envelope` text NOT NULL, PRIMARY KEY (`id`), KEY `physmessage_id` (`physmessage_id`), CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; ---------------------------------------------------------------------- aaron - 26-Sep-06 23:10 ---------------------------------------------------------------------- Paul, please be sure to put the contents of the 2_1_7-2_1_8 script into the main create_tables.sql. ---------------------------------------------------------------------- windowsrefund - 04-Oct-06 00:21 ---------------------------------------------------------------------- The constraint is causing this to fail on 5.0.22-standard-log For whatever reason, I was able to run this script successfully on 5.0.21-standard-log. Issue History Date Modified Username Field Change ====================================================================== 13-Sep-06 20:28 windowsrefund New Issue 13-Sep-06 20:31 windowsrefund Note Added: 0001399 17-Sep-06 16:18 paul Note Added: 0001404 17-Sep-06 16:18 paul Status new => feedback 17-Sep-06 16:18 paul Status feedback => assigned 17-Sep-06 16:18 paul Assigned To => paul 26-Sep-06 23:10 aaron Note Added: 0001420 30-Sep-06 19:54 paul Status assigned => resolved 30-Sep-06 19:54 paul Resolution open => fixed 04-Oct-06 00:21 windowsrefund Status resolved => feedback 04-Oct-06 00:21 windowsrefund Resolution fixed => reopened 04-Oct-06 00:21 windowsrefund Note Added: 0001444 ======================================================================
