Pat... I am always impressed by your response time. The installation date I have is August 16th, 2009.
Is there a newer release since then that may help with this? Manish On Sep 6, 11:14 am, Pat Allan <[email protected]> wrote: > How recent is your version of Thinking Sphinx? Changes were made to > multi-value string facets a few weeks ago. If you're running something > really recent, I'll try to add a failing scenario, and figure out the > fix. > > -- > Pat > > On 06/09/2009, at 5:12 PM, mrmanishs wrote: > > > > > So, > > > That does index properly, but when I try to run facets, I get the > > following error: > > > NoMethodError: undefined method 'doors' for #<Array:0x271ad5c> > > from /opt/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/associations/association_proxy.rb:148:in `send' > > from /opt/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/associations/association_proxy.rb:148:in `send' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet.rb:95:in `translate' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet.rb:94:in `each' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet.rb:94:in `translate' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet.rb:75:in `value' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:112:in > > `add_from_results' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/search.rb:183:in > > `each_with_groupby_and_count' > > from /opt/local/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/ > > active_record/attribute_methods.rb:211:in `each_with_index' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/search.rb:182:in `each' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/search.rb:182:in > > `each_with_index' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/search.rb:182:in > > `each_with_groupby_and_count' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:111:in > > `add_from_results' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:47:in > > `populate' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:45:in > > `each' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:45:in > > `populate' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:11:in > > `initialize' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/search_methods.rb:404:in > > `new' > > from /Users/manish/AcceleWeb/srcror/allvineyards.com/vendor/ > > plugins/thinking-sphinx/lib/thinking_sphinx/search_methods.rb:404:in > > `facets' > > from (irb):4>> > > > Any idea? > > > Manish > > > On Sep 5, 4:36 pm, Pat Allan <[email protected]> wrote: > >> If you want to index all the colours, then your example should > >> actually work (provided the association names are correct). > > >> If you want the number of doors for all bedrooms, then try the > >> following: > >> # to force the joins > >> has bedrooms.doors(:id), :as => :door_ids > >> # actual door count > >> has 'COUNT(doors.id)', :as => :door_count, :type => :integer > > >> -- > >> Pat > > >> On 05/09/2009, at 9:03 PM, mrmanishs wrote: > > >>> All, > > >>> How would I index attribute of a a one-to-many-to-many association? > > >>> Example: > > >>> House ==> has many bedrooms > >>> each bedroom has many doors, of a certain color. I don't have > >>> a :through relationship because it's one to many, so house_id is > >>> stored on the bedroom table. > > >>> How would I tell it to index it so that House knows how many colored > >>> doors it has for its bedrooms? I'd like to do something like this > >>> (obviously it doesn't work): > > >>> class House << ActiveRecord::Base > >>> has_many :bedrooms > > >>> define_index do > >>> indexes bedrooms.doors.color, :as => :bedroom_door_color, :facet > >>> => true > >>> end > > >>> end > > >>> Thanks. > > >>> Manish > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
