Running CentOS 5.2, Postgres 8.3.7.
On Wed, Sep 9, 2009 at 8:24 PM, Jonathan Feally <[email protected]>wrote: > What database server and version are you using? This seems like an older > database not able to handle that query. > > -Jon > > David Young wrote: > > Hi, I recently upgraded my dbmail to 2.2.11 and decided to create a > > new email account/mailbox to make sure everything is working > > correctly. I sent myself an email and retrieved it via outlook using > > dbmail-imapd. Below is the error I received in dbmail.err > > > > The email displays correctly, but wondering why I'm getting this > > error. My email accounts that existed before I upgrade don't cause > > this error. I should also mention that I also converted database type > > from SQL_ASCII to UTF8. > > > > Thanks, > > > > /var/log/dbmail.err > > > > 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 <http://p.id/> JOIN dbmail_messages m ON > > m..physmessage > > _id=p.id <http://p.id/> JOIN dbmail_headervalue v ON > > v.physmessage_id=p.id <http://p.id/> WHERE m.mailbox_idnr=53 AND > > m.status in (0,1) HAVING SUBSTRING(v.headervalue > > ,0,255) ILIKE '%multipart/encrypted%' OR k.messageblk ILIKE > > '%multipart/encrypted%'] : [ERROR: operator does not exist: bytea ~~* > > unkno > > wn > > LINE 1: ...55) ILIKE '%multipart/encrypted%' OR k.messageblk ILIKE > '%mu... > > ^ > > HINT: No operator matches the given name and argument type(s). You > > might need to add explicit type casts. > > ] > > > > Sep 10 00:39:49 node1.the.matrix dbmail-imapd[4957]: Error:[mailbox] > > dbmail-mailbox.c,mailbox_search(+1374): could not execute query > > > > > > > > -- > > David > > > > -- > > Scanned for viruses and dangerous content by *MailScanner* > > <http://www.mailscanner.info/> > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > DBmail mailing list > > [email protected] > > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > > > > -- > Scanned for viruses and dangerous content by MailScanner > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > -- David
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
