More detail about this. Here's the index:
ThinkingSphinx::Index.define :title, :with => :active_record do
set_property :group_concat_max_len => 10.megabytes
indexes :title, :sortable => true
indexes teaser
indexes content.plain, :as => :plain_text
indexes author_name, :sortable => true
has roles(:person_id), :as => :people_ids
has :id, :as => :title_id
has author_id, created_at, updated_at
has set, :as => :title_set
where sanitize_sql(["publish", true])
end
The set column is an integer.
The controller interprets this request thusly:
def set
@results = Title.search
"\"#{ThinkingSphinx::Query.escape(params[:q].to_s)}\"",
:with => {:title_set => params[:set]},
:page => params[:page],
:star => true,
:excerpts => {
:limit => 1000,
:around => 40,
:force_all_words => true,
:chunk_separator => '</li><li>'
} rescue Kaminari::paginate_array []
@results.context[:panes] << ThinkingSphinx::Panes::ExcerptsPane
@hits = @results.total_entries rescue 0
end
Like I said, it's a very old app.
Walter
> On Apr 17, 2020, at 4:22 PM, Walter Lee Davis <[email protected]> wrote:
>
> index title_core: unsupported filter type 'string' on int column - SELECT *
> FROM `title_core` WHERE MATCH('\"epicurus\"') AND `title_set` = '1851' AND
> `sphinx_deleted` = 0 LIMIT 0, 20; SHOW META):
>
> This is coming right out of my logs today. It has not been a problem in the
> past.
>
> Walter
>
> --
> You received this message because you are subscribed to the Google Groups
> "Thinking Sphinx" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/thinking-sphinx/33D96497-05FF-4816-9ADD-0A29CB80E0FE%40wdstudio.com.
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/thinking-sphinx/ED1246D3-EFEB-4DA3-A47E-1850C1D67B95%40wdstudio.com.
