Hi Ranjith
What does your define_index block look like for the model?
--
Pat
On 09/05/2012, at 8:54 PM, Ranjith Kumar wrote:
> Hi
>
> I am using sphinx 2.0.4, spree 0.70.4 and Ruby 1.9.3.
>
> when I am doing,
>
> searcher = Spree::Search::ThinkingSphinx.new({:keywords => "rub*"})
> products = searcher.retrieve_products
> Or
> Product.facets
>
> I am getting this error,
>
> NoMethodError: undefined method `SELECT DISTINCT p.id, ov.id FROM
> option_values AS ov LEFT JOIN option_types AS ot ON (ov.option_type_id
> = ot.id) LEFT JOIN option_values_variants AS ovv ON
> (ovv.option_value_id = ov.id) LEFT JOIN variants AS v ON
> (ovv.variant_id = v.id) LEFT JOIN products AS p ON (v.product_id =
> p.id) WHERE (ot.name = 'color') ' for #<Product:0x007ff2750b2e98>
>
> from /Users/admin/.rvm/gems/ruby-1.9.3-p0/gems/activemodel-3.1.4/lib/
> active_model/attribute_methods.rb:385:in method_missing'
> from /Users/admin/.rvm/gems/ruby-1.9.3-p0/gems/activerecord-3.1.4/lib/
> active_record/attribute_methods.rb:60:inmethod_missing'
> from /Users/admin/.rvm/gems/ruby-1.9.3-p0/gems/activesupport-3.1.4/lib/
> active_support/core_ext/object/try.rb:32:in try'
> from /Users/admin/.rvm/gems/ruby-1.9.3-p0/gems/thinking-sphinx-2.0.11/
> lib/thinking_sphinx/facet.rb:110:intranslate'
> from /Users/admin/.rvm/gems/ruby-1.9.3-p0/gems/thinking-sphinx-2.0.11/
> lib/thinking_sphinx/facet.rb:82:in value'
> from /Users/admin/.rvm/gems/ruby-1.9.3-p0/gems/thinking-sphinx-2.0.11/
> lib/thinking_sphinx/facet_search.rb:127:inblock in add_from_results'
>
> Any idea?
>
> by
> Ranjith
>
> --
> 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.
>
--
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.
