Move all discussions in one node to another

[Douglas Taylor]

Is there a method for doing this? I need to delete a node, but move the threads to another node.

 

[MagnusB]

You have to move the threads manually before doing anything, you can do so by going in to the forum, click on the 0 selected threads, then check off select all, then go to the next page (don't worry, xF remembers what threads you selected) and do the same (though this time it should say x selected threads). Once you done that for all pages in the forum, just use the inline mod to move all the threads at once.

 

[Jake Bunce]

Run this query on your database:

UPDATE xf_thread
SET node_id = 5
WHERE node_id = 2

5 being the destination, 2 being the source.

Then rebuild your forum info:

Admin CP -> Tools -> Rebuild Caches

 

[Douglas Taylor]

Worked like a charm.

Thank you gentlemen!

 

[snoopy5]

Run this query on your database:

UPDATE xf_thread
SET node_id = 5
WHERE node_id = 2

...

Do you mean with this, typing it in phpmyadmin?

If yes, where exactly?

 

[Jake Bunce]

Do you mean with this, typing it in phpmyadmin?

If yes, where exactly?

In the SQL tab in phpmyadmin.

 

[zeropaid]

Is this still the only way? I have several dead nodes and I want to move all the messages to the parent node. Why not have an option in the delete node popup to move all messages to the parent node?

 

[Mike]

It should be done with the batch update threads tool.