On 2014-07-02 19:14, Travis Dolan wrote:
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 :)
ok, a few questions for starters:
- what piler version do you use?
- have you installed sphinx from source or with a package manager?
- do you have any dailydelta1.* files in /var/piler/sphinx?
- if not, then how is it possible that you have reference in the sphinx
query?
Janos
