I have a model called Lcbo::Store, after upgrading to version 3.0.0 I can't
seem to use sphinx with it anymore. After much tinkering, I've reached the
following config:
# app/indices/store_index.rb
ThinkingSphinx::Index.define :"Lcbo::Store", name:"lcbo_store", with:
:active_record, delta:false do
indexes :address
indexes :intersection
indexes city.name, as: :city
end
running rake ts:index now runs successfully and generates the proper entry
in development.sphinx.conf. Unfortunately, it still fails with an actual
search with:
Mysql2::Error (sphinxql: syntax error, unexpected WHERE, expecting IDENT
near 'WHERE MATCH('brampto @sphinx_internal_class_name (Lcbo::Store)') AND
sphinx_deleted = 0 LIMIT 0, 100; SHOW META'):
What config changes do I need to make to have this work?
Thanks,
Ahmed
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/thinking-sphinx/-/bVointrCX88J.
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.
