I've been using DBMail for a while now and I upgraded to 2.0+ (whatever
the CVS HEAD is) and I started having serious problems. I perused the
logs and found that I kept getting this error:
UPDATE dbmail_messages SET
recent_flag=0,seen_flag=1,answered_flag=0,deleted_flag=1,flagged_flag=0,draft_flag=0,recent_flag=0
WHERE message_idnr BETWEEN '17749' AND '17749' AND status < '2' AND
mailbox_idnr = '35'] : [ERROR: multiple assignments to same column
"recent_flag" ]
So I glanced through the code and found where it was being set twice (in
the CVS HEAD it's in db.c on line 3316):
snprintf(query, DEF_QUERYSIZE, "UPDATE %smessages SET
recent_flag=0,",DBPFX);
I replaced it with this:
snprintf(query, DEF_QUERYSIZE, "UPDATE %smessages SET ",DBPFX);
And it seems to work now. Without this fix the IMAP server is
completely unusable on my server. Am I the only one that has had this
problem? I must also note that I'm using PostgreSQL so if you're using
MySQL it may not come up.
Just thought I'd get all this out there so someone could see what's
going on.
--
Tim Mattison <[EMAIL PROTECTED]>
Mattison & Rosenthal Consulting Inc.
