Using the piler GUI and searching for "", I get the following in my syslog
SELECT id FROM dailydelta1,main1 WHERE MATCH('') ORDER BY `sent` DESC
LIMIT 0,5000 OPTION max_matches=5000
I do not have a index called dailydelta1. So this query return 0 results.
There was mention of a dailydelta1 in /etc/sphinxsearch/sphinx.conf however
I was under the impression that piler/sphinx used/uses
/usr/local/etc/sphinx.conf.
To attempt to troubleshoot this issues I ensured that both files mentioned
above were the same, restart sphinx and still no love.
Please help me unbreak my stuff :)
--
Travis Dolan
Senior Systems and Network and Security Officer of Global Infrastructure
Operations
Direct: 604.214.8562 I Fax: 604.214.8556
