Hey Greg, >From an SQL command window, can you see the accounts table when you enter the command: 'show tables in equity_production'? If not, is the db in the list when you call 'show databases'?
basic, I know, but that's what i'd check out first, not knowing the context Al On Feb 8, 3:22 am, Greg Hauptmann <greg.hauptmann.r...@gmail.com> wrote: > Hi, > > Any ideas why (just trying to migrate a Rails app to the prod server) that > "rake db:drop" & "rake db:migrate" etc aren't working due to the below > mentioned mysql error? Obviously this error shouldn't be coming up as it's > not possible to have had the tables in place prior to the "rake db:migrate" > not working. Works fine in development. > > Any ideas? > > [r...@home current]# rake db:drop RAILS_ENV=production --trace > (in /u/apps/equity/releases/20090208104618) > ** Invoke db:drop (first_time) > ** Invoke environment (first_time) > ** Execute environment > rake aborted! > Mysql::Error: Table 'equity_production.accounts' doesn't exist: SHOW FIELDS > FROM `accounts` > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:188:in > `log' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:309:in > `execute' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:440:in > `columns' > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/base.rb:1220:in > `columns' > /u/apps/equity/releases/20090208104618/vendor/plugins/active_scaffold/lib/active_scaffold/config/core.rb:100:in > `initialize_without_calendar_date_select' > /u/apps/equity/releases/20090208104618/vendor/plugins/active_scaffold/lib/bridges/calendar_date_select/lib/as_cds_bridge.rb:5:in > `initialize' > /u/apps/equity/releases/20090208104618/vendor/plugins/active_scaffold/lib/active_scaffold.rb:56:in > `new' > /u/apps/equity/releases/20090208104618/vendor/plugins/active_scaffold/lib/active_scaffold.rb:56:in > `active_scaffold' > /u/apps/equity/releases/20090208104618/app/controllers/account_controller.rb:2 > /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in > `gem_original_require' > /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require' > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:155:in > `require' > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:262:in > `require_or_load' > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:221:in > `depend_on' > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:133:in > `require_dependency' > /usr/local/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/initializer.rb:368:in > `load_application_classes' > /usr/local/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/initializer.rb:367:in > `each' > /usr/local/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/initializer.rb:367:in > `load_application_classes' > /usr/local/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/initializer.rb:365:in > `each' > /usr/local/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/initializer.rb:365:in > `load_application_classes' > /usr/local/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/initializer.rb:185:in > `process' > /usr/local/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/initializer.rb:112:in > `send' > /usr/local/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/initializer.rb:112:in > `run' > /u/apps/equity/releases/20090208104618/config/environment.rb:13 > /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in > `gem_original_require' > /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require' > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in > `require' > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:521:in > `new_constants_in' > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:153:in > `require' > /usr/local/lib/ruby/gems/1.8/gems/rails-2.2.2/lib/tasks/misc.rake:3 > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `call' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `execute' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `each' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `execute' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:578:in > `invoke_with_call_chain' > /usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in > `invoke_with_call_chain' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:588:in > `invoke_prerequisites' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:585:in `each' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:585:in > `invoke_prerequisites' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:577:in > `invoke_with_call_chain' > /usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in > `invoke_with_call_chain' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:564:in `invoke' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2019:in > `invoke_task' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_level' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `each' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_level' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in > `standard_exception_handling' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1991:in `top_level' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1970:in `run' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in > `standard_exception_handling' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1967:in `run' > /usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/bin/rake:31 > /usr/local/bin/rake:19:in `load' > /usr/local/bin/rake:19 > [r...@home current]# > > -- > Greghttp://blog.gregnet.org/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
