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 > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > -- Scanned for viruses and dangerous content by MailScanner _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
