Jumping back to your first approach... if you use fits.vehicle.name, instead of fit.vehicle.name, then it should index without problems... you need to use the association name - so if it's plural, keep it plural, even though it may read better as singular.
-- Pat On 07/01/2010, at 3:00 PM, ct9a wrote: > Hi, guys, > > I need some help defining index when more than 1 accessor involved. > I have looked up the docs (http://rdoc.info/projects/freelancing-god/ > thinking-sphinx) to no success :( > > Consider this scenario. > > Search index to be built on a 'parts' object. > Each 'parts' object belongs to a 'fit' object. > A 'vehicle' object has many attributes among which is 'name'. > Each 'fit' object links a part with a vehicle (by vehicle_id and > part_id). > > I am trying to build an index by means of "indexes fit.vehicle > (:name), :as => :vehicle_name". > > > However, when I run "rake thinking_sphinx:index", I get the following > error: > > -------------------- Extract start -------------------- > (in /home/ct9a/projects/myApp) > Generating Configuration to /home/ct9a/projects/myApp/config/ > development.sphinx.conf > Sphinx 0.9.9-release (r2117) > Copyright (c) 2001-2009, Andrew Aksyonoff > > using config file '/home/ct9a/projects/myApp/config/ > development.sphinx.conf'... > indexing index 'part_core'... > ERROR: index 'part_core': sql_range_query: Unknown column > 'parts.name' in 'field list' > (DSN=mysql://root:*...@localhost:3306/myApp-development). > total 0 docs, 0 bytes > -------------------- Extract end -------------------- > > Here's how my model files look like. > > part.rb > ------- > class Part < ActiveRecord::Base > belongs_to :category > has_many :fits > > define_index do > indexes title > indexes fit.vehicle(:name), :as => :vehicle_name > end > end > > vehicle.rb > ---------- > class Vehicle < ActiveRecord::Base > has_many :fit > end > > fit.rb > ------ > class Fit < ActiveRecord::Base > belongs_to :part > belongs_to :vehicle > end > > I suspect that my syntax (indexes fit.vehicle(:name), :as > => :vehicle_name) > doesn't work when more than 1 accessor is involved (ie. parts to > access fits, > and fits to access vehicle name). Can anyone please guide me? > > Thank you. > -- > 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.
