Changeset 34978

Timestamp:

10/09/2015 02:06:15 AM (9 years ago)

Author:

SergeyBiryukov

Message:

After [34529], if a compatible termmeta table is found on database upgrade, convert it to utf8mb4 collation.

Props dboulet.
Fixes #34224.

Location:

trunk/src

Files:

• wp-admin/includes/upgrade.php (modified) (1 diff)
• wp-includes/version.php (modified) (1 diff)

trunk/src/wp-admin/includes/upgrade.php

@@ -2631 +2631 @@
 
     // Upgrade versions prior to 4.4.
-    if ( $wp_current_db_version < 34370 ) {
-        // If compatible termmeta table is found, use it, but enforce a proper index.
+    if ( $wp_current_db_version < 34978 ) {
+        // If compatible termmeta table is found, use it, but enforce a proper index and update collation.
         if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->termmeta}'" ) && $wpdb->get_results( "SHOW INDEX FROM {$wpdb->termmeta} WHERE Column_name = 'meta_key'" ) ) {
             $wpdb->query( "ALTER TABLE $wpdb->termmeta DROP INDEX meta_key, ADD INDEX meta_key(meta_key(191))" );
+            maybe_convert_table_to_utf8mb4( $wpdb->termmeta );
         }
     }

trunk/src/wp-includes/version.php

@@ -12 +12 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 34903;
+$wp_db_version = 34978;
 
 /**