Changeset 57926 for trunk/src/wp-admin/includes/class-wp-site-health.php

Timestamp:

04/04/2024 03:11:37 PM (12 months ago)

Author:

johnbillion

Message:

Database: Remove back-compat for database servers that don't support utf8mb4.

Since WordPress 6.5, the minimum supported version of MySQL and MariaDB is 5.5.5. This means all supported database servers now support the utf8mb4 character set and therefore the conditional logic for this is no longer necessary.

Props l1nuxjedi, craigfrancis, OllieJones, johnbillion

Fixes #60096

File:

• trunk/src/wp-admin/includes/class-wp-site-health.php (modified) (2 diffs)

trunk/src/wp-admin/includes/class-wp-site-health.php

@@ -1285 +1285 @@
 
     /**
-     * Tests if the database server is capable of using utf8mb4.
-     *
-     * @since 5.2.0
-     *
-     * @return array The test results.
-     */
-    public function get_test_utf8mb4_support() {
-        if ( ! $this->mysql_server_version ) {
-            $this->prepare_sql_data();
-        }
-
-        $result = array(
-            'label'       => __( 'UTF8MB4 is supported' ),
-            'status'      => 'good',
-            'badge'       => array(
-                'label' => __( 'Performance' ),
-                'color' => 'blue',
-            ),
-            'description' => sprintf(
-                '<p>%s</p>',
-                __( 'UTF8MB4 is the character set WordPress prefers for database storage because it safely supports the widest set of characters and encodings, including Emoji, enabling better support for non-English languages.' )
-            ),
-            'actions'     => '',
-            'test'        => 'utf8mb4_support',
-        );
-
-        if ( ! $this->is_mariadb ) {
-            if ( version_compare( $this->mysql_server_version, '5.5.3', '<' ) ) {
-                $result['status'] = 'recommended';
-
-                $result['label'] = __( 'utf8mb4 requires a MySQL update' );
-
-                $result['description'] .= sprintf(
-                    '<p>%s</p>',
-                    sprintf(
-                        /* translators: %s: Version number. */
-                        __( 'WordPress&#8217; utf8mb4 support requires MySQL version %s or greater. Please contact your server administrator.' ),
-                        '5.5.3'
-                    )
-                );
-            } else {
-                $result['description'] .= sprintf(
-                    '<p>%s</p>',
-                    __( 'Your MySQL version supports utf8mb4.' )
-                );
-            }
-        } else { // MariaDB introduced utf8mb4 support in 5.5.0.
-            if ( version_compare( $this->mysql_server_version, '5.5.0', '<' ) ) {
-                $result['status'] = 'recommended';
-
-                $result['label'] = __( 'utf8mb4 requires a MariaDB update' );
-
-                $result['description'] .= sprintf(
-                    '<p>%s</p>',
-                    sprintf(
-                        /* translators: %s: Version number. */
-                        __( 'WordPress&#8217; utf8mb4 support requires MariaDB version %s or greater. Please contact your server administrator.' ),
-                        '5.5.0'
-                    )
-                );
-            } else {
-                $result['description'] .= sprintf(
-                    '<p>%s</p>',
-                    __( 'Your MariaDB version supports utf8mb4.' )
-                );
-            }
-        }
-
-        // phpcs:ignore WordPress.DB.RestrictedFunctions.mysql_mysqli_get_client_info
-        $mysql_client_version = mysqli_get_client_info();
-
-        /*
-         * libmysql has supported utf8mb4 since 5.5.3, same as the MySQL server.
-         * mysqlnd has supported utf8mb4 since 5.0.9.
-         */
-        if ( str_contains( $mysql_client_version, 'mysqlnd' ) ) {
-            $mysql_client_version = preg_replace( '/^\D+([\d.]+).*/', '$1', $mysql_client_version );
-            if ( version_compare( $mysql_client_version, '5.0.9', '<' ) ) {
-                $result['status'] = 'recommended';
-
-                $result['label'] = __( 'utf8mb4 requires a newer client library' );
-
-                $result['description'] .= sprintf(
-                    '<p>%s</p>',
-                    sprintf(
-                        /* translators: 1: Name of the library, 2: Number of version. */
-                        __( 'WordPress&#8217; utf8mb4 support requires MySQL client library (%1$s) version %2$s or newer. Please contact your server administrator.' ),
-                        'mysqlnd',
-                        '5.0.9'
-                    )
-                );
-            }
-        } else {
-            if ( version_compare( $mysql_client_version, '5.5.3', '<' ) ) {
-                $result['status'] = 'recommended';
-
-                $result['label'] = __( 'utf8mb4 requires a newer client library' );
-
-                $result['description'] .= sprintf(
-                    '<p>%s</p>',
-                    sprintf(
-                        /* translators: 1: Name of the library, 2: Number of version. */
-                        __( 'WordPress&#8217; utf8mb4 support requires MySQL client library (%1$s) version %2$s or newer. Please contact your server administrator.' ),
-                        'libmysql',
-                        '5.5.3'
-                    )
-                );
-            }
-        }
-
-        return $result;
-    }
-
-    /**
      * Tests if the site can communicate with WordPress.org.
      *
@@ -2740 +2626 @@
                     'test'  => 'sql_server',
                 ),
-                'utf8mb4_support'              => array(
-                    'label' => __( 'MySQL utf8mb4 support' ),
-                    'test'  => 'utf8mb4_support',
-                ),
                 'ssl_support'                  => array(
                     'label' => __( 'Secure communication' ),