Installed sphinxsearch -> configured the config -> created the forum_index index via indexer --all . Records have been indexed all without errors. Connected to the project SphinxQL . I set the parameters and make a request according to the example in ReadMe :
// create a SphinxQL Connection object to use with SphinxQL $conn = new Connection(); $conn->setParams(array('host' => 'localhost', 'port' => 9306)); But suddenly there was an error like
access denied www-data @ localhost password NO
Explicitly indicated the user and password within the location of the call
mysqli::real_connect() Passing the host, username, etc. parameters to it. connected to the database. Now when you run the query:
$query = SphinxQL::create($conn)->select('column_one', 'colume_two') ->from('forum_index'); $result = $query->execute(); and in response to an error
table forum_index does not exist
Tell me which way you can dig? It feels like just the lib does not use the sphinx config and doesn’t interact at all with the sphinx.