Project

General

Profile

Migration from Mantis failed

Added by Alexey Oryekhov over 14 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 14 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.

    (1-1/1)