Hi Arun In your config/development.sphinx.conf file, you'll find the profile_core_0 source - what's the sql_query value in that source?
-- Pat On 26/06/2010, at 3:38 PM, Arun wrote: > Hi, > I want retrieve the company name in the profile model but due to > relationship ,it is not get indexed. > > I am using the Profile model for indexes > 1.In the profile model > belongs_to :user > 2. In the user model > belongs_to :address, :dependent => :destroy > 3. In the address model > belongs_to :country > so i given the indexes like this > indexes user.address.country.name but it is throwing error like this > "indexing index 'profile_core'... > ERROR: index 'profile_core': sql_range_query: Unknown column > 'profiles.name' in 'field list' (DSN=mysql://root:*...@localhost:" > > -- > 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.
