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
-~----------~----~----~----~------~----~------~--~---

Reply via email to