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....
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
