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

 Replying to [comment:14 earl.fogel]:
 > Thanks, that works but has a side effect of unarchiving any previously
 archived blogs.
 >
 > I found an alternate method that avoids this:
 >
 > mysql> alter table wp_blogs modify column archived char(1);
 > mysql> alter table wp_blogs modify column archived tinyint(2) NOT NULL
 DEFAULT '0';

 I had the same problem and your two commands fixed it for me as well. I
 had to make another small fix first though because I was getting this
 error when trying the above commands:


 {{{
 ERROR 1067 (42000): Invalid default value for 'registered'
 }}}

 I think that my MySQL version doesn't like `datetime` columns like
 `registered` and `last_updated` to default to `0`, so I ran the following
 command to fix that (I guess this won't give any problems?):


 {{{
 alter table wp_blogs modify column registered datetime NOT NULL DEFAULT
 '1970-01-01 00:00:00', modify column last_updated datetime NOT NULL
 DEFAULT '1970-01-01 00:00:00';
 }}}

 After this command the two commands by @earl.fogel worked!

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