I've fixed this in our source repository, and 2.2.5 will not have this bug. Thanks for the detailed problem report!
Aaron On Tue, 2007-03-20 at 17:48 +0000, Peter, Oliver wrote: > Dear, > > Since I'm using mutt with IMAPs (trough stunnel) and DBMAIL I have the > following problem when I try to make changes to a mailbox with flagged > e-mails: > > > /var/log/maillog: > > Mar 20 18:30:19 etain dbmail/imap4d[41089]: Error query failed [UPDATE > dbmail_messages SET > recent_flag=0,seen_flag=1,answered_flag=0,deleted_flag=0,flagged_flag=0,draft_flag=0,recent_flag=0 > WHERE message_idnr = 62218 AND status < 2 AND mailbox_idnr = 18] : > [ERROR: multiple assignments to same column "recent_flag" ] > > Mar 20 18:30:19 etain dbmail/imap4d[41089]: Error could not set flags > > > As you can see, recent_flag is listed twice in the UPDATE statement. > > > This is dbmail-2.2.4 with postgresql-server-8.2.3 on a 6.2-RELEASE-p2 > FreeBSD (i386) machine. > > Please feel free to contact me if you need more details. > > Thanks in advance, Bye > Ollie > > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail