Changeset 8585

Timestamp:

07/10/2014 08:03:48 PM (10 years ago)

Author:

johnjamesjacoby

Message:

In bp_blogs_record_existing_blogs(), switch to using TRUNCATE rather than DELETE to reset the auto-increment value.

• Move this truncation to after the empty( $blog_ids ) check, to avoid leaving the tables in a misaligned state.
• Also truncate bp_user_blogmeta to ensure accurate data is recorded.

See #5749.

File:

• trunk/src/bp-blogs/bp-blogs-functions.php (modified) (2 diffs)

trunk/src/bp-blogs/bp-blogs-functions.php

@@ -72 +72 @@
     global $bp, $wpdb;
 
-    // Truncate user blogs table and re-record.
-    $wpdb->query( "DELETE FROM {$bp->blogs->table_name} WHERE 1=1" );
-
     // Query for all sites in network
     if ( is_multisite() ) {
@@ -96 +93 @@
         return;
     }
+
+    // Truncate user blogs table and re-record.
+    $wpdb->query( "TRUNCATE {$bp->blogs->table_name}"          );
+    $wpdb->query( "TRUNCATE {$bp->blogs->table_name_blogmeta}" );
 
     // Loop through users of blogs and record them