This post is a bit of a waymarker for people who are having a very specific problem (I tried adding this as a comment to this post but was knocked back by an over-zealous spam filter). If you’re using Thinking Sphinx 2.0.1 and acts_as_taggable_on 2.0.6, are looking to index your named tag collections, and are finding your phrasing to the index building gods is resulting in errors or broken SQL, read on.

If you’re using something other than the base :tags collection, you’ll need the following form:

  acts_as_taggable_on :keywords
  define_index do
    indexes keyword_taggings.tag.name, :as => :keywords
  end

Note that the indexes builder requires that you prepend your collection name to _taggings and also that you dereference the text for the tag through tag.name

You *used* to be able to use the indexes keywords.name, :as => :keywords
form above, but as of 1st Dec 2010 it’s not working (see https://github.com/freelancing-god/thinking-sphinx/issues/#issue/167)

© 2014 ZephyrBlog Suffusion theme by Sayontan Sinha