Is this in development? When you re-index TS *should* regenerate the sphinx config file (config/development.sphinx.conf), removing the old column reference.
Can you check the config file manually to see if it still mentions articles.name? Maybe try removing the file manually and then re-indexing. -- James Healy <jimmy-at-deefa-dot-com> Wed, 15 Jul 2009 11:28:24 +1000 mbuckley wrote: > > I'm new to sphinx, so I'm not sure if I'm missing something obvious > here. > > I had accidentally declared an incorrect index in one of my AR models. > I then ran the rake task configure, and index. > > I have since corrected the model index, but when I try to rebuild, > index, I get the following error: > > indexing index 'article_core'... > ERROR: index 'article_core': sql_range_query: Unknown column > 'articles.name' in 'field list' (DSN=mysql://root:*...@localhost:3306/ > retv_development). > total 0 docs, 0 bytes > > It should be looking at articles.title, but I cannot find where it is > caching that old bad value. > > My Article.rb index is as follows: > # Sphinx Indexes > define_index do > # fields > indexes title, :sortable => true > indexes content > indexes country.name, :as => :country_name, :sortable => true > indexes user.business_name, :as => :author, :sortable => true > > # attributes (for ordering) > has user_id, created_at, updated_at > 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 -~----------~----~----~----~------~----~------~--~---
