Auditor cannot Search to/from

[Karl Rossing]

Running piler-1.3.10

If I login as auditor, I receive no search results when I search to/from. Search results are returned when searching subject, body, date from/to, attachment type.

‌

[Janos SUTO]

What’s the sphinx query when the auditor searches? See the mail log.

[Karl Rossing]

Query with nothing

Feb 14 11:23:53 wdc-piler1 piler-webui[244674]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE        MATCH('') ORDER BY `sent` DESC LIMIT 0,20 OPTION max_matches=1000' in 0.59 s, 20 hits, 6780571 total found

Gmail query:

Feb 14 11:24:15 wdc-piler1 piler-webui[188289]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE        MATCH('@sender gmail.com ') ORDER BY `sent` DESC LIMIT 0,20 OPTION max_matches=1000' in 0.00 s, 0 hits, 0 total found

‌

[Janos SUTO]

Try settings SPHINX_STRICT_SCHEMA to 0 in config-site.php.

[Janos SUTO]

No news is good news.

[Ratnateja Thaduri]

I have the exact same issue. Did you find a solution for this?

Is it something related to permissions or DB issue?

‌

[Janos SUTO]

Show me the sphinx query that is logged to mail log.

[Janos SUTO]

No news is good news.