Looks like a bug to me, but maybe as a work-around, use single columns for fields that you want to be sortable?
ie: indexes data.title, :as => :title, :sortable => true indexes [data.subtitle, data.cover_blurb], :as => :extended_title Feel free to log an issue on GitHub and I'll try to get the SQL syntax for merged columns being sortable. http://github.com/freelancing-god/thinking-sphinx/issues Cheers -- Pat On 14/01/2010, at 5:40 AM, dwickwire wrote: > 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. > >
-- 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.
