Changeset 7134 for trunk/src/includes/admin/tools/repair.php

Timestamp:

08/14/2020 05:47:59 PM (5 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 trunk, for 2.7.

See #3310.

File:

• trunk/src/includes/admin/tools/repair.php (modified) (2 diffs)

trunk/src/includes/admin/tools/repair.php

@@ -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 ) );
     }