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
