Ah, right. Are you using non-integer primary keys? -- Pat
On 13/10/2010, at 12:06 PM, Sebastian wrote: > Hi Pat, thanks for the reply. > > Here's the full trace: > > ** Invoke thinking_sphinx:index (first_time) > ** Invoke thinking_sphinx:app_env (first_time) > ** Execute thinking_sphinx:app_env > ** Invoke environment (first_time) > ** Execute environment > ** Execute thinking_sphinx:index > Generating Configuration to /Users/Sebastian/Sites/tracker/config/ > development.sphinx.conf > rake aborted! > > Cannot automatically map attribute sphinx_internal_id in MainFoodDesc > to an > equivalent Sphinx type (integer, float, boolean, datetime, string as > ordinal). > You could try to explicitly convert the column's value in your > define_index > block: > has "CAST(column AS INT)", :type => :integer, :as => :column > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/attribute.rb:326:in > `translated_type_from_database' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/attribute.rb:162:in `type' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/attribute.rb:127:in > `type_to_config' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/source.rb:98:in `block in > set_source_attributes' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/source.rb:97:in `each' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/source.rb:97:in > `set_source_attributes' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/source.rb:48:in > `to_riddle_for_core' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/index.rb:114:in `block in > to_riddle_for_core' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/index.rb:113:in `each' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/index.rb:113:in `each_with_index' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/index.rb:113:in > `to_riddle_for_core' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/index.rb:83:in `to_riddle' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/active_record.rb:223:in `block in > to_riddle' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/active_record.rb:222:in `collect' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/active_record.rb:222:in > `to_riddle' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/configuration.rb:154:in `block in > build' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/configuration.rb:151:in `each' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/configuration.rb:151:in `build' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/thinking- > sphinx-2.0.0.rc2/lib/thinking_sphinx/tasks.rb:69:in `block (2 levels) > in <top (required)>' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 636:in `call' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 636:in `block in execute' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 631:in `each' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 631:in `execute' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 597:in `block in invoke_with_call_chain' > /Users/Sebastian/.rvm/rubies/ruby-1.9.2-p0/lib/ruby/1.9.1/monitor.rb: > 201:in `mon_synchronize' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 590:in `invoke_with_call_chain' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 583:in `invoke' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 2051:in `invoke_task' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 2029:in `block (2 levels) in top_level' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 2029:in `each' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 2029:in `block in top_level' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 2068:in `standard_exception_handling' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 2023:in `top_level' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 2001:in `block in run' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 2068:in `standard_exception_handling' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/lib/rake.rb: > 1998:in `run' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/gems/rake-0.8.7/bin/rake: > 31:in `<top (required)>' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/bin/rake:19:in `load' > /Users/Sebastian/.rvm/gems/ruby-1.9.2-p0/bin/rake:19:in `<main>' > > Cheers > SB > > > > On Oct 12, 6:23 pm, Pat Allan <[email protected]> wrote: >> Hi Sebastian >> >> Can you give us the full error output - is there a stack trace, or a pointer >> to a line in your development.sphinx.conf? >> >> -- >> Pat >> >> On 13/10/2010, at 9:15 AM, Sebastian <[email protected]> wrote: >> >> >> >>> Using: Rails 3 and Ruby-1.9.2 on OSX Snow Leopard 32 >> >>> I've installed several different versions of Sphinx (0.9.8, 0.9.9) and >>> Thinking Sphinx (2.0.0.rc1, 2.0.0.rc2) and keep getting this error on >>> "rake thinking_sphinx:index" >> >>> I've followed the instructions for installing Sphinx and Thinking >>> Sphinx with Rails3 here (http://freelancing-god.github.com/ts/en/ >>> rails3.html)... >> >>> An here's the model that I'm trying this on: >> >>> class MainFoodDesc < ActiveRecord::Base >>> define_index do >>> indexes maindescription >>> end >>> end >> >>> I'm at my wit's end trying to figure this out. Anyone got any advice? >> >>> -- >>> 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 >>> athttp://groups.google.com/group/thinking-sphinx?hl=en. > > -- > 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. > -- 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.
