Hi Vin I've tried again, and I can't reproduce this bug using the latest version of Thinking Sphinx and Rails 2.1.1. If I force Rails to throw the same error, it turns out it's not an instance of Mysql::Error, but ActiveRecord::StatementInvalid - but I'm catching both of those in Thinking Sphinx now (have been since I last tried to fix this, and we got past db:create). So I'm a bit confused as to why it's still happening...
If you're still having the problem, let me know. Cheers -- Pat On 12/10/2008, at 9:53 PM, Vin wrote: > > Pat, > Will be pleased to send the trace. > > I add a comment in the trace ====> My commnent where my code is called > to the derived activerecord and the line points to index definition. > Here it is::: > > [EMAIL PROTECTED]:~/dev/rails/myapp$ rake db:migrate --trace > (in /home/vin/dev/rails/myapp) > ** Invoke db:migrate (first_time) > ** Invoke environment (first_time) > ** Execute environment > rake aborted! > Mysql::Error: Table 'db_dev.people' doesn't exist: SHOW FIELDS FROM > `people` > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/ > connection_adapters/abstract_adapter.rb:147:in `log' > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/ > connection_adapters/mysql_adapter.rb:302:in `execute' > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/ > connection_adapters/mysql_adapter.rb:433:in `columns' > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/ > base.rb:1149:in `columns' > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/ > base.rb:1157:in `columns_hash' > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.1/lib/active_record/ > base.rb:1207:in `descends_from_active_record?' > /home/vinb/dev/rails/mypromos/vendor/plugins/thinking-sphinx/lib/ > thinking_sphinx/index.rb:272:in `initialize_from_builder' > /home/vinb/dev/rails/mypromos/vendor/plugins/thinking-sphinx/lib/ > thinking_sphinx/index.rb:39:in `initialize' > /home/vinb/dev/rails/mypromos/vendor/plugins/thinking-sphinx/lib/ > thinking_sphinx/active_record.rb:68:in `new' > /home/vinb/dev/rails/mypromos/vendor/plugins/thinking-sphinx/lib/ > thinking_sphinx/active_record.rb:68:in `define_index' > /home/vinb/dev/rails/mypromos/app/models/all_person.rb:32 (====> My > commnent - this is the derived activerecord from base class person as > I mentioned earlier in my exapmle of class A and B) > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:216:in `load_without_new_constant_marking' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:216:in `load_file' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:355:in `new_constants_in' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:215:in `load_file' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:96:in `require_or_load' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:261:in `load_missing_constant' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:468:in `const_missing' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:480:in `const_missing' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > inflector.rb:285:in `constantize' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > inflector.rb:284:in `each' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > inflector.rb:284:in `constantize' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > core_ext/string/inflections.rb:143:in `constantize' > /home/vinb/dev/rails/mypromos/vendor/plugins/thinking-sphinx/lib/ > thinking_sphinx/configuration.rb:174:in `load_models' > /home/vinb/dev/rails/mypromos/vendor/plugins/thinking-sphinx/lib/ > thinking_sphinx/configuration.rb:165:in `each' > /home/vinb/dev/rails/mypromos/vendor/plugins/thinking-sphinx/lib/ > thinking_sphinx/configuration.rb:165:in `load_models' > /home/vinb/dev/rails/mypromos/vendor/plugins/thinking-sphinx/init.rb: > 5:in `evaluate_init_rb' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > callbacks.rb:177:in `call' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > callbacks.rb:177:in `evaluate_method' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > callbacks.rb:161:in `call' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > callbacks.rb:90:in `run' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > callbacks.rb:90:in `each' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > callbacks.rb:90:in `send' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > callbacks.rb:90:in `run' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > callbacks.rb:272:in `run_callbacks' > /usr/lib/ruby/gems/1.8/gems/rails-2.1.1/lib/initializer.rb:493:in > `send' > /usr/lib/ruby/gems/1.8/gems/rails-2.1.1/lib/initializer.rb:493:in > `prepare_dispatcher' > /usr/lib/ruby/gems/1.8/gems/rails-2.1.1/lib/initializer.rb:155:in > `process' > /usr/lib/ruby/gems/1.8/gems/rails-2.1.1/lib/initializer.rb:97:in > `send' > /usr/lib/ruby/gems/1.8/gems/rails-2.1.1/lib/initializer.rb:97:in `run' > /home/vinb/dev/rails/mypromos/config/environment.rb:13 > /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in > `gem_original_require' > /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:27:in > `require' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:510:in `require' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:355:in `new_constants_in' > /usr/lib/ruby/gems/1.8/gems/activesupport-2.1.1/lib/active_support/ > dependencies.rb:510:in `require' > /usr/lib/ruby/gems/1.8/gems/rails-2.1.1/lib/tasks/misc.rake:3 > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:621:in `call' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:621:in `execute' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:616:in `each' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:616:in `execute' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:582:in > `invoke_with_call_chain' > /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:575:in > `invoke_with_call_chain' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:592:in > `invoke_prerequisites' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:589:in `each' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:589:in > `invoke_prerequisites' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:581:in > `invoke_with_call_chain' > /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:575:in > `invoke_with_call_chain' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:568:in `invoke' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:2031:in > `invoke_task' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:2009:in `top_level' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:2009:in `each' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:2009:in `top_level' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:2048:in > `standard_exception_handling' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:2003:in `top_level' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:1982:in `run' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:2048:in > `standard_exception_handling' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/lib/rake.rb:1979:in `run' > /usr/lib/ruby/gems/1.8/gems/rake-0.8.2/bin/rake:31 > /usr/bin/rake:19:in `load' > /usr/bin/rake:19 > > > Hope this helps > -Vin > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
