[wp-trac] [WordPress Trac] #39808: My Sites broken in 4.7.2

[WordPress Trac]

#39808: My Sites broken in 4.7.2
--------------------------------+------------------------------
 Reporter:  earl.fogel          |       Owner:
     Type:  defect (bug)        |      Status:  new
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Networks and Sites  |     Version:  4.7.2
 Severity:  normal              |  Resolution:
 Keywords:                      |     Focuses:  multisite
--------------------------------+------------------------------

Comment (by earl.fogel):

 I added some debugging to capture the SQL queries.  Here's what I get:

 MariaDB [wordpress]> SELECT  blog_id FROM wp_blogs  WHERE blog_id IN ( 2,5
 ) AND archived = 0  AND spam = 0  AND deleted = 0   ORDER BY blog_id ASC;
 Empty set (0.00 sec)

 For some reason the zeros don't match, even though there are zeros in the
 database:

 MariaDB [wordpress]> SELECT  blog_id, archived, spam, deleted FROM
 wp_blogs  WHERE blog_id IN ( 2,5 )  ORDER BY blog_id ASC;
 +---------+----------+------+---------+
 | blog_id | archived | spam | deleted |
 +---------+----------+------+---------+
 |       2 | 0        |    0 |       0 |
 |       5 | 0        |    0 |       0 |
 +---------+----------+------+---------+
 2 rows in set (0.00 sec)

 Here's the table definition:

 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=MyISAM AUTO_INCREMENT=309 DEFAULT CHARSET=utf8;

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