Pat... Thanks :)
Let me know whenever you get to it, and I'll try to hit it again... Manish On Sep 7, 11:34 am, Pat Allan <[email protected]> wrote: > Yup, I'm sure it's an issue, I just need to find some time to work on > it. Maybe during this week, but we'll see - work and life are both a > bit flat out at the moment. > > -- > Pat > > On 07/09/2009, at 5:15 PM, mrmanishs wrote: > > > > > I found a work-around for now, just going to do one-to-one. I think I > > have a way that it may work... > > > But, this looks like it still as an issue. > > > On Sep 6, 1:12 pm, mrmanishs <[email protected]> wrote: > >> Hey Pat, > > >> I reinstalled using the following command: script/plugin install > >> git://github.com/freelancing-god/thinking-sphinx.git --force > > >> However, I am still getting the same error. > > >> The error comes up whenever I type: House.facets. > > >> Manish > > >> On Sep 6, 11:48 am, Pat Allan <[email protected]> wrote: > > >>> 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 -~----------~----~----~----~------~----~------~--~---
