Changeset 32457 for branches/4.2/src/wp-admin/includes/upgrade.php

Timestamp:

05/08/2015 12:27:13 PM (10 years ago)

Author:

pento

Message:

Upgrades: If a table has already been converted to utf8mb4, there's no need to try and convert it again.

Props gabrielperezs for the initial patch.

Merge of [32456] to the 4.2 branch.

Fixes #32310.

File:

• branches/4.2/src/wp-admin/includes/upgrade.php (modified) (1 diff)

branches/4.2/src/wp-admin/includes/upgrade.php

@@ -1760 +1760 @@
     }
 
+    $table_details = $wpdb->get_row( "SHOW TABLE STATUS LIKE '$table'" );
+    if ( ! $table_details ) {
+        return false;
+    }
+
+    list( $table_charset ) = explode( '_', $table_details->Collation );
+    $table_charset = strtolower( $table_charset );
+    if ( 'utf8mb4' === $table_charset ) {
+        return true;
+    }
+
     return $wpdb->query( "ALTER TABLE $table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci" );
 }