Changeset 7135

Timestamp:

08/14/2020 05:49:20 PM (3 years ago)

Author:

johnjamesjacoby

Message:

Repair Tools: rebuild forum forum IDs.

This commit adds back the _bbp_forum_id meta data for Forums that was previously deleted inside the bbp_admin_repair_forum_meta() repair function.

Props ikovalyov.

In branches/2.6, for 2.6.6.

See #3310.

File:

• branches/2.6/src/includes/admin/tools/repair.php (modified) (6 diffs)

branches/2.6/src/includes/admin/tools/repair.php

@@ -426 +426 @@
 
     if ( is_wp_error( $bbp_db->query( $sql_delete ) ) ) {
-        return array( 1, sprintf( $statement, $result ) );
+        return array( 1, sprintf( $statement, $result ) );
     }
 
@@ -468 +468 @@
 
     if ( is_wp_error( $bbp_db->query( $sql_delete ) ) ) {
-        return array( 1, sprintf( $statement, $result ) );
+        return array( 1, sprintf( $statement, $result ) );
     }
 
@@ -992 +992 @@
     }
 
-    // Loop through forums
-    foreach ( $forums as $forum_id ) {
+    // Loop through forums
+    foreach ( $forums as $forum_id ) {
         if ( ! bbp_is_forum_category( $forum_id ) ) {
             bbp_update_forum( array( 'forum_id' => $forum_id ) );
@@ -1107 +1107 @@
 
         // If we don't have a postmeta _bbp_status value
-        if( empty( $topic_status ) ) {
+        if ( empty( $topic_status ) ) {
             update_post_meta( $closed_topic, '_bbp_status', 'publish' );
             ++$changed; // Keep a count to display at the end
@@ -1164 +1164 @@
     $tpt = bbp_get_topic_post_type();
     $rpt = bbp_get_reply_post_type();
+    $fmt = bbp_get_forum_post_type();
 
     // Next, give all the topics their parent forum id.
@@ -1172 +1173 @@
             WHERE `topic`.`post_type` = '{$tpt}'
             GROUP BY `topic`.`ID` )" ) ) ) {
+        return array( 2, sprintf( $statement, $result ) );
+    }
+
+    // Next, give all the forums their parent forum id.
+    if ( is_wp_error( $bbp_db->query( "INSERT INTO `{$bbp_db->postmeta}` (`post_id`, `meta_key`, `meta_value`)
+            ( SELECT `forum`.`ID`, '_bbp_forum_id', `forum`.`post_parent`
+            FROM `$bbp_db->posts`
+                AS `forum`
+            WHERE `forum`.`post_type` = '{$fmt}'
+            GROUP BY `forum`.`ID` )" ) ) ) {
         return array( 2, sprintf( $statement, $result ) );
     }