I'm really at a loss on this one. It's an outside shot, but can you try stopping Sphinx, deleting the index files, and then running rake ts:rebuild?
Otherwise, can you try replicating the problem in a test app? Or is it possible for me to get access to this app and data offlist, to investigate locally? Cheers -- Pat On 16/12/2010, at 12:57 PM, Matthew Hinton wrote: > 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]. > > > > 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. > > > > > > > > > > > > > > > -- > > > 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. > > > > -- > > 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. > > > > > > > > > > -- > > 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. > > -- > 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. > > > > > -- > 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. -- 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.
