How to safely delete forums w/o deleting posts that were moved from that forum...

By ktiedt on 13 Jul 2007 at 17:53 UTC

I am working on reorganizing the forum layout on our site and in doing some I need to merge several forums and move some around. My problem is when I did this to our smallest forum (16 posts--its a low traffic forum obviously so a perfect test bed) I moved all the posts into 1 forum, renamed it what it needed to be renamed, moved it to its new Container and then deleted the old (now empty) forums. My problem is when I did this, ALL the posts that were originally from these old forums were deleted at the same time, despite having been moved to a new location (moved w/o creating shadow copy, but with new revision since minor changes were made to the posts as well).

Anyone have a solution to this? Searching turned up a bunch of off topic (for this problem) threads from what I saw.

Thanks!
-Karl

Comments

Interesting Question...

ryanscottdavis commented 13 July 2007 at 18:41

You might want to take a look at your Drupal database. Look at your 'forum' table, do the nid and vid match-up?

In other words...

ktiedt commented 14 July 2007 at 17:32

Drupal falls flat on its face in this area?

-Karl

Bug in Forum.module...

ktiedt commented 14 July 2007 at 23:40

/**
 * Implementation of hook_update().
 */
function forum_update($node) {
  if ($node->revision) {
    db_query("INSERT INTO {forum} (nid, vid, tid) VALUES (%d, %d, %d)", $node->nid, $node->vid, $node->tid);
  }
  else {
    db_query('UPDATE {forum} SET tid = %d WHERE vid = %d', $node->tid, $node->vid);
  }
  db_query('UPDATE {term_node} SET tid = %d WHERE nid = %d', $node->tid, $node->nid);
}

-Karl