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

[WordPress Trac]

#39325: All sites automatically marked as archived after upgrade
--------------------------------+-----------------------------
 Reporter:  rscs                |      Owner:
     Type:  defect (bug)        |     Status:  new
 Priority:  normal              |  Milestone:  Awaiting Review
Component:  Networks and Sites  |    Version:  4.7
 Severity:  normal              |   Keywords:
  Focuses:  multisite           |
--------------------------------+-----------------------------
 I upgraded my Multisite Network from v4.6.1 to v4.7 today. After the
 upgrade, all of the sites in my network were marked as archived. I
 manually went into the db and changed the archive column from "1" to "0"
 to fix the problem. It looks like the "archived" column in the "wp_blogs"
 table was changed from an enum to a tinyint based on reviewing by DB
 backups.

 I'm not sure why I am just seeing this schema change now when it took
 effect over 3 years ago in r25448.

 This is a legacy setup originally installed from v3.4.2.

 Related: #27832 and #38856

 Database before upgrade:
 {{{
 CREATE TABLE `wp_blogs` (
   `blog_id` bigint(20) NOT NULL AUTO_INCREMENT,
   `site_id` bigint(20) NOT NULL DEFAULT '0',
   `domain` varchar(200) NOT NULL DEFAULT '',
   `path` varchar(100) NOT NULL DEFAULT '',
   `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `public` tinyint(2) NOT NULL DEFAULT '1',
   `archived` enum('0','1') NOT NULL DEFAULT '0',
   `mature` tinyint(2) NOT NULL DEFAULT '0',
   `spam` tinyint(2) NOT NULL DEFAULT '0',
   `deleted` tinyint(2) NOT NULL DEFAULT '0',
   `lang_id` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`blog_id`),
   KEY `domain` (`domain`(50),`path`(5)),
   KEY `lang_id` (`lang_id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 }}}

 Database after upgrade:
 {{{
 CREATE TABLE `wp_blogs` (
   `blog_id` bigint(20) NOT NULL AUTO_INCREMENT,
   `site_id` bigint(20) NOT NULL DEFAULT '0',
   `domain` varchar(200) NOT NULL DEFAULT '',
   `path` varchar(100) NOT NULL DEFAULT '',
   `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `public` tinyint(2) NOT NULL DEFAULT '1',
   `archived` tinyint(2) NOT NULL DEFAULT '0',
   `mature` tinyint(2) NOT NULL DEFAULT '0',
   `spam` tinyint(2) NOT NULL DEFAULT '0',
   `deleted` tinyint(2) NOT NULL DEFAULT '0',
   `lang_id` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`blog_id`),
   KEY `domain` (`domain`(50),`path`(5)),
   KEY `lang_id` (`lang_id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 }}}

--
Ticket URL: <https://core.trac.wordpress.org/ticket/39325>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform