Sphinx problem

Post Reply
filthlab
Posts: 118
Joined: Tue May 30, 2017 6:49 am

Sphinx problem

Post by filthlab »

Hi,
we are trying to setup the Sphinx.
We are getting the next error:

Error:Mysql error:: 1064 (sphinxql: syntax error, unexpected $undefined, expecting $end near ':porn_index WHERE match ('teen') AND categories NOT IN (1143) LIMIT 0, 100 OPTION max_matches=20000') (db_sphinx) in query SELECT id FROM porn_index,delta:porn_index WHERE match ('teen') AND categories NOT IN (1143) LIMIT 0, 100 OPTION max_matches=20000. (filthlab.com)
Fatal error: Class 'Log' not found in /var/www/filthlab.com/scj/includes/libs/functions.php on line 0
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Sphinx problem

Post by admin »

in sphinx index name can not have a semicolon (delta:porn_index)
Just give another name to your delta index
Don't forget to run script update
filthlab
Posts: 118
Joined: Tue May 30, 2017 6:49 am

Re: Sphinx problem

Post by filthlab »

Can we have some workable config, just to change our paths and so on?
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Sphinx problem

Post by admin »

http://smartcj.com/wiki/doku.php?id=tcm ... inx_config

this is a working config

All yoг have to do is to change index name in your case.
Don't forget to run script update
Post Reply