Mailing List Archive

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....