Changeset 41963 for trunk/src/wp-admin/includes/upgrade.php

Timestamp:

10/21/2017 01:21:24 PM (9 years ago)

Author:

dd32

Message:

Transients: Clear expired transients from the database in a daily cron task.

Fixes #41699

File:

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

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

@@ -1747 +1747 @@
         global $wp_current_db_version, $wpdb;
 
-        // Always.
-        if ( is_main_network() ) {
-                /*
-                 * Deletes all expired transients. The multi-table delete syntax is used
-                 * to delete the transient record from table a, and the corresponding
-                 * transient_timeout record from table b.
-                 */
-                $time = time();
-                $sql = "DELETE a, b FROM $wpdb->sitemeta a, $wpdb->sitemeta b
-                        WHERE a.meta_key LIKE %s
-                        AND a.meta_key NOT LIKE %s
-                        AND b.meta_key = CONCAT( '_site_transient_timeout_', SUBSTRING( a.meta_key, 17 ) )
-                        AND b.meta_value < %d";
-                $wpdb->query( $wpdb->prepare( $sql, $wpdb->esc_like( '_site_transient_' ) . '%', $wpdb->esc_like ( '_site_transient_timeout_' ) . '%', $time ) );
-        }
+        // Always clear expired transients
+        delete_expired_transients( true );
 
         // 2.8.