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]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
