Thanks Timo, that's a good point - I've just shifted it to be with the rest of the index definition documentation.
On 16/01/2013, at 5:59 PM, Timo Virkkala wrote: > Hi Pat, > > When I was reading through the README, I thought that that mention of > the namespaced models in index definitions should perhaps be moved > right next to the original mention of how to define indexes. Perhaps > Ahmed's question is proof that it should be moved? > > -Timo Virkkala > > On Wed, Jan 16, 2013 at 12:59 AM, Pat Allan <[email protected]> wrote: >> Hi Ahmed >> >> Just yesterday I pushed a patch to get searching working on namespaced >> models - essentially, the class names need to be quoted in the query >> (@sphinx_internal_class_name ("Lcbo::Store")). So if you grab the latest >> from the edge branch, you should be good to go. >> >> gem 'thinking-sphinx', >> :git => 'git://github.com/pat/thinking-sphinx.git', >> :ref => 'bb56c29ea5' >> >> As for index definitions, it's mentioned in the README (but many things are, >> so you have to know to look for it) - the index reference should be a >> string, with a slash indicating the namespaced nature of the model: >> >> ThinkingSphinx::Index.define 'lcbo/store', with: :active_record do >> # >> end >> >> Hope this helps! >> >> -- >> Pat >> >> On 16/01/2013, at 4:45 AM, Daly wrote: >> >>> 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. >> >> >> >> -- >> 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. >> > > -- > 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. > -- 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.
