anlek
String not valid UTF-8
Even if add encoding "utf8" still facing same problem: Here is my database.config file sql_connection do adapter "mysql2" host "localhost" username "" password "" database "*****" encoding "utf8" end
mongodb_connection do host "localhost" database "*****" encondig utf8 end
root@Database-server:~# mongify process database.config database_translation.rb
Copying actor (1/1): (200/200) 100% |ooooo| Time: 00:00:00
Copying actor_info (1/1): (200/200) 100% |ooooo| Time: 00:00:00
/var/lib/gems/2.3.0/gems/bson-1.12.5/lib/bson/bson_c.rb:20:in serialize': String not valid UTF-8 (BSON::InvalidStringEncoding) from /var/lib/gems/2.3.0/gems/bson-1.12.5/lib/bson/bson_c.rb:20:in serialize'
from /var/lib/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection_writer.rb:65:in block in batch_write_incremental' from /var/lib/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection_writer.rb:57:in catch'
from /var/lib/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection_writer.rb:57:in batch_write_incremental' from /var/lib/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection.rb:1184:in batch_write'
from /var/lib/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection.rb:411:in insert' from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/database/no_sql_connection.rb:101:in insert_into'
from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/translation/process.rb:36:in block (2 levels) in copy_data' from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/database/sql_connection.rb:86:in block in select_rows'
from /var/lib/gems/2.3.0/gems/activesupport-4.2.10/lib/active_support/core_ext/range/each.rb:7:in each' from /var/lib/gems/2.3.0/gems/activesupport-4.2.10/lib/active_support/core_ext/range/each.rb:7:in each_with_time_with_zone'
from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/database/sql_connection.rb:84:in select_rows' from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/translation/process.rb:29:in block in copy_data'
from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/translation/process.rb:28:in each' from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/translation/process.rb:28:in copy_data'
from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/translation/process.rb:14:in process' from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/cli/command/worker.rb:72:in execute'
from /var/lib/gems/2.3.0/gems/mongify-1.3.2/lib/mongify/cli/application.rb:28:in execute!' from /var/lib/gems/2.3.0/gems/mongify-1.3.2/bin/mongify:17:in <top (required)>'
from /usr/local/bin/mongify:23:in load' from /usr/local/bin/mongify:23:in
Could you explain me? I don't understanding about enconding typo?You want me to give you some specific data?
Here is my database.config file sql_connection do adapter "mysql2" host "localhost" username "" password "" database "*****" encoding "utf-8" end
mongodb_connection do host "localhost" database "*****" encondig utf-8 end
Hi, it's not supported with "utf-8".
mongify check database.config /var/lib/gems/2.3.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:47:in charset_name=': Unsupported charset: '"utf-8"' (Mysql2::Error) from /var/lib/gems/2.3.0/gems/mysql2-0.4.10/lib/mysql2/client.rb:47:in initialize'
I change adpater for mysql and mysql2 and both are compatible only with utf8.
