[Dbmail-dev] [DBMail 0000804]: IMAP STATUS folder (UNSEEN) fails when using postgresql 8.4

2009-09-10 Thread Mantis Bug Tracker
A NOTE has been added to this issue. == http://www.dbmail.org/mantis/view.php?id=804 == Reported By:cloos Assigned To:

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread Michael Monnerie
On Donnerstag 10 September 2009 David Young wrote: Sep 10 00:39:49 node1.the.matrix dbmail-imapd[4957]: Error:[sql] dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr, v.header value, k.messageblk FROM dbmail_messageblks k JOIN dbmail_physmessage p ON k.physmessage_id=p.id JOIN

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread Michael Monnerie
On Donnerstag 10 September 2009 Michael Monnerie wrote: PostgreSQL 8.3 issue Interesting, I got this answer from a PG dev: There has *never* been a Postgres release that accepted bytea ILIKE something. I'm not sure what you were really doing before, but that wasn't it.

Re: [Dbmail] DBMAIL error on SELECT

2009-09-10 Thread David Young
First I created a new user on dbmail with dbmail-user with the following options (-a -s -w -p MD5-HASH). DBMAIL created the new user/mailbox successfully. Next, I created an IMAP mailbox using Outlook 2003 SP3. Connected to dbmail-imapd. Outlook showed a single mailbox (Inbox). I sent an