Thanks Paul for your help I will download dbmail_2_0_branch and give it a try.
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 Selon Paul J Stevens <[EMAIL PROTECTED]>: > 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 > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
