Migration from Mantis failed
Added by Alexey Oryekhov over 15 years ago
Unable to complete migration from Mantis db. After applying patch #3608 I've got the following message:
Please enter settings for your Mantis database adapter [mysql]: host [localhost]: database [bugtracker]: basename username [root]: password []: pass encoding [utf8]: data encoding [UTF-8]: Migrating users.......rake aborted! Mysql::Error: #HY000Incorrect string value: '\xD0' for column 'lastname' at row 1: INSERT INTO `users` (`status`, `created_on`, `last_login_on`, `hashed_password`, `language`, `updated_on`, `admin`, `type`, `firstname`, `lastname`, `mail`, `mail_notification`, `auth_source_id`, `login`) VALUES(1, '2009-08-25 03:22:34', '2009-08-21 21:08:33', '82f2923433d3a47d10af450058e8642c5a4c022d', '', '2009-08-25 03:22:34', 0, NULL, '╨Ъ╤Г╨╖╨╜╨╡╤Ж╨╛╨▓', '╨б╨╡╤А╨│╨╡╨╣ ╨Р╨╜╨░╤В╨╛╨╗╤М╨╡╨', 'mail@gmail.com', 0, NULL, 'Smoker') C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:302:in `execute' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:161:in `insert_sql' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:312:in `insert_sql' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:19:in `insert' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/base.rb:2517:in `create_without_callbacks' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/callbacks.rb:220:in `create_without_timestamps' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/timestamp.rb:29:in `create' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/base.rb:2483:in `create_or_update_without_callbacks' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/callbacks.rb:207:in `create_or_update' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/base.rb:2217:in `save_without_validation!' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/validations.rb:921:in `save_without_dirty!' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/dirty.rb:83:in `save_without_transactions!' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/transactions.rb:110:in `save!' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/transactions.rb:79:in `transaction' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/transactions.rb:98:in `transaction' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/transactions.rb:110:in `save!' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/transactions.rb:118:in `rollback_active_record_state!' C:/rails/redmine-0.8.4/vendor/rails/activerecord/lib/active_record/transactions.rb:110:in `save!' C:/rails/redmine-0.8.4/lib/tasks/migrate_from_mantis.rake:260:in `migrate' C:/rails/redmine-0.8.4/lib/tasks/migrate_from_mantis.rake:251:in `each' C:/rails/redmine-0.8.4/lib/tasks/migrate_from_mantis.rake:251:in `migrate' C:/rails/redmine-0.8.4/lib/tasks/migrate_from_mantis.rake:509 C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' C:/Ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' C:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 C:/Ruby/bin/rake:19:in `load' C:/Ruby/bin/rake:19
Could you help me reslove this issue?
All tables have utf8 codepage with utf8_general_ci collation.
Connection encodning set to utf8 in database.yml.
Mantis db contains Russian characters.
When I try to set data encoding to latin1 or cp1251 migration complete ok but all russian characters becomes unreadable.
Replies (1)
RE: Migration from Mantis failed - Added by Alexey Oryekhov over 15 years ago
Solved! There was an full name in realname field (with Middle instead of only "Name Surname"). I've just removed Middle name and everything was migrated OK then.