Corrupted table? Illegal character? An error occurred processing your request…

Hello,

I just spend 1 day to experiment this error : An error occurred processing your request. Try decreasing the “Max Page Size”, or contact support.

I tried everything : increase server config (memory…) ; decrease the size setting in BSR….
The process crashed all time at the same table : wp_options…
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.