On 2023-10-07 18:06, Andreas wrote:
i checked 2 messages, one with only one receipient, another one wit 13
receipient.
The data fits 100% to the downloaded mail.
If this means that the recipient in the email is in the rcpt to table,
then fine. Now grab a few words from the email, and search for them.
Again, nothing fancy, no wildcards, etc. just 2 to 3 words. Then
check the sphinx query from the mail log. You should see some hits.
Janos
----- Ursprüngliche Mail -----
| Von: "Janos SUTO" <s...@acts.hu>
| An: "Piler User" <piler-user@list.acts.hu>
| Gesendet: Samstag, 7. Oktober 2023 17:46:01
| Betreff: Re: Version Upgrade/ Date Migration
| OK, then click on a message, the hover the mouse over the download
link
| on the lower preview pane. It reveals the message id, eg. 123. Then
| run the following sql query, and check if the from and:
|
| select id, piler_id, `from` from metadata where id=123;
| select id, `to` from rcpt where id=123;
|
| These queries should reveal the From: and To/Cc: header values
| from the email. Check if they actually match with the email.
| You may retrieve the email with the pilerget utility, or simply
| download it.
|
| Janos
|
| On 2023-10-07 17:32, Andreas wrote:
|> 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)
(null)
