[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 lymn):

 Replying to [comment:12 earl.fogel]:
 > For some reason the zeros don't match, even though there are zeros in
 the database:

 It seems that the type for 'archived' was enum('0','1') previously.
 It has been changed to tinyint(2) recently. (Not sure when it was changed)
 Modifying the column definition to tinyint(2) will solve this problem.

 Before modification:
 mysql> describe wp_blogs;
 +--------------+---------------+------+-----+---------------------+----------------+
 | Field        | Type          | Null | Key | Default             | Extra
 |
 +--------------+---------------+------+-----+---------------------+----------------+
 | archived     | enum('0','1') | NO   |     | 0                   |
 |
 | spam         | tinyint(2)    | NO   |     | 0                   |
 |
 | deleted      | tinyint(2)    | NO   |     | 0                   |
 |


 mysql> ALTER TABLE wp_blogs MODIFY COLUMN archived tinyint(2) NOT NULL
 DEFAULT '0';

 After modification:
 mysql> describe wp_blogs;
 +--------------+--------------+------+-----+---------------------+----------------+
 | Field        | Type         | Null | Key | Default             | Extra
 |
 +--------------+--------------+------+-----+---------------------+----------------+
 | archived     | tinyint(2)   | NO   |     | 0                   |
 |
 | spam         | tinyint(2)   | NO   |     | 0                   |
 |
 | deleted      | tinyint(2)   | NO   |     | 0                   |
 |

 After the modification, the value of archived will be set to '1'.
 Update the value of archived to '0' then you will be able to view a list
 of your sites.

 mysql> UPDATE wp_blogs SET archived=0;

 That's all.

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