Sphinx 3.3.1

[miguel]

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.

‌

‌

[Janos SUTO]

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 to sender or similar in a later release.

[Janos SUTO]

Wait, the issue requires more work. For the moment, sphinx 3.3.1 is not supported.

[Janos SUTO]

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.

[miguel]

ok

[Janos SUTO]

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.

‌

[miguel]

Thanks for resolved.

One question.

How upgrade piler 1.3.8 build 998 to new one?

Thanks again.

[Janos SUTO]

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.