On 2023-10-07 07:35, Andreas wrote:
I can see in the file query.log the following queries:
/* Sat Oct 07 05:27:27.075 2023 conn 112 real 0.000 wall 0.000 found 0
*/ SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('
apconsulting') ORDER BY sent DESC;
/* Sat Oct 07 05:30:23.492 2023 conn 113 real 0.000 wall 0.000 found 0
*/ SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('
*apconsulting*') ORDER BY sent DESC;
with advanced search i find entries like
/* Sat Oct 07 05:31:27.427 2023 conn 114 real 0.000 wall 0.000 found 0
*/ SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('@rcpt
apconsulting.de ') ORDER BY sent DESC;
/* Sat Oct 07 05:32:17.605 2023 conn 115 real 0.000 wall 0.000 found 0
*/ SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('@subject Test
') ORDER BY sent DESC;
all of them above without query result.
only these queries work:
/* Sat Oct 07 05:33:16.686 2023 conn 116 real 0.023 wall 0.024 found
519 */ SELECT id FROM main1,dailydelta1,delta1 WHERE sent BETWEEN
1690840800 AND 1693519199 ORDER BY sent DESC;
/* Sat Oct 07 05:34:21.063 2023 conn 117 real 0.001 wall 0.001 found
537 */ SELECT id FROM main1,dailydelta1,delta1 WHERE sent>=1690840800
ORDER BY sent DESC;
Login as an auditor, hit the search button, and you should be able to
see some results. Then click on a message, observe the From: address,
and type it to the search bar (no wildcard, nothing fancy, just the
email address), and you should be able to see the same message in
the search results.
Also every time you try a search query, then check the mail log for the
sphinx query and results.
Janos
