Sphinx 3.3.1
hi all.
There are new version of Sphinx , i have older Sphinx 3.2.1. I install the new one and replace the files in usr/bin then:
/etc/init.d/rc.searchd stop
rm -rf /var/piler/sphinx/
indexer --all --config /usr/local/etc/piler/sphinx.conf piler
Sphinx 3.3.1 (commit b72d67b)
Copyright (c) 2001-2020, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com))
using config file '/usr/local/etc/piler/sphinx.conf'...
indexing index 'main1'...
ERROR: index 'main1': reserved field name 'from'.
total 0 docs, 0.0 Kb
total 0.0 sec, 0.0 Kb/sec, 0 docs/sec
indexing index 'main2'...
ERROR: index 'main2': reserved field name 'from'.
total 0 docs, 0.0 Kb
total 0.0 sec, 0.0 Kb/sec, 0 docs/sec
indexing index 'main3'...
ERROR: index 'main3': reserved field name 'from'.
total 0 docs, 0.0 Kb
total 0.0 sec, 0.0 Kb/sec, 0 docs/sec
indexing index 'main4'...
ERROR: index 'main4': reserved field name 'from'.
total 0 docs, 0.0 Kb
total 0.0 sec, 0.0 Kb/sec, 0 docs/sec
indexing index 'dailydelta1'...
ERROR: index 'dailydelta1': reserved field name 'from'.
total 0 docs, 0.0 Kb
total 0.0 sec, 0.0 Kb/sec, 0 docs/sec
indexing index 'delta1'...
ERROR: index 'delta1': reserved field name 'from'.
total 0 docs, 0.0 Kb
total 0.0 sec, 0.0 Kb/sec, 0 docs/sec
indexing index 'tag1'...
collected 0 docs, 0.0 MB
total 0 docs, 0.0 Kb
total 0.0 sec, 0.0 Kb/sec, 0 docs/sec
indexing index 'note1'...
collected 0 docs, 0.0 MB
total 0 docs, 0.0 Kb
total 0.0 sec, 0.0 Kb/sec, 0 docs/sec
i think this version is not compatible whit piler.
i reinstall older version and reindex all and no errors found.
Comments (10)
-
repo owner -
repo owner - changed status to resolved
-
repo owner - changed status to open
-
repo owner Wait, the issue requires more work. For the moment, sphinx 3.3.1 is not supported.
-
repo owner OK, I’ve fixed the master branch to support sphinx 3.3.1. However, it requires the sql query and the full text search fields to be fixed, and thus requires a complete reindex. I’ll add the procedure to the docs soon, and keep you posted.
-
reporter ok
-
repo owner So, thanks for your patience, do the following to use sphinx-3.3.1 with piler. Download piler-1.3.9 (I’ve just released it today).
Then set the following in config-site.php:
$config['SPHINX_STRICT_SCHEMA'] = 1;
And this in sphinx.conf:
define('SPHINX_STRICT_SCHEMA', 1);
Then you need to drop the contents of /var/piler/sphinx directory, initialize all index with indexer --all --config /usr/local/etc/piler/sphinx.conf, and finally reindex everything.
-
repo owner - changed status to resolved
-
reporter Thanks for resolved.
One question.
How upgrade piler 1.3.8 build 998 to new one?
Thanks again.
-
repo owner Get the master branch at the download section, and simply install it. No database schema has changed. Then initialize the sphinx database with indexer --all, and finally reindex everything.
- Log in to comment
You are right, sphinx 3.3.1 has a slightly picky parser for the sql query line. I’ve fixed the problem with a commit: https://bitbucket.org/jsuto/piler/commits/08d5d0129d39cbfddef8b1941432c46196a526d2, please apply it, and let me know how it goes. Thanks for reporting the issue.
It’s likely that I’ll renamed the
from
column tosender
or similar in a later release.