Empty search

[Former user]

Hello. I´m using Piler 1.1.1. Empty search result. Try adding the wildcard character() after a word snippet, eg. duplic to find "duplicate", "duplicated", etc.

[Marcelo Machado Gomes]

Log search: piler-webui[18423]: sphinx query: 'SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('@(subject,body) gmail*') ORDER BY sent DESC LIMIT 0,1000 OPTION max_matches=1000' in 0.00 s, 0 hits, 3 total found

[Janos SUTO]

Can you describe your environment, eg. what os, distribution, sphinx version (from source or package) you use?

[Janos SUTO]

It appears that the sphinx package shipped with debian/ubuntu (v2.0.4) is not compatible with the gui. So I recommend to remove 2.0.4, and install a recent version of sphinx, either the deb package or even from source directly from the sphinx website.

After the sphinx upgrade is done, stop searchd, remove all sphinx index files (/var/piler/sphinx/*), then reinitialize it with indexer --all (running as user piler), and finally reindex everything with reindex -a