Greetings,
I'm attempting to run the indexer on a PostgreSQL configuration, but
am running into the following error:
$ rake RAILS_ENV=production thinking_sphinx:index
indexer --config ****/config/production.sphinx.conf --all
Sphinx 0.9.8.1-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff
using config file '****/config/production.sphinx.conf'...
indexing index 'entry_core'...
ERROR: index 'entry_core': sql_range_query: ERROR: syntax error at or
near "SEPARATOR"
LINE 1: ..."entries"."id", CAST(GROUP_CONCAT("lemmas"."text"
SEPARATOR ...
^
(DSN=pgsql://lang:[EMAIL PROTECTED]:5432/****).
total 0 docs, 0 bytes
total 0.019 sec, 0.00 bytes/sec, 0.00 docs/sec
distributed index 'entry' can not be directly indexed; skipping.
(I've censored some directory paths and hostnames above with ****)
If I remember correctly from my Ultrasphinx days, there was a
migration which added stored procedures like GROUP_CONCAT to the
PostrgeSQL database. I see no similar mechanism for Thinking
Sphinx.
For what it's worth, I'm running PostgreSQL 8.3.4. Any assistance
would be greatly appreciated!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---
