Hello. I'm not sure if I found a bug. I'm trying to search for price ranges (my price column is a float):
Entry.search(:with => {:price => 5})
When I do that, I get this error:
ThinkingSphinx::SphinxError: index entry_core: unsupported filter type 'intvalues' on float column
Is this a potential bug in FlyingSphinx?
#1 Posted by Pat Allan Support staff on 09 May, 2011 12:32 AM
If price is a float, then you need to use floats in the filters - Sphinx is pretty fussy about that. So try:
#2 Posted by Andy on 10 May, 2011 09:55 AM
Hi Pat. I tried it with floats in the filters too like you mentioned:
Entry.search(:with => {:price => 5.0})
I'm still getting the same error
ThinkingSphinx::SphinxError: index entry_core: unsupported filter type 'intvalues' on float column
Do you think it might be a Heroku server issue instead (i.e. Heroku's Sphinx can't filter floats)?
#3 Posted by Pat Allan Support staff on 10 May, 2011 11:54 AM
I run the servers with Sphinx, not Heroku - the Heroku apps just talk to my servers :)
What's your app name? And the define_index block on your Entry model? Feel free to make this conversation private if you'd prefer.
#4 Posted by Andy on 11 May, 2011 11:05 AM
Oh okay, no problem at all. I think it might be my code so I'll test things and post my findings here. Really appreciate you help and the great plugin, btw!
#5 Posted by Pat Allan Support staff on 11 May, 2011 11:08 AM
No worries. One place to start is does it work locally for you? :)
Pat Allan closed this discussion on 12 May, 2011 02:21 AM.