When I comment out the third of those indexes and just search two of them, "Stanley" and "Kubrick" both work fine even though they're not returning any results for one of the classes.
On Sep 16, 10:15 am, Benjamin Lim <[email protected]> wrote: > Yup, the same goes for "Stanley," it yields zero results for one of > the classes. > > define_index do > indexes film.title, :as => :title > indexes film.alternate_title, :as => :alternate_title > indexes country > indexes excerpt > indexes synopsis > indexes film.language, :as => :language > indexes special_features > indexes director > indexes films.primary_title, :as => :films_in_set > indexes film.cast_members.name, :as => :cast_members > end > > # This is the entry that is not yielding results for "Stanley" and > "Kubrick" > define_index do > indexes :title > indexes :body > indexes :excerpt > indexes films.title, :as => :film_title > indexes explore_entry_films.description, :as => :film_description > end > > define_index do > indexes :title > indexes :body > indexes :quote > indexes :source > indexes :video_caption > indexes :body2 > indexes author.first_name, :as => :author_first_name > indexes author.last_name, :as => :author_last_name > end > > On Sep 16, 8:40 am, Pat Allan <[email protected]> wrote: > > > Really strange indeed. > > > What does the define_index block look like for these models? What happens > > if you comment out all attributes in each model, and try the facet searches > > then? > > > Maybe you're right about the class that has 0 results causing the > > problem... Is that the case for "Stanley" as well? > > > -- > > Pat > > > On 15/09/2010, at 1:05 AM, Benjamin Lim wrote: > > > > This is really strange. > > > > If I do a search for "Kubrick Spartacus" I get 5 results and when I > > > try to get the facets for that search I get the error. > > > > If I do a search for "Spartacus" I get those 5 results plus some other > > > ones but the facets for that search work fine. > > > > Actually (I just realized this in the middle of typing this)... I have > > > three classes that I'm searching and in "Kubrick Spartacus" only two > > > of those classes are represented in the search results. In "Spartacus" > > > there are results from all three classes. Could one of the classes > > > yielding zero results be causing this? > > > > On Sep 14, 1:41 am, Pat Allan <[email protected]> wrote: > > >> Hi Benjamin > > > >> I guess from here, it's a matter of deduction... when you do a normal > > >> search for 'kubrick' (since that's probably slightly more rare?), how > > >> many search results do you get? (Don't forget results are paginated) > > > >> And then, what can you add to the query to get fewer results where the > > >> facet query still fails? Can you get that down to just a single record? > > >> Or maybe there's a few records with this data glitch... > > > >> -- > > >> Pat > > > >> On 14/09/2010, at 1:06 AM, Benjamin Lim wrote: > > > >>> The failing queries are "stanley" and "kubrick" so it's possible that > > >>> it's breaking because of one of the results being returned since I > > >>> suspect both queries return similar results. There was another one > > >>> that consistently failed as well but I can't recall what it was. > > > >>> The ones that work all consistently work. > > > >>> On Sep 10, 10:48 pm, Pat Allan <[email protected]> wrote: > > >>>> Hi Benjamin > > > >>>> Does it happen reliably for some queries? If so, can you give me an > > >>>> example of a failing query? > > > >>>> Cheers > > > >>>> -- > > >>>> Pat > > > >>>> On 11/09/2010, at 5:50 AM, Benjamin Lim <[email protected]> wrote: > > > >>>>> I'm currently getting the error below when trying to use facets. > > > >>>>> I haven't specified any facets in my indexes, I'm just trying to get a > > >>>>> breakdown of the results from each class that I'm getting back for my > > >>>>> search. The strange thing is that it works for some queries and > > >>>>> returns this error for others. At first I thought it might be specific > > >>>>> to one of the classes being searched but I did a search for "" and > > >>>>> returned everything that's in the index and that worked fine... > > > >>>>> The error message: > > > >>>>> NoMethodError (undefined method `value' for nil:NilClass): > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/facet_search.rb:114:in `add_from_results' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/search.rb:221:in `each_with_groupby_and_count' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/search.rb:220:in `each' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/search.rb:220:in `each_with_index' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/search.rb:220:in `each_with_groupby_and_count' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/facet_search.rb:113:in `add_from_results' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/facet_search.rb:49:in `populate' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/facet_search.rb:47:in `each' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/facet_search.rb:47:in `populate' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/facet_search.rb:13:in `initialize' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/search_methods.rb:422:in `new' > > >>>>> /usr/local/lib/ruby/gems/1.8/gems/thinking-sphinx-1.3.18/lib/ > > >>>>> thinking_sphinx/search_methods.rb:422:in `facets' > > >>>>> app/controllers/search_controller.rb:15:in `results' > > > >>>>> -- > > >>>>> 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 > > >>>>> athttp://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 > > >>> athttp://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 > > > athttp://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.
