Throwing missing field error that isn't in the TS index

Patrick's Avatar


22 Sep, 2011 04:31 PM

The relevant bits of my model

class Lesson < ActiveRecord::Base
  has_many :listings
  has_many :courses, :through => :listings

  has_many :taggings
  has_many :tags, :through => :taggings

  if respond_to? :define_index
    define_index do
      indexes :name
      indexes description
      indexes tags(:name), :as => :tag_names
      indexes, :as => :course_name

      has taggings.tag_id, :as => :tag_ids

I've run a rebuild and restarted my server, but it keeps throwing this error

ThinkingSphinx::SphinxError: index lesson_core: query error: no field 'created_at' found in schema
  1. 1 Posted by Patrick on 22 Sep, 2011 07:58 PM

    Patrick's Avatar

    any idea on how to solve this?

  2. Support Staff 2 Posted by Pat Allan on 22 Sep, 2011 10:08 PM

    Pat Allan's Avatar

    Hi Patrick

    What version of Thinking Sphinx are you using, and if this error is happening when you're searching, what's the search query?


Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac