Someone had that problem not long ago (you might search the mailing list within the last 2 months) - from memory, I think they were using a gui sql manager (mysqladmin maybe?) which was the source of their problem. It was doing something wrong, possibly to do with multi-byte characters?, that ended up dropping their constraints.
Although, as you mention it happened "again", I wonder if it's you that I was thinking of? :) If so, wasn't your problem some 3rd party program last time? On Thu, 2007-05-31 at 16:58 +0100, Andrea Brancatelli wrote: > Nobody changed anything on the DB in the latest week but here we are > again: > > May 31 17:49:34 carota dbmail/smtp[69105]: Error [Cannot delete or update > a parent row: a foreign key constraint fails > (`dbmail`.`dbmail_datefield`, CONSTRAINT `dbmail_datefield_ibfk_1` > FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`))] > [DELETE FROM dbmail_physmessage WHERE id = 210430] > May 31 17:49:34 carota dbmail/smtp[69105]: Error failed to delete > temporary message [260295] > May 31 17:49:34 carota dbmail/smtp[69105]: Warning 500 Permanent Failure > (null) ^C^M > > So unless mysql has lost the on delete and on update contraints again > (and I doubt but i don't exclude it), there must be some other problem. > > I'll run the alter table script to replace the constraints again but > I'm getting very frustrated by this. > > Any suggestion? -- Jesse Norell - [EMAIL PROTECTED] Kentec Communications, Inc. _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
