Hi
I'm brand new to google groups and thinking sphinx so I hope I'm doing
this in the right place.
I'm on Ubuntu 9.10 using Sphinx 0.9.9-release (r2117) and Thinking
Sphinx Gem 1.3.14
When I try to index I continually get an error as follows...
ERROR: index 'project_core': sql_range_query: Incorrect parameter
count in the call to native function 'IFNULL' (DSN=mysql://
dbuser:*...@localhost:3306/production).
I was able to remove the error by taking out :sortable => true
Here's the relevant info...
class Project < ActiveRecord::Base
belongs_to :data, :polymorphic => true
define_index do
# sphinx properties
set_property :morphology => 'none'
set_property :ignore_chars => "'"
set_property :enable_star => true
set_property :min_infix_len => 3
#sphinx fields
indexes [data.title, data.subtitle, data.cover_blurb], :as
=> :title, :sortable => true
indexes [data.author, data.development], :as => :author, :sortable
=> true
has [data.published, data.account], :type => :datetime, :as
=> :published
end
--
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.
