Hi Janos,
unfortunately no hits :-(
/* Sat Oct 07 17:26:44.129 2023 conn 19 real 0.000 wall 0.000 found 0 */ SELECT
id FROM main1,dailydelta1,delta1 WHERE MATCH(' impediments') ORDER BY sent DESC;
/* Sat Oct 07 17:27:53.169 2023 conn 21 real 0.000 wall 0.000 found 0 */ SELECT
id FROM main1,dailydelta1,delta1 WHERE MATCH(' clarify any impediments') ORDER
BY sent DESC;
/* Sat Oct 07 17:28:57.150 2023 conn 26 real 0.000 wall 0.000 found 0 */ SELECT
id FROM main1,dailydelta1,delta1 WHERE MATCH(' in Ihrem Postfach') ORDER BY
sent DESC;
Andreas
----- Ursprüngliche Mail -----
| Von: "Janos SUTO" <s...@acts.hu>
| An: "Piler User" <piler-user@list.acts.hu>
| Gesendet: Samstag, 7. Oktober 2023 18:59:58
| Betreff: Re: Version Upgrade/ Date Migration
| 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)
(null)
