Upgrade to 1.4.1 from .8.2 failing

Added by seth larson over 8 years ago

I run into the following issue when trying to migrate the database.

Mysql::Error: Unknown column 'is_default' in 'where clause': SELECT * FROM `repositories` WHERE (`repositories`.project_id = 505 AND (is_default = 1)) LIMIT 1

It appears to me to happen during: ./db/migrate//105_build_projects_tree.rb:3:in `up_without_benchmarks' which just calls Project.rebuild!

Using OSX and WEBrick for local development

About your application's environment
Ruby version              1.8.7 (i686-darwin11.3.0)
RubyGems version          1.8.21
Rack version              1.1.3
Rails version             2.3.14
Active Record version     2.3.14
Active Resource version   2.3.14
Action Mailer version     2.3.14
Active Support version    2.3.14
Application root          /Users/redmine/Sites/redmine-1.4.1
Environment               production
Database adapter          mysql
Database schema version   20090527195008

$rake db:migrate:upgrade_plugin_migrations
DEPRECATION WARNING: Rake tasks in vendor/plugins/gloc-1.1.0/tasks are deprecated. Use lib/tasks instead. (called from /Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/rails-2.3.14/lib/tasks/rails.rb:10)
Cannot find old migration table - assuming nothing needs to be done

$rake db:migrate_plugins RAILS_ENV=production
Please install RDoc 2.4.2+ to generate documentation.
DEPRECATION WARNING: Rake tasks in vendor/plugins/gloc-1.1.0/tasks are deprecated. Use lib/tasks instead. (called from /Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/rails-2.3.14/lib/tasks/rails.rb:10)
Migrating engines...
Migrating acts_as_activity_provider...
Migrating acts_as_attachable...
Migrating acts_as_customizable...
Migrating acts_as_event...
Migrating acts_as_list...
Migrating acts_as_searchable...
Migrating acts_as_tree...
Migrating acts_as_versioned...
Migrating acts_as_watchable...
Migrating awesome_nested_set...
Migrating calendar_import...
Migrating classic_pagination...
Migrating coderay-0.7.6.227...
Migrating gloc-1.1.0...
Migrating gravatar...
Migrating open_id_authentication...
Migrating prepend_engine_views...
Migrating redmine_schedules...
Migrating rfpdf...

$rake db:migrate RAILS_ENV=production --trace
Please install RDoc 2.4.2+ to generate documentation.
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
==  BuildProjectsTree: migrating ==============================================
rake aborted!
An error has occurred, all later migrations canceled:

Mysql::Error: Unknown column 'is_default' in 'where clause': SELECT * FROM `repositories` WHERE (`repositories`.project_id = 505 AND (is_default = 1))  LIMIT 1
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/connection_adapters/mysql_adapter.rb:324:in `execute'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/connection_adapters/mysql_adapter.rb:639:in `select'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/base.rb:665:in `find_by_sql'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/base.rb:1582:in `find_every'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/base.rb:1539:in `find_initial'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/base.rb:617:in `find'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/associations/has_one_association.rb:81:in `find_target'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/associations/association_proxy.rb:236:in `load_target'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/associations/association_proxy.rb:113:in `reload'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/associations.rb:1256:in `repository'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/validations.rb:477:in `send'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/validations.rb:477:in `validates_each'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/validations.rb:476:in `each'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/validations.rb:476:in `validates_each'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:182:in `call'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:182:in `evaluate_method'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:166:in `call'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:90:in `run'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:90:in `each'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:90:in `send'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:90:in `run'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:276:in `run_callbacks'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/validations.rb:1109:in `valid_without_callbacks?'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/callbacks.rb:315:in `valid?'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/validations.rb:1098:in `save_without_dirty!'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/dirty.rb:87:in `save_without_transactions!'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/transactions.rb:200:in `save!'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in `transaction'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/transactions.rb:182:in `transaction'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/transactions.rb:200:in `save!'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/transactions.rb:208:in `rollback_active_record_state!'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/transactions.rb:200:in `save!'
/Users/redmine/Sites/redmine-1.4.1/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:187:in `rebuild!'
/Users/redmine/Sites/redmine-1.4.1/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:184:in `call'
/Users/redmine/Sites/redmine-1.4.1/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:184:in `rebuild!'
/Users/redmine/Sites/redmine-1.4.1/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:184:in `each'
/Users/redmine/Sites/redmine-1.4.1/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:184:in `rebuild!'
/Users/redmine/Sites/redmine-1.4.1/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:194:in `call'
/Users/redmine/Sites/redmine-1.4.1/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:194:in `rebuild!'
/Users/redmine/Sites/redmine-1.4.1/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:191:in `each'
/Users/redmine/Sites/redmine-1.4.1/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:191:in `rebuild!'
./db/migrate//105_build_projects_tree.rb:3:in `up_without_benchmarks'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:282:in `send'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:282:in `migrate'
/Users/redmine/.rvm/rubies/ruby-1.8.7-p358/lib/ruby/1.8/benchmark.rb:293:in `measure'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:282:in `migrate'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:365:in `__send__'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:365:in `migrate'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:491:in `migrate'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:567:in `call'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:567:in `ddl_transaction'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:490:in `migrate'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:477:in `each'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:477:in `migrate'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:401:in `up'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/activerecord-2.3.14/lib/active_record/migration.rb:383:in `migrate'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358/gems/rails-2.3.14/lib/tasks/databases.rake:112
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `execute'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/task.rb:158:in `invoke_with_call_chain'
/Users/redmine/.rvm/rubies/ruby-1.8.7-p358/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/task.rb:151:in `invoke_with_call_chain'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/application.rb:116:in `invoke_task'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `each'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/application.rb:94:in `top_level'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/application.rb:88:in `top_level'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/application.rb:66:in `run'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/application.rb:133:in `standard_exception_handling'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/lib/rake/application.rb:63:in `run'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/gems/rake-0.9.2.2/bin/rake:33
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/bin/rake:19:in `load'
/Users/redmine/.rvm/gems/ruby-1.8.7-p358@global/bin/rake:19
Tasks: TOP => db:migrate

Replies (1)

RE: Upgrade to 1.4.1 from .8.2 failing - Added by Alex A over 8 years ago

I suppose this update is not supported. Try incremental version update.

(1-1/1)