Re: deleting old spam mail

Paul J Stevens wrote:
> the basic query for getting the message_idnrs involved
is:
> 
> select message_idnr from  dbmail_messages m join
dbmail_mailboxes b ON
> m.mailbox_idnr=b.mailbox_idnr JOIN dbmail_physmessage p
ON
> p.id=m.physmessage_id WHERE p.internal_date < 'NOW -
30 days' AND b.name
> LIKE "spam";
> 

Thanks, this select looks good. The 'NOW - 30 days' didn't
really work
though, I've come up with this select query:

mysql> select count(message_idnr) from  dbmail_messages m
join
dbmail_mailboxes b ON m.mailbox_idnr=b.mailbox_idnr JOIN
dbmail_physmessage p ON p.id=m.physmessage_id WHERE
p.internal_date <
date_sub(now(), interval 30 day) AND b.name LIKE
"spam";
+---------------------+
| count(message_idnr) |
+---------------------+
|               46133 |
+---------------------+
1 row in set (0.50 sec)

Double checked everything and it does look good.

 > Michael Luich wrote:
 >> try this:
 >
 > Please don't!

No worries, I first checked the select query Michael
proposed so no
mails were deleted by accident.



About finally deleting the mails. The deleted_flag is IMAP
only -- 
whether the user can see the email in his mailbox or not.
status=2 on 
the other hand is used by dbmail util to set the email for
deletion.

So I think the correct thing to do would be to set
deleted_flag=1 AND 
status=2. Agreed?



On another note.

When investigating this I realised that when I click Delete
in the TB's 
Trash folder only "deleted_flag" is set to 1,
status is not touched. 
When I finally close TB, the status is also set to 2.

How and by whom is the status modified? If I leave TB open
indefinitely 
will my emails never be really deleted?


Thanks,


-- 
Aleksander Kamenik
system administrator
+372 6659 649
aleksanderkrediidiinfo.ee

Krediidiinfo AS
http://www.krediidiinfo.e
e/

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail