Never mind, if you don't have that key it's normal
> -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Joan Moreau > Sent: domingo, 15 de Fevereiro de 2009 19:55 > To: DBMail mailinglist > Subject: Re: [Dbmail] Segfault in the git > > but does not work :-( > > mysql> SET FOREIGN_KEY_CHECKS=0; > Query OK, 0 rows affected (0.00 sec) > > mysql> alter table dbmail_subscription drop foreign key user_id_fk; > ERROR 1025 (HY000): Error on rename of > './services_dbmail/dbmail_subscription' to > './services_dbmail/#sql2-f3e-8d22' (errno: 152) > > > > Jorge Bastos wrote: > > Hum didn't saw that, > > > > But what's inside is correct: > > > > --- > > SET FOREIGN_KEY_CHECKS=0; > > alter table dbmail_subscription drop foreign key user_id_fk; > > alter table dbmail_subscription drop foreign key mailbox_id_fk; > > alter table dbmail_subscription drop foreign key > dbmail_subscription_ibfk_1; > > alter table dbmail_subscription drop foreign key > dbmail_subscription_ibfk_2; > > alter table dbmail_subscription drop foreign key > dbmail_subscription_ibfk_3; > > 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_subscription add FOREIGN KEY mailbox_id_fk > (mailbox_id) > > REFERENCES dbmail_mailboxes (mailbox_idnr) ON DELETE > CASCADE ON > > UPDATE CASCADE; > > SET FOREIGN_KEY_CHECKS=1; > > --- > > > > > >> -----Original Message----- > >> From: [email protected] [mailto:[email protected]] > On > >> Behalf Of Joan Moreau > >> Sent: domingo, 15 de Fevereiro de 2009 19:47 > >> To: DBMail mailinglist > >> Subject: Re: [Dbmail] Segfault in the git > >> > >> > >> > >>> Foreign key script? > >>> > >>> > >>> > >> yes, : dbmail/sql/mysql/fix_foreign_keys.mysql > >> > >> _______________________________________________ > >> DBmail mailing list > >> [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 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
