Database Collation Issue w/ Wordmove

  • Resolved antes77

    (@antes77)


    9 years, 1 month ago

    Hi!

    I’ve noticed a database collation issue with Wordmove (using mysqldump) where the database tables from WordFence are causing this exception due to non-utf8 collations.

    /usr/local/rvm/gems/ruby-2.3.0/gems/wordmove-2.0.0/lib/wordmove/sql_adapter.rb:44:ingsub!’: invalid byte sequence in UTF-8 (ArgumentError)`

    This is the first major issue I’m having with WordFence.

    Is it safe to manually change the tables’ collations? Will WordFence revert that change? Is there a bug fix in the works for this issue?

    Thank you for your time!
    –John

Viewing 2 replies - 1 through 2 (of 2 total)
  • wfyann

    (@wfyann)

    9 years, 1 month ago

    Hi John (@antes77),

    This problem appears to be related to mysqldump itself and the fact that it uses only UTF-8 as default character set when dumping a database.

    You can find more information about this issue, as well as a solution, here.

    wfyann

    (@wfyann)

    9 years ago

    Hi @antes77,

    Since I haven’t heard back from you I am assuming that the instructions solved your issue so I am marking this topic as resolved.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database Collation Issue w/ Wordmove’ is closed to new replies.

  • 2 replies
  • 2 participants
  • Last reply from: wfyann
  • Last activity: 9 years ago
  • Status: resolved