thanks, I will try that.
Is it possible to fix the "fix foreign key' script ? I may not be the
only one with the issue...
Jorge Bastos wrote:
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] <mailto:[email protected]>
https://mailman.fastxs.nl/mailman/listinfo/dbmail
------------------------------------------------------------------------
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
