SmartCJ Support Forum

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

in sphinx index name can not have a semicolon (delta:porn_index)
Just give another name to your delta index

Can we have some workable config, just to change our paths and so on?

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.