I reproduced the problem again by doing the same thing. Here's the
FULL error log. Sorry for the SPAM.
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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 ~~* unknown 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 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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/signed%' OR
k.messageblk ILIKE '%multipart/signed%'] : [ERROR: operator does not
exist: bytea ~~* unknown LINE 1: ...0,255) ILIKE '%multipart/signed%'
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 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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
'%application/x-pkcs7-mime%' OR k.messageblk ILIKE
'%application/x-pkcs7-mime%'] : [ERROR: operator does not exist:
bytea ~~* unknown LINE 1: ...LIKE '%application/x-pkcs7-mime%' OR
k.messageblk ILIKE '%ap...
^ HINT: No operator matches the given name and
argument type(s). You might need to add explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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 '%application/pkcs7-mime%'
OR k.messageblk ILIKE '%application/pkcs7-mime%'] : [ERROR: operator
does not exist: bytea ~~* unknown LINE 1: ... ILIKE
'%application/pkcs7-mime%' OR k.messageblk ILIKE '%ap...
^ HINT: No operator
matches the given name and argument type(s). You might need to add
explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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 '%* PGP%' OR k.messageblk
ILIKE '%* PGP%'] : [ERROR: operator does not exist: bytea ~~* unknown
LINE 1: ...eadervalue,0,255) ILIKE '%* PGP%' OR k.messageblk ILIKE '%*
.... ^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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 '%-----BEGIN PGP%' OR
k.messageblk ILIKE '%-----BEGIN PGP%'] : [ERROR: operator does not
exist: bytea ~~* unknown LINE 1: ...e,0,255) ILIKE '%-----BEGIN PGP%'
OR k.messageblk ILIKE '%--...
^ HINT: No operator matches the given name and
argument type(s). You might need to add explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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
'%application/pgp-encrypted%' OR k.messageblk ILIKE
'%application/pgp-encrypted%'] : [ERROR: operator does not exist:
bytea ~~* unknown LINE 1: ...IKE '%application/pgp-encrypted%' OR
k.messageblk ILIKE '%ap...
^ HINT: No operator matches the given name and
argument type(s). You might need to add explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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
'%application/pgp-signature%' OR k.messageblk ILIKE
'%application/pgp-signature%'] : [ERROR: operator does not exist:
bytea ~~* unknown LINE 1: ...IKE '%application/pgp-signature%' OR
k.messageblk ILIKE '%ap...
^ HINT: No operator matches the given name and
argument type(s). You might need to add explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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 '%-----BEGIN=20PGP%' OR
k.messageblk ILIKE '%-----BEGIN=20PGP%'] : [ERROR: operator does not
exist: bytea ~~* unknown LINE 1: ...0,255) ILIKE '%-----BEGIN=20PGP%'
OR k.messageblk ILIKE '%--...
^ HINT: No operator matches the given name and
argument type(s). You might need to add explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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 '%LS0tLS1CRUdJTiBQR1Ag%'
OR k.messageblk ILIKE '%LS0tLS1CRUdJTiBQR1Ag%'] : [ERROR: operator
does not exist: bytea ~~* unknown LINE 1: ...5) ILIKE
'%LS0tLS1CRUdJTiBQR1Ag%' OR k.messageblk ILIKE '%LS...
^ HINT: No operator
matches the given name and argument type(s). You might need to add
explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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 '%LS0tQkVHSU4gUEdQI%' OR
k.messageblk ILIKE '%LS0tQkVHSU4gUEdQI%'] : [ERROR: operator does not
exist: bytea ~~* unknown LINE 1: ...,255) ILIKE '%LS0tQkVHSU4gUEdQI%'
OR k.messageblk ILIKE '%LS...
^ HINT: No operator matches the given name and
argument type(s). You might need to add explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[sql]
dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr,
v.headervalue, 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 '%LS0tLUJFR0lOIFBHUC%' OR
k.messageblk ILIKE '%LS0tLUJFR0lOIFBHUC%'] : [ERROR: operator does
not exist: bytea ~~* unknown LINE 1: ...255) ILIKE
'%LS0tLUJFR0lOIFBHUC%' OR k.messageblk ILIKE '%LS...
^ HINT: No operator
matches the given name and argument type(s). You might need to add
explicit type casts. ]
Sep 10 19:07:27 dbmail/imap4d[16437]: Error:[mailbox]
dbmail-mailbox.c,mailbox_search(+1374): could not execute query
On Thu, Sep 10, 2009 at 9:56 AM, David Young <[email protected]> wrote:
>
> 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 email to
> the new mailbox. The error occurred when I selected the Inbox and the new
> message.
>
>
> David
>
>
> On Thu, Sep 10, 2009 at 8:23 AM, Michael Monnerie
> <[email protected]> wrote:
>>
>> 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.
>> ************
>> So, this is the query you posted stripped down:
>> SELECT k.messageblk FROM dbmail_messageblks k WHERE
>> k.messageblk ILIKE '%multipart/encrypted%';
>>
>> He's right, that query doesn't work on PG 8.1 either.
>>
>> How did you make dbmail run such a query? Looks like via a search, but I
>> guess that never worked and would be a bug then. So please, how can I
>> reproduce that query?
>>
>> mfg zmi
>> --
>> // Michael Monnerie, Ing.BSc ----- http://it-management.at
>> // Tel: 0660 / 415 65 31 .network.your.ideas.
>> // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
>> // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
>> // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
>>
>> _______________________________________________
>> DBmail mailing list
>> [email protected]
>> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
>
>
> --
> David
--
David
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
