Import from 2.2.3 to 2.6 failed
Added by Yann Collette over 8 years ago
Hello,
I use fedora 23 64 bits. I use mariaDB.
I am trying to import the mysql database from a 2.2.3 install to 2.6 ( I use the 2.6 git branch).
I have install all the ruby + gem tools using the documentation.
I initialized the database correctly (set the mysql user name + pwd + drop and create the database).
I the tried several time to import the database:
- I dropped some tables (like user_preferences and comments)
- I dropped a column too (comments_count from the news table)
And now, I am stuck. The import process complains about a missing table: permissions.
How can I import the 2.2.3 database to a new version of redmine ?
Here is the last set of messages I've got:
rake db:migrate RAILS_ENV=production VERSION=2.6
/home/admin/.gem/ruby/gems/htmlentities-4.3.1/lib/htmlentities/mappings/expanded.rb:465: warning: duplicated key at line 466 ignored: "inodot"
IssueMove: migrating ====================================================
rake aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: Table 'bitnami_redmine.permissions' doesn't exist: SHOW FULL FIELDS FROM `permissions`
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/home/admin/.gem/ruby/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/mysql2_adapter.rb:213:in `execute'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:259:in `execute_and_free'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:426:in `columns'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `yield'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `columns'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:244:in `column_defaults'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/base.rb:482:in `initialize'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `new'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `create'
/home/admin/redmine/redmine/db/migrate/002_issue_move.rb:6:in `up'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:370:in `up'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block in migrate'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in `with_connection'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:389:in `migrate'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:528:in `migrate'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:679:in `run'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:578:in `run'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/railties/databases.rake:230:in `block (3 levels) in <top (required)>'
Mysql2::Error: Table 'bitnami_redmine.permissions' doesn't exist
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `query'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `block in execute'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/home/admin/.gem/ruby/gems/activesupport-3.2.22/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:245:in `execute'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/mysql2_adapter.rb:213:in `execute'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:259:in `execute_and_free'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:426:in `columns'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/schema_cache.rb:12:in `block in initialize'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `yield'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:229:in `columns'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/model_schema.rb:244:in `column_defaults'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/base.rb:482:in `initialize'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `new'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/persistence.rb:44:in `create'
/home/admin/redmine/redmine/db/migrate/002_issue_move.rb:6:in `up'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:370:in `up'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block (2 levels) in migrate'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:410:in `block in migrate'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/connection_adapters/abstract/connection_pool.rb:129:in `with_connection'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:389:in `migrate'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:528:in `migrate'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:679:in `run'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/migration.rb:578:in `run'
/home/admin/.gem/ruby/gems/activerecord-3.2.22/lib/active_record/railties/databases.rake:230:in `block (3 levels) in <top (required)>'
Replies (2)
RE: Import from 2.2.3 to 2.6 failed
-
Added by Anonymous over 8 years ago
Hi,
I'am getting the same issue, did you resolve it?
I'm upgrading from 1.x to 2.x
RE: Import from 2.2.3 to 2.6 failed
-
Added by John Pankowicz over 8 years ago
I don't understand how you are trying to upgrade. I am not a Redmine expert, but I upgraded twice and both times were very straightforward. I loaded the new Redmine version, moved over my file folder, my new plugins and themes and edited database.yml to point to the old database. When I ran db:migrate, it made all the database changes automatically. I don't understand why you are making manual changes to your database.