Hmm, right. What does your MainFoodDesc model code look like? -- Pat
On 13/10/2010, at 12:33 PM, Sebastian wrote: > 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. > -- 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.
