Tim Mattison wrote:
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" ]
Ah. A premature and ill considered attempt at fixing bug #97.
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);
Fixed accordingly.
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
