Corrupted table? Illegal character? Migration failed A problem occurred when…

  • onico0

    (@onico0)


    9 years, 8 months ago

    Hello,

    I just spend 1 day to experiment this error : 

    Migration failed

A problem occurred when attempting to process the following table (#113) wp_options

Status: 500 Internal Server Error

Response:

    For me, it looks like a corrupted table but all infos in my server / phpmyadmin etc. stay the DB is OK, and I can dump any table of my DB.

    Finally, I have check all my wp_options fields one by one to find the culprit.

    I found the « corrupted field » ! Or the field which contained the illegal character.

    I read it, but I cannot find which kind of character can make the problem so, I give you the MySQL export for further investigation : https://www.mister-wp.com/wp-content/uploads/2016/09/corrupted-field-sql.zip

    If you import this field in wp_options you will not be able anymore to use search and replace export with :

    – Better Search and Replace
    – WP Migrate DB
    – Search and Replace for WordPress Databases Script by interconnectit

    So no more solution to migrate a WP website.

    It’s not stable to need one day (or more) when you need to migrate a website. It could be nice to find a way to detect quickly the wrong characters.

    My server run mysql throught MariaDB.

    Thanks.

    • This topic was modified 9 years, 8 months ago by onico0.
Viewing 2 replies - 1 through 2 (of 2 total)
  • jvpdigital

    (@jvpdigital)

    9 years, 1 month ago

    Nicolas, I’m running into this same issue after some server updates. Finding odd symptoms & results, like if I disable all plugins except wp migrate pro, I can export the db. Seems unlikely in this case that it’s corrupted data. Did you ever figure out what the issue was for you?

    aztequin

    (@aztequin)

    8 years, 9 months ago

    I have the same problem, i just uninstall di woocommerce plugin and that’s all

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

The topic ‘Corrupted table? Illegal character? Migration failed A problem occurred when…’ is closed to new replies.