Project

General

Profile

redmine升级问题

Added by lion cn about 12 years ago

我从redmine 1.2.3升级到 2.0.3中遇到了一个问题,

问题是在执行 rake db:migrate RAILS_ENV=production 时报的,错误信息如下:

[root@localhost redmine]# rake db:migrate RAILS_ENV=production
rake aborted!
Mysql::Error: Table 'redmine.users' doesn't exist: SHOW CREATE TABLE `users`

Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)

当我执行 rake db:migrate RAILS_ENV=production --trace 时报如下错误

[root@localhost redmine]# rake db:migrate RAILS_ENV=production --trace
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    Mysql::Error: Table 'redmine.users' doesn't exist: SHOW CREATE TABLE `users`
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:243:in `query'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:243:in `execute'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `log'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:243:in `execute'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/mysql_adapter.rb:314:in `execute_and_free'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:526:in `pk_and_sequence_for'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:539:in `primary_key'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/schema_cache.rb:22:in `initialize'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/attribute_methods/primary_key.rb:76:in `call'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/attribute_methods/primary_key.rb:76:in `default'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/attribute_methods/primary_key.rb:76:in `[]'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/attribute_methods/primary_key.rb:76:in `get_primary_key'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/attribute_methods/primary_key.rb:60:in `reset_primary_key'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/attribute_methods/primary_key.rb:49:in `primary_key'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/attribute_methods/primary_key.rb:62:in `reset_primary_key'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/attribute_methods/primary_key.rb:49:in `primary_key'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/attribute_assignment.rb:13:in `attributes_protected_by_default'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/mass_assignment_security.rb:216:in `protected_attributes_configs'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/mass_assignment_security.rb:188:in `call'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/mass_assignment_security.rb:188:in `default'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/mass_assignment_security.rb:188:in `[]'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/mass_assignment_security.rb:188:in `protected_attributes'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/mass_assignment_security.rb:118:in `attr_protected'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/mass_assignment_security.rb:117:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/mass_assignment_security.rb:117:in `attr_protected'
    /www/redmine/app/models/user.rb:65
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:236:in `load_dependency'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:359:in `require_or_load'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:502:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:514:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /www/redmine/app/models/project.rb:30
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:236:in `load_dependency'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:359:in `require_or_load'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:502:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:514:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /www/redmine/app/models/attachment.rb:37
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:236:in `load_dependency'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:359:in `require_or_load'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:502:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:514:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:514:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:514:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:514:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /www/redmine/lib/plugins/acts_as_attachable/lib/acts_as_attachable.rb:33:in `acts_as_attachable'
    /www/redmine/app/models/message.rb:23
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:236:in `load_dependency'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:251:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:359:in `require_or_load'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:502:in `load_missing_constant'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:192:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/dependencies.rb:190:in `const_missing'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/inflector/methods.rb:218:in `constantize'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/inflector/methods.rb:217:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/inflector/methods.rb:217:in `constantize'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/core_ext/string/inflections.rb:54:in `constantize'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/observing.rb:210:in `observed_class'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/observing.rb:203:in `observed_classes'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/observing.rb:223:in `observed_classes'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/observer.rb:96:in `observed_classes'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/observing.rb:219:in `initialize'
    /usr/local/lib/ruby/1.8/singleton.rb:94:in `new'
    /usr/local/lib/ruby/1.8/singleton.rb:94:in `instance'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/observing.rb:86:in `instantiate_observer'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/observing.rb:59:in `instantiate_observers'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/observing.rb:59:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activemodel-3.2.3/lib/active_model/observing.rb:59:in `instantiate_observers'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/railtie.rb:111
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:26:in `on_load'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:25:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:25:in `on_load'
    /usr/local/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/railtie.rb:110
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:34:in `call'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:34:in `execute_hook'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:43:in `run_load_hooks'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:42:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/lazy_load_hooks.rb:42:in `run_load_hooks'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/application/finisher.rb:59
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/initializable.rb:30:in `instance_exec'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/initializable.rb:30:in `run'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/initializable.rb:55:in `run_initializers'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/initializable.rb:54:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/initializable.rb:54:in `run_initializers'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/application.rb:136:in `initialize!'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/railtie/configurable.rb:30:in `send'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/railtie/configurable.rb:30:in `method_missing'
    /www/redmine/config/environment.rb:14
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/application.rb:103:in `require'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/application.rb:103:in `require_environment!'
    /usr/local/lib/ruby/gems/1.8/gems/railties-3.2.3/lib/rails/application.rb:292:in `initialize_tasks'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `execute'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:158: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.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:176:in `invoke_prerequisites'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:174:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:174:in `invoke_prerequisites'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:157: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.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:116:in `invoke_task'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `each'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `top_level'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `run'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run'
    /usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/bin/rake:33
    /usr/local/bin/rake:19:in `load'
    /usr/local/bin/rake:19
    Tasks: TOP => db:migrate => environment

目前我自己无法解决,请求管理员或相关同行帮助


Replies (1)

RE: redmine升级问题 - Added by Jan Niggemann (redmine.org team member) about 12 years ago

Perhaps you would receive more feedback if you wrote in English, translate.google.com helps a bit...

Translation:
Error while upgrading from 1.2.3 to 2.0.3, rake db: migrate RAILS_ENV = "production" throws error message above.

    (1-1/1)