No, it wasn't me. I had the problem less than 2 weeks ago. I'm not using any guy. Well, I'm using phpMyAdmin but haven't touched the dbmail database since I rebuilt it 2 weeks ago.
I have strong feelings about mysql itself. In data 31/5/2007, "Jesse Norell" <[EMAIL PROTECTED]> ha scritto: >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 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
