Walter Lee Davis
unread,Feb 28, 2019, 11:34:04 PM2/28/19Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
  to thinkin...@googlegroups.com
I am using TS again after many years, and so I have installed the latest Sphinx 3 and the latest TS 4.1.0 with my Rails 5.1.6.1 project. I am getting an odd response from Sphinx when I search:
  Sphinx  Unexpected search options: [:excerpts]
This is happening on Mac OS in development mode.
Here is my controller method:
    @results = ThinkingSphinx.search(ThinkingSphinx::Query.escape(params[:q]), :excerpts => {
      :limit    => 1000,
      :around     => 40,
      :force_all_words => true,
      :chunk_separator => ' … '
    })
    @results.context[:panes] << ThinkingSphinx::Panes::ExcerptsPane
And here is the index:
# frozen_string_literal: true
ThinkingSphinx::Index.define :document, :with => :active_record do
  where sanitize_sql(["published", true])
  
  indexes title
  indexes teaser
  indexes body_html
  indexes author
  has created_at, updated_at
end
configuration:
indexer
{
}
searchd
{
  listen = 127.0.0.1:9306:mysql41
  log = /Volumes/eddy/Users/waltd/Documents/sandbox/lf-smith/log/development.searchd.log
  query_log = /Volumes/eddy/Users/waltd/Documents/sandbox/lf-smith/log/development.searchd.query.log
  pid_file = /Volumes/eddy/Users/waltd/Documents/sandbox/lf-smith/log/development.sphinx.pid
  workers = threads
  binlog_path = /Volumes/eddy/Users/waltd/Documents/sandbox/lf-smith/tmp/binlog/development
}
source document_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 
  sql_db = lf-smith_development
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT SQL_NO_CACHE `documents`.`id` * 4 + 0 AS `id`, `documents`.`title` AS `title`, `documents`.`teaser` AS `teaser`, `documents`.`body_html` AS `body_html`, `documents`.`author` AS `author`, `documents`.`id` AS `sphinx_internal_id`, 'Document' AS `sphinx_internal_class`, 0 AS `sphinx_deleted`, UNIX_TIMESTAMP(`documents`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`documents`.`updated_at`) AS `updated_at` FROM `documents` WHERE (`documents`.`id` BETWEEN $start AND $end AND published) GROUP BY `documents`.`id`, `documents`.`title`, `documents`.`teaser`, `documents`.`body_html`, `documents`.`author`, `documents`.`id`, `documents`.`created_at`, `documents`.`updated_at` ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`documents`.`id`), 1), IFNULL(MAX(`documents`.`id`), 1) FROM `documents`
  sql_attr_uint = sphinx_deleted
  sql_attr_bigint = sphinx_internal_id
  sql_attr_timestamp = created_at
  sql_attr_timestamp = updated_at
  sql_attr_string = sphinx_internal_class
}
index document_core
{
  type = plain
  path = /Volumes/eddy/Users/waltd/Documents/sandbox/lf-smith/db/sphinx/development/document_core
  docinfo = extern
  morphology = stem_en
  html_strip = 1
  source = document_core_0
}
and core YAML file:
default: &default
  morphology: stem_en
  html_strip: true
development:
  <<: *default
test:
  <<: *default
production:
  <<: *default
All of this is ripped straight from the documentation, as far as I can see. Can you recommend any changes to make this work without that warning? Or do I not need to worry about that? The search seems to work just fine.
Walter