Searching with only the mt filter seems to be working correctly as well. On Wed, Dec 15, 2010 at 5:01 PM, Pat Allan <[email protected]> wrote:
> Yup, your original query on price had a range. What happens if you just > search with filters on mt, not price or pt? > > -- > Pat > > On 16/12/2010, at 9:23 AM, Matthew Hinton wrote: > > > If I just run the search on price I get the correct results. I may have > forgotten to mention that I am sending a range to price all the time like > 0..5 or 0..10 or 0..20. > > > > On Wed, Dec 15, 2010 at 3:48 PM, Pat Allan <[email protected]> > wrote: > > Let's see if there's a simpler way of getting the wrong results... can > you try some searches just filtering by price, nothing else? Try single > price values, arrays of price values, and ranges of price values... are the > search results correct? > > > > -- > > Pat > > > > On 16/12/2010, at 8:09 AM, Matthew Hinton wrote: > > > > > Pat, I updated to TS 1.4.0 and I am still experiencing the issue. I > have updated the gist showing the sphinx config. > > > > > > https://gist.github.com/742017 > > > > > > > > > On Wed, Dec 15, 2010 at 2:56 PM, Pat Allan <[email protected]> > wrote: > > > Hi Matthew > > > > > > Can you just confirm the generated Sphinx configuration is correct, and > update that gist? Also: it wouldn't hurt to upgrade to TS 1.4.0 (be explicit > with the version number - TS 2.0.x is for Rails 3 only). > > > > > > -- > > > Pat > > > > > > On 16/12/2010, at 7:49 AM, Matthew Hinton wrote: > > > > > > > Thanks for the feedback but this did not resolve my issue. I still > get a record returned if either of the following match when what I want is > if both match. > > > > has products.media_type(:id), :as => :mt > > > > has products.price, :as => :price, :type => :multi > > > > > > > > I am running Rails 2.3.5 and thinkingspinx 1.3.16. > > > > > > > > > > > > On Wed, Dec 15, 2010 at 2:33 PM, Pat Allan <[email protected]> > wrote: > > > > Okay, so this could be our problem - for some reason, it's saying > price is a single integer, when it's actually an array of integers. The SQL > is correct, but the attribute definition is not. > > > > > > > > Can you try changing the attribute definition to: > > > > has products.price, :as => :price, :type => :multi > > > > > > > > Then run rake ts:rebuild and see if that helps matters? > > > > > > > > That said, it *should* work without this... which version of Thinking > Sphinx are you using? And which version of Rails? > > > > > > > > Cheers > > > > > > > > -- > > > > Pat > > > > > > > > > > > > > > > > -- > > > > Matthew Hinton > > > > [email protected] > > > > http://www.myverbaloutlet.net > > > > > > > > -- > > > > 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]<thinking-sphinx%[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]<thinking-sphinx%[email protected]> > . > > > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > > > > > > > > > > > > > > -- > > > Matthew Hinton > > > [email protected] > > > http://www.myverbaloutlet.net > > > > > > -- > > > 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]<thinking-sphinx%[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]<thinking-sphinx%[email protected]> > . > > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > > > > > > > > > -- > > Matthew Hinton > > [email protected] > > http://www.myverbaloutlet.net > > > > -- > > 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]<thinking-sphinx%[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]<thinking-sphinx%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > > -- Matthew Hinton [email protected] http://www.myverbaloutlet.net -- 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.
