[wp-trac] [WordPress Trac] #32212: Multisite Sites Cannot Create Database tables in 4.2.1 fresh clean install

[WordPress Trac]

#32212: Multisite Sites Cannot Create Database tables in 4.2.1 fresh clean install
--------------------------------+------------------------
 Reporter:  reidbusi            |       Owner:
     Type:  defect (bug)        |      Status:  new
 Priority:  normal              |   Milestone:  4.2.2
Component:  Networks and Sites  |     Version:  4.2.1
 Severity:  normal              |  Resolution:
 Keywords:                      |     Focuses:  multisite
--------------------------------+------------------------

Comment (by jeremyfelt):

 Thank you for all that information @reidbusi! Percona is a popular drop-in
 replacement for MySQL. I don't believe there are any known issues.

 Some general thoughts for the ticket.

 We set the utf8_general_ci charset in `init_charset()` before attempting
 to bump a `utf8/utf8_general_ci` connection to
 `utf8mb4/utf8mb4_unicode_ci`. It seems like this is the only place where
 this change can be short circuited.

 {{{
 if ( ( $this->use_mysqli && ! ( $this->dbh instanceof mysqli ) )
   || ( empty( $this->dbh ) || ! ( $this->dbh instanceof mysqli ) ) ) {
         return;
 }
 }}}

 I've attempted to replicate with fresh installations of multisite in MySQL
 5.5.40 and PHP 5.5.9 and have had no trouble creating new sites.

 * Started with the database set to a default charset/collation of
 `latin1/latin1_swedish_ci`. No issues with the auto generated wp-
 config.php file and `utf8mb4` charset.
 * Modified my.cnf to use `utf8/utf8_general_ci` by default, no issues with
 auto generated wp-config.php and `utf8mb4`.
 * Changed the `character-set-client-handshake` setting between true/false
 with no change. Not that I really understand what that does. :)

 If I set something in `DB_COLLATE` that is not `utf8_` based, like
 `latin1_swedish_ci`, then I do get similar errors. But that is not what is
 described in the ticket, this should be reproducible with `DB_COLLATE` as
 `''`.

 I'm going to attempt a swap to Percona in my VM to try and mirror
 configurations better, but I can't see that being the issue.

 I'm guessing @pento will have good feedback here.

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