Dear piler-users,
sphinx has recently bumped up the version number, and 2.2.4 is the
recommended and preferred version of it.
Since sphinx is a key component for piler to work, I've fixed
sphinx.conf
to adjust to the new release.
I suggest you to read the following url on what changed:
http://sphinxsearch.com/blog/2013/09/11/deprecations-and-changes-in-the-2-2-series/comment-page-1/
The major changes are affecting piler:
- 32-bit document IDs are now deprecated. Though they are supported at
the moment, the
support will be removed in the future.
- dict=crc is now deprecated. It's the default dictionary in 2.0 and
perhaps in 2.1 releases
of sphinx, however the now default dict=keywords settings provides
better search results for
wildcard searches.
And there's a feature (or bug) for tags and notes in piler: an
attribute's name can't be 'id'.
So I had to rename it, and fix the sphinxql query. So anyone planning
to upgrade to the master
branch, please do the following after updating the gui:
edit sphinx.conf, and fix the source blocks for tag and note:
source tag : base
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT `_id`, `id` AS iid, `uid`, `tag` FROM `tag`
sql_attr_uint = iid
sql_attr_uint = uid
}
source note : base
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT `_id`, `id` AS iid, `uid`, `note` FROM `note`
sql_attr_uint = iid
sql_attr_uint = uid
}
Regarding the incompatible changes in sphinx I think you have two
options:
#1: upgrade sphinx only to a level where the current sphinx defaults
still work.
Notice that you will see some warnings, but your archive will be
operational.
#2: reinitialize sphinx indices, then reindex everything. I know that
it hurts, and the
more emails you have the more time it takes, but I think in the long
run this pays off.
As I want to support the cutting edge versions of sphinx, my 280k email
archive is just
being reindexed.
Anyway, as usual, don't just blindly copy over the actual shipped
sphinx.conf over your
current one. Most of the time it won't work.
And as usual, if you need help, just let me know.
Janos
