Hi Janos,
no, I do not get any result.
> Login as an auditor, hit the search button, and you should be able to see
> some results.
Yes; i see 1000 records.
> 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.
No results.
the query.log entry is:
/* Sat Oct 07 15:28:23.418 2023 conn 131 real 0.000 wall 0.000 found 0 */
SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('@sender jobXalertXhaysXde
') ORDER BY sent DESC;
The error message in the UI is:
Empty search result. Try adding the wildcard character(*) after a word snippet
(min. 5 characters), eg. duplic* to find "duplicate", "duplicated", etc.
Any idea?
Andreas
----- Ursprüngliche Mail -----
| Von: "Janos SUTO" <s...@acts.hu>
| An: "Piler User" <piler-user@list.acts.hu>
| CC: "Andreas" <pi...@apconsulting.de>
| Gesendet: Samstag, 7. Oktober 2023 17:19:50
| Betreff: Re: Version Upgrade/ Date Migration
| 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
(null)
