Jonathan Feally wrote:
> 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.
Still, the setup in dbmail-mailbox.c,_append_join_headervalue is broken
imo. That query should be reduced to something simpler.
>
> -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
>> [email protected]
>> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
>>
>>
>
>
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
