[wp-trac] [WordPress Trac] #39811: Bug maybe_unserialize() broke mysql data.

[WordPress Trac]

#39811: Bug maybe_unserialize() broke mysql data.
--------------------------+------------------------------
 Reporter:  ivijanstefan  |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Database      |     Version:  4.7.2
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by ivijanstefan):

 Replying to [comment:1 SergeyBiryukov]:
 > Hi @ivijanstefan, welcome to WordPress Trac! Thanks for the ticket.
 >
 > A similar issue was previously reported in #21109. There are two typical
 reasons that might cause this:
 > * The `DB_CHARSET` value in `wp-config.php` doesn't match the actual DB
 charset (e.g. `latin1` vs. `utf8_general_ci`).
 > * The serialized data has been tampered with, e.g. by using
 search/replace incorrectly and breaking string lengths. The
 [https://interconnectit.com/products/search-and-replace-for-wordpress-
 databases/ Database Search and Replace] script might be helpful in that
 case to perform search/replace correctly.

 Good point, I not use that plugin in this case. Generaly, database is in
 `utf8_general_ci` format and that can be issue.

 But question:

 Why you not made some "switching" function or something niversal what
 cover this issue and fix problems? When I ore some other developer want to
 made fast fix we work directly in database without plugins. Also if we
 want to move WP from server to other server, we just do export,
 find/replace path and import new in database. Also when you do some
 massive migrations from server to server where is 100, 200, 1000
 installations, we don't want to install plugins per websites We need to
 export SQL and import on new server.

 Just chatting about this issue and I see a lot problems regarding this.

 Thanks!

--
Ticket URL: <https://core.trac.wordpress.org/ticket/39811#comment:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform