Changeset 11305 for trunk/wp-includes/post.php

Timestamp:

05/12/2009 05:10:05 PM (15 years ago)

Author:

ryan

Message:

Clear cache after deleting meta. Props Denis-de-Bernardy. fixes #9009

File:

• trunk/wp-includes/post.php (modified) (1 diff)

trunk/wp-includes/post.php

@@ -685 +685 @@
 
     global $wpdb;
-    if ( $wpdb->query($wpdb->prepare("DELETE FROM $wpdb->postmeta WHERE meta_key = %s", $post_meta_key)) ) {
-        /** @todo Get post_ids and delete cache */
-        // wp_cache_delete($post_id, 'post_meta');
+    $post_ids = $wpdb->get_col($wpdb->prepare("SELECT DISTINCT post_id FROM $wpdb->postmeta WHERE meta_key = %s", $post_meta_key));
+    if ( $post_ids ) {
+        $wpdb->query($wpdb->prepare("DELETE FROM $wpdb->postmeta WHERE meta_key = %s", $post_meta_key));
+        foreach ( $post_ids as $post_id )
+            wp_cache_delete($post_id, 'post_meta');
         return true;
     }