When you created the tables something went wrong or you created them in MyISAM and convert to InnoDB.
The foreign keys are on the create_tables.sql Alter table dbmail_subscription add FOREIGN KEY user_id_fk (user_id) REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON UPDATE CASCADE; Alter table dbmail_subsctiption add FOREIGN KEY mailbox_id_fk (mailbox_id) REFERENCES dbmail_mailboxes (mailbox_idnr) ON DELETE CASCADE ON UPDATE CASCADE; From: [email protected] [mailto:[email protected]] On Behalf Of Joan Moreau Sent: domingo, 15 de Fevereiro de 2009 19:29 To: DBMail mailinglist Subject: Re: [Dbmail] Segfault in the git CREATE TABLE `dbmail_subscription` ( `user_id` bigint(21) NOT NULL DEFAULT '0', `mailbox_id` bigint(21) NOT NULL, PRIMARY KEY (`user_id`,`mailbox_id`), KEY `user_id_index` (`user_id`), KEY `mailbox_id_index` (`mailbox_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED Jorge Bastos wrote: Maybe can you update the "fix foreign keys" script in sql/mysql/ , so I can see if this is the case ? Show us the output of: show create table dbmail_subscription; _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
