Hi Manish On 06/09/2009, at 5:32 PM, mrmanishs wrote:
> Pat... I am always impressed by your response time. Ah, it varies. Saying 'What version?' isn't too hard though. And I'm having a quiet weekend :) > The installation date I have is August 16th, 2009. Just checked the TS logs, the fix was made on the 23rd - try updating, and let me know if that doesn't fix the problem. Cheers -- Pat > 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 -~----------~----~----~----~------~----~------~--~---
