Thanks for your reply Pat! Everything seems to be working as expected now.
There was one small caveat; setting group_concat_max_len via sphinx.yml didn't work, I needed to add a set_property call to my define_index, like so: define_index do set_property :group_concat_max_len => 65536 end Thanks again for your assistance! - Will On Mar 15, 7:53 pm, Pat Allan <[email protected]> wrote: > Hi Wil > > This is probably related to a limit in MySQL (assuming that's your > database - if it's Postgres, I'd have no idea) - group_concat_max_len > is a setting MySQL has, and I think the default is either 512 or 1024 > characters. There is a setting in Thinking Sphinx though for this, > that you can use to extend the limit during indexing, via config/ > sphinx.yml: > > development: > group_concat_max_len: 16384 > test: > group_concat_max_len: 16384 > production: > group_concat_max_len: 16384 > > Hopefully that'll fix the problem. > > Cheers > > -- > Pat > > On 12/03/2009, at 8:10 AM, wb wrote: > > > > > I'm having a really baffling issue with the latest stable thinking > > sphinx + sphinx. > > > Given the stripped down models below, a call to Parent.search(query) > > seems to always return the expected results if query exists anywhere > > in parent.fragment.value. Similarly for Child.search(query) / > > child.fragment.value and Fragment.search / value. > > > The problem I'm having is that Parent.search(query) seems to only > > return results on children.fragment.value if there is an occurrence of > > query in the first few hundred bytes. Any later occurrences of query > > seem be ignored. > > > Fragment.value is a text field, and I'm using mysql 5 (FYI). > > > Any help would be very much appreciated! > > > - Will > > > class Parent < ActiveRecord::Base > > > has_one :fragment, :as => :owner > > has_many :children > > > define_index do > > indexes fragment.value, :as => :value > > indexes children.fragment.value, :as => :child_values > > end > > > end > > > class Child < ActiveRecord::Base > > > has_one :fragment, :as => :owner > > belongs_to :parent > > > define_index do > > indexes fragment.value, :as => :value > > end > > > end > > > class Fragment < ActiveRecord::Base > > > belongs_to :owner, :polymorphic => true > > > define_index do > > indexes value > > end > > 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 -~----------~----~----~----~------~----~------~--~---
