[wp-trac] [WordPress Trac] #27832: All sites automatically marked as archived after upgrade

[WordPress Trac]

#27832: All sites automatically marked as archived after upgrade
---------------------------------------+------------------------------
 Reporter:  pavelevap                  |       Owner:
     Type:  defect (bug)               |      Status:  new
 Priority:  normal                     |   Milestone:  Awaiting Review
Component:  Networks and Sites         |     Version:  3.7
 Severity:  normal                     |  Resolution:
 Keywords:  needs-patch needs-testing  |     Focuses:  multisite
---------------------------------------+------------------------------
Changes (by jeremyfelt):

 * version:  3.8.3 => 3.7
 * milestone:  Future Release => Awaiting Review


Comment:

 This really only seems plausible when upgrading from pre-3.7 to post-3.7
 because of the queries in [25448]. And then, it really only seems like
 this could happen if the first ALTER query failed and the second ALTER
 query was successful. At that point, 0 would become 1, 1 would become 2.

 {{{
 ALTER TABLE $wpdb->blogs CHANGE COLUMN archived archived varchar(1) NOT
 NULL default '0'
 ALTER TABLE $wpdb->blogs CHANGE COLUMN archived archived tinyint(2) NOT
 NULL default 0
 }}}

 The auto upgrade from 3.8.2 -> 3.8.3 only contained a few post status
 related changes. Unless the database changes from 3.7 had not yet been
 applied, I'm not sure how the timing would work.

 We can probably close this as something very unlikely to happen, though it
 would be nice to know if a MySQL error was generated at some point during
 the upgrade as well as the version of MySQL used.

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