Jacques,
You hit a bug in the migration script.
Both the auto_notifications and auto_replies tables are missing
KEY (user_idnr)
like:
CREATE TABLE IF NOT EXISTS auto_notifications (
auto_notify_idnr bigint(21) default '0' not null auto_increment,
user_idnr bigint(21) DEFAULT '0' NOT NULL,
notify_address VARCHAR(100),
PRIMARY KEY (auto_notify_idnr),
KEY (user_idnr),
FOREIGN KEY (`user_idnr`)
REFERENCES `dbmail_users`(`user_idnr`) ON DELETE CASCADE
) TYPE=InnoDB;
I've fixed this in dbmail_2_0_branch.
Jacques Beaudoin wrote:
Hi all
I get this message when migrating dbmail-1.2.6 to dbmail-2.0.0
via the "migrate_from_1.x_to_2.0_innodb.mysql" script
ERROR 1005 at line 164 : Can`t create table
"./dmail/auto_notification.frm" (errno:150)
Line 164 in the script is:
CREATE TABLE IF NOT EXISTS auto_notifications (
auto_notify_idnr bigint(21) default '0' not null auto_increment,
user_idnr bigint(21) DEFAULT '0' NOT NULL,
notify_address VARCHAR(100),
PRIMARY KEY (auto_notify_idnr),
FOREIGN KEY (`user_idnr`)
REFERENCES `dbmail_users`(`user_idnr`) ON DELETE CASCADE
) TYPE=InnoDB;
Looking for any help
Thanks
Bien à vous
Jacques Beaudoin
Agent d'administration
Les services des technologies
de l'information et des communications
Commission scolaire de la Pointe de l'Île
Montréal, Québec, Canada
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
