Re: SQL command to delete a single email message from database

Reindl Harald <[email protected]> Tue, 05 Aug 2014 16:31:07 +0200

Newsgroups	gmane.mail.imap.dbmail
Organization	the lounge interactive design
Message-ID	<[email protected]>

Am 05.08.2014 um 09:04 schrieb Administrator Beckspaced.com:
> retrieved this error yesterday from dbmail-util that it can't retireve the email message
> 
> Aug 04 23:11:01 ex4 dbmail-util[9554]: [0x1108890] Error:[message] dbmail_message_retrieve(+1108): retrieval failed
> for physid [172134]
> 
> even a dbmail-util -ay isn't able to fix this error
> 
> so how can i completely remove the email with physid[172134] from the database in phpmyadmin via an sql command?
> 
> or what would the best way be to repair this issue?

delete from dbmail_messages where physmessage_id=physid;

removes that message and after that "dbmail-util" will remove all
records belonging to that message and not shared with others, that's
how dbmail in general works even if you delete a message with IMAP

"shared with others" means that there could be a "dbmail_partlists"
record with a attachment also used by other tables, that's why
you just delete the reference and delegate the rest to "dbmail-util"

i would really love a dbmail-util switch to force-cleanup such
things instead dig in tables because if dbmail itself can't
say what is going on likely i can also not....

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

signature.asc (application/pgp-signature, 246 B)