Re: [Dbmail] Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder
On Donnerstag 23 Juli 2009 Jonathan Feally wrote: > > select * from dbmail_messages where physmessage_id IN (select > > physmessage_id from dbmail_subjectfield where subjectfield like > > 'Annoying%DELETE THIS MESSAGE%'); > > > > Instead of "select *" simply write "DELETE" and those messages are > > gone. > > > > mfg zmi > > > > I'm glad you responded first. I forgot about those views and was > going to give a very nasty query back to do it. That should work in > both 2.2.x and 2.3.x :-) Please anybody doing above query be reminded to change the Subject you are searching for - otherwise you delete all mails belonging to this thread ;-) My advise is to make the "select" first to see if it works, and only afterwards change it to "delete". mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 signature.asc Description: This is a digitally signed message part. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder
Michael Monnerie wrote: > > select * from dbmail_messages where physmessage_id IN (select > physmessage_id from dbmail_subjectfield where subjectfield like > 'Annoying%DELETE THIS MESSAGE%'); > > Instead of "select *" simply write "DELETE" and those messages are gone. > > mfg zmi > I'm glad you responded first. I forgot about those views and was going to give a very nasty query back to do it. That should work in both 2.2.x and 2.3.x -Jon -- Scanned for viruses and dangerous content by MailScanner ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder
On Donnerstag 23 Juli 2009 Piotr Wadas wrote: > When administrator migrates mbox folders to dbmail, in some of them > is a imap message, common pop3/imap ignores it, but when migrated, > this message appears on the list, and frightened users call support, > to ask "what is this and what shall I do with this". And yes, this is > no joke. Any quick sql query to delete from database all messages for > all users (envelopes and bodies) with particular SUBJECT header? or > for particular user? I'd rather to delete the messages, than delete > envelope and let dbmail-util do the rest (it has enough to do with > really deleted messages). Probably Net::POP3 perl script would do the > same, but removing from tables would be much simplier. select * from dbmail_messages where physmessage_id IN (select physmessage_id from dbmail_subjectfield where subjectfield like 'Annoying%DELETE THIS MESSAGE%'); Instead of "select *" simply write "DELETE" and those messages are gone. mfg zmi -- // Michael Monnerie, Ing.BSc- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: [Dbmail] Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder
See dbmail-export man page. You want -D and -s with an imap search matching your subject. See the Exmaples section, and if you need help with the search string, either run it in your imap client and see what it uses, or ask back on the list. And you might use -u to restrict your tests to a specific user until you have it "right". On Wed, 2009-07-22 at 23:01 -0700, Piotr Wadas wrote: > Hello, > > When administrator migrates mbox folders to dbmail, in some of them > is a imap message, common pop3/imap ignores it, but when migrated, > this message appears on the list, and frightened users call support, to > ask "what is this and what shall I do with this". And yes, this is no joke. > Any quick sql query to delete from database all messages for all users > (envelopes and bodies) with particular SUBJECT header? or for particular > user? I'd rather to delete the messages, than delete envelope and let > dbmail-util do the rest (it has enough to do with really deleted messages). > Probably Net::POP3 perl script would do the same, but removing from > tables would be much simplier. > > Regards, > DT -- Jesse Norell Kentec Communications, Inc. je...@kci.net ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
[Dbmail] Annoying "DONT DELETE THIS MESSAGE" with previously used imap inbox folder
Hello, When administrator migrates mbox folders to dbmail, in some of them is a imap message, common pop3/imap ignores it, but when migrated, this message appears on the list, and frightened users call support, to ask "what is this and what shall I do with this". And yes, this is no joke. Any quick sql query to delete from database all messages for all users (envelopes and bodies) with particular SUBJECT header? or for particular user? I'd rather to delete the messages, than delete envelope and let dbmail-util do the rest (it has enough to do with really deleted messages). Probably Net::POP3 perl script would do the same, but removing from tables would be much simplier. Regards, DT -- View this message in context: http://www.nabble.com/Annoying-%22DONT-DELETE-THIS-MESSAGE%22-with-previously-used-imap-inbox-folder-tp24619758p24619758.html Sent from the dbmail users mailing list archive at Nabble.com. ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail