[wp-trac] [WordPress Trac] #48600: Multisite rewrite rules are lost after core network upgrade

[WordPress Trac]

#48600: Multisite rewrite rules are lost after core network upgrade
-------------------------------+------------------------------
 Reporter:  litemotiv          |       Owner:  (none)
     Type:  defect (bug)       |      Status:  new
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Upgrade/Install    |     Version:  5.3
 Severity:  major              |  Resolution:
 Keywords:  reporter-feedback  |     Focuses:  multisite
-------------------------------+------------------------------

Comment (by litemotiv):

 Some extra information:

 * I currently have not updated the first multisite to 5.3 yet, so if there
 is anything you would like to know about that installation before i run
 the update please let me know.
 * On the second multisite that showed this issue for the first time today,
 there are no specific errors in the server logs except a few pertaining to
 the collation of Formidable Forms tables, they look like this:


 {{{
 2019/11/13 12:20:01 [error] 17005#17005: *30496906 FastCGI sent in stderr:
 "PHP message: WordPress databasefout Illegal mix of collations
 (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for
 operation '=' bij query SELECT c.*, p.post_name FROM vm2_frmpro_copies c
 LEFT JOIN vm2_211_frm_forms f ON (c.copy_key = f.form_key) LEFT JOIN
 vm2_211_posts p ON (c.copy_key = p.post_name) WHERE blog_id != 211 AND
 ((type = 'form' AND f.form_key is NULL) OR (type = 'display' AND
 p.post_name is NULL)) ORDER BY type DESC gemaakt door
 do_action('wpmu_upgrade_site'), WP_Hook->do_action,
 WP_Hook->apply_filters, FrmAppController::network_upgrade_site,
 rest_do_request, WP_REST_Server->dispatch, FrmAppController::api_install,
 FrmAppController::install, FrmMigrate->upgrade,
 do_action('frm_after_install'), WP_Hook->do_action,
 WP_Hook->apply_filters, FrmProDb::upgrade,
 FrmProCopiesController::install, FrmProCopy::install,
 FrmProCopy::copy_forms, FrmProCopy::get_templates_to_copy,
 FrmDb::check_cache" while reading upstream, client: 127.0.0.1, server:
 <domain>, request: "GET /wp-admin/network/upgrade.php?action=upgrade&n=5
 HTTP/1.0", upstream: "fastcgi://unix:/var/run/php/php7.0-fpm.sock:", host:
 "<host>", referrer: "<referrer>/wp-
 admin/network/upgrade.php?action=upgrade"
 }}}

 The first multisite has no mixed collations for the Formidable tables
 (they are all utf8mb4_unicode_ci there), so it could be unrelated.

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