No. The table columns/types are: foodcode (primary key, int) startdate (date) enddate (date) maindescription (varchar 200) abbrdescription (varchar 60)
So the primary key is an integer, but it isn't 1-->N autoincrementing ... It's unique food codes set by the USDA. Could that be the issue? On Oct 12, 9:09 pm, Pat Allan <[email protected]> wrote: > 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 > > 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.
