> Is that the entire query? If so, I'm surprised it works at all - the @geodist
> attribute only exists when you supply a lat/lng pair, which you don't seem to
> be doing…
Right, that makes sense-- but supplying a lat/lng doesn't help... on
my local machine:
> Post.facets({:with => { :@geodist => 1000000 }, :geo => [0.43501347763859316,
> -1.4072239209450015] }).for.count
Sphinx Query (2.6ms)
Sphinx Found 0 results
Sphinx Sphinx Daemon returned warning: index post_core: unsupported
filter type 'intvalues' on float column
=> 0
... On my staging slice (with an identical db):
Post.facets({:with => { :@geodist => 1000000 }, :geo =>
[0.43501347763859316, -1.4072239209450015] }).for.count
Sphinx Query (5.5ms)
Sphinx Found 389 results
Post Load (0.2ms) SELECT `posts`.* FROM `posts` WHERE `posts`.`id`
IN (27, 30, 41, 42, 43, 89, 95, 96, 98, 99, 109, 110, 111, 112, 113,
114, 116, 117, 118, 119) ORDER BY created_at DESC
=> 20
I updated my gist to include my models define_index block...
https://gist.github.com/02a03a3ee7fba1877e02
Any ideas why the behavior is so different between these two boxes?
-patrick
--
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.
