What is the command line you/your client is issuing? I do not think that
it is a sort, as message-id is not one of the fields for sort that can
be used.
-Jon
Maxim Podorov wrote:
> I installed the latest code, fixed DB structure, rebuilt caches, and now
> the IMAP search on text headers (subject, from, to) gives empty result.
>
> BTW, during caches rebuilding the notices are written to the log:
> Notice:[message] dbmail_message_cache_referencesfield(+1762):
> reference_decode failed [11073]
> Is it necessary to log them at this debug level (notice)?
>
> Again, there's a problem with SQL code in searches. I've got syntax
> error message with the following SQL:
>
> SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON
> m.physmessage_id=p.id JOIN dbmail_headername hnMessage-ID ON
> hnMessage-ID.headername=lower('Message-ID') LEFT JOIN dbmail_header
> hMessage-ID ON (m.physmessage_id=hMessage-ID.physmessage_id AND
> hMessage-ID.headername_id=hnMessage-ID.id) LEFT JOIN dbmail_headervalue
> hvMessage-ID ON hMessage-ID.headervalue_id=hvMessage-ID.id WHERE
> mailbox_idnr=$1 AND status IN ($2,$3) AND hvMessage-ID.headervalue ILIKE
> $4 ORDER BY message_idnr
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
>
>
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
