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 JOIN dbmail_messages m ON m.physmessage
_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=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
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
