Hi Eli This does indeed sound quite frustrating. Can you share the index definition where you're using the column 'ID'?
-- Pat On 9 Jul 2014, at 7:28 am, Eli Duke <[email protected]> wrote: > I'm new to Thinking Sphinx and I keep bashing my head against a wall and it > keeps hurting... > > Any and all rake tasks (index, configure, generate, etc) return this error: > > ************** > Generating configuration to > /Users/eli/Sites/lita_2013/config/development.sphinx.conf > rake aborted! > ThinkingSphinx::MissingColumnError: column ID does not exist > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/active_record/attribute/type.rb:74:in > `type_from_database' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/active_record/attribute/type.rb:17:in > `type' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/active_record/attribute.rb:4:in > `type' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/configuration/consistent_ids.rb:8:in > `block in reconcile' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/configuration/consistent_ids.rb:7:in > `each' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/configuration/consistent_ids.rb:7:in > `any?' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/configuration/consistent_ids.rb:7:in > `reconcile' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/configuration.rb:87:in > `render' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/configuration.rb:96:in > `block in render_to_file' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/configuration.rb:96:in > `render_to_file' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/rake_interface.rb:13:in > `configure' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/rake_interface.rb:24:in > `index' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/gems/thinking-sphinx-3.1.1/lib/thinking_sphinx/tasks.rb:9:in > `block (2 levels) in <top (required)>' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/bin/ruby_executable_hooks:15:in `eval' > /Users/eli/.rvm/gems/ruby-2.0.0-p247/bin/ruby_executable_hooks:15:in `<main>' > *************** > > And just moments ago I had a full fledged development.sphinx.conf file and I > had started thinking sphinx with "rake ts:start". I decided to index again > just to be sure, stopped ts, ran "rake ts:index", it wiped out everything in > the conf file, and then started giving me that error. And that error is just > about as useless as can be. I have searched and searched and searched on > google looking for ANYTHING that resembles that error, other people having a > similar problem, and there is NOTHING out there on this error. I have checked > all of my indices and there's only one ID that I am trying to index and it > DEFINITELY exists. > > What is going on? Please help me!! > > Thanks! > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
