Ah, that makes perfect sense. Thanks James! - Will
On Jun 25, 5:38 pm, James Healy <[email protected]> wrote: > Will Clark wrote: > > class CompanyProfile < ActiveRecord::Base > > belongs_to :sector, :counter_cache => true > > belongs_to :industry, :counter_cache => true > > > define_index do > > indexes :name, ticker, description, profile > > indexes [sector.name, industry.name], :as => :extras > > where "active = 't'" > > end > > end > > > When I run rake ts:in I get this error: > > > ERROR: index 'company_profile_core': sql_range_query: ERROR: column > > reference "active" is ambiguous > > > If I comment out the :extras index, the index will build without a > > problem. > > Do your sectors or industries tables have an active column as well? > > Assuming your tables follow rails naming conventions, try changing your > where line to: > > where "company_profiles.active = 't'" > > -- James Healy <jimmy-at-deefa-dot-com> Fri, 26 Jun 2009 09:36:35 +1000 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
