A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=854 ====================================================================== Reported By: simonlange Assigned To: ====================================================================== Project: DBMail Issue ID: 854 Category: Command-Line programs (dbmail-users, dbmail-util) Reproducibility: unable to reproduce Severity: trivial Priority: normal Status: acknowledged target: ====================================================================== Date Submitted: 20-Aug-10 13:03 CEST Last Modified: 20-Aug-10 17:05 CEST ====================================================================== Summary: DBMAIL-UTIL DOES NOT FIX NULL MESSAGES Description: Although already 2005 reported http://www.mail-archive.com/dbm...@dbmail.org/msg06073.html
This bug is still there in dbmail 2.2.16 Usually dbmail-util should fix them but instead it just sets status to 6 of each message. Status 6 is not recognized by any cleanup processes of dbmail. Thats why null messages do stay in the database. a manual sql statemente (delete) removes them and fixes the error. this whole issues was discussed already in 2005 (5 years ago!) wonder noone else stumbled over it the past 5 years. Wharever, thats why i write this bug report. ====================================================================== ---------------------------------------------------------------------- (0003088) paul (administrator) - 20-Aug-10 14:26 http://www.dbmail.org/mantis/view.php?id=854#c3088 ---------------------------------------------------------------------- Simon, Took you long enough to file the bug then :-) It seems to me that these null message are an indication of a problem that arises elsewhere. I for one never see them, and they should not appear under normal circumstances. There may be a problem with your schema, or you maybe using non-dbmail tools to talk to and write into the dbmail database. ---------------------------------------------------------------------- (0003089) simonlange (reporter) - 20-Aug-10 17:05 http://www.dbmail.org/mantis/view.php?id=854#c3089 ---------------------------------------------------------------------- Paul, Its not MY schema. Its DBMAIL's schema. ;) Im using only dbmail-tools. its a fresh installation. database' health is fine. and the question is how it gets status6 if the util should remove nulls. and why the heck the util does not remove them anyway? says repaired but in fact it did nothing to remove them. so? its def a bug. my workaround i posted 5years ago still works. but its not the best way. better the util handles this, not a manual sql-statement. ;) regards Issue History Date Modified Username Field Change ====================================================================== 20-Aug-10 13:03 simonlange New Issue 20-Aug-10 14:26 paul Note Added: 0003088 20-Aug-10 14:27 paul Severity major => trivial 20-Aug-10 14:27 paul Reproducibility always => unable to reproduce 20-Aug-10 14:27 paul Status new => acknowledged 20-Aug-10 17:05 simonlange Note Added: 0003089 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev