• Registered: 2004-11-19
  • Posts: 186

Topic: How To Move All Topics From One Forum To Another ?

Hi All,

I know we can move topics from one forum to another using the admin panel, but this is a very slow process if you've got 200+ topics that you want to move.

On my test forum I thought I'd try a test and went into the DB and ran a sql command to change the forum_ID in each topic:

UPDATE `topics` SET forum_id = '10' WHERE forum_id = '17'

Well, as you can imagine it didn't work quite right.  The topics were moved, but the pagination wasn't calculated correctly.

So, what's the easiest way to move all 200+ topics from one forum to another?

Thanks!

Rob Ludlow 
www.Nifty-Stuff.com - Repository of all Stuff Nifty!
www.reviewum.com - Professor Ratings + Teacher Reviews
  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: How To Move All Topics From One Forum To Another ?

Correct me if I'm wrong, but wouldn't making a new post in the forum result in update_forum() being run and fixing this issue?
It's certainly worth a try I'd say.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: How To Move All Topics From One Forum To Another ?

Well, as you can imagine it didn't work quite right.  The topics were moved, but the pagination wasn't calculated correctly.

That should work perfectly fine, other than update_forum not being run: what exactly was the issue?
Edit: Aha, I assume you mean the viewforum.php pagination. As Elbekko said, getting update_forum to run should fix the issue smile

  • Registered: 2004-11-19
  • Posts: 186

Re: How To Move All Topics From One Forum To Another ?

Wow.... that was almost too easy!

Created a new topic in both forums and deleted... all fixed!

Thanks guys!!!

Rob Ludlow 
www.Nifty-Stuff.com - Repository of all Stuff Nifty!
www.reviewum.com - Professor Ratings + Teacher Reviews
  • Registered: 2007-03-25
  • Posts: 960

Re: How To Move All Topics From One Forum To Another ?

use merge forums Plugin ... that is better and safer ... get it in the punbb download page

MyFootballCafe.com  is Now Online!
  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: How To Move All Topics From One Forum To Another ?

How is that safer?

  • From: France
  • Registered: 2004-11-06
  • Posts: 695

Re: How To Move All Topics From One Forum To Another ?

There's a Merge Forums plugin that worked fine for me.

Jeu de rôle en ligne sur table virtuelle ⁂ Shadowrun France ⁂ Chez Blacky

Jérémie's Website

  • Registered: 2007-03-25
  • Posts: 960

Re: How To Move All Topics From One Forum To Another ?

i mean you dont lose or miss a topic and is done in few seconds

MyFootballCafe.com  is Now Online!
  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: How To Move All Topics From One Forum To Another ?

It's the same query most likely.

  • Registered: 2004-11-19
  • Posts: 186

Re: How To Move All Topics From One Forum To Another ?

On my test forum it took 2 seconds once I got the sql lined up.  I'll put my forum into maintenance mode, run the command, post two topics in each of the forums which were touched, delete the posts, then remove maintenance mode.

If this process sounds good then I'd prefer this hands-on method over a mod / plugin... especially for something I don't expect to have to do again or a very long time.

Thoughts?

Rob Ludlow 
www.Nifty-Stuff.com - Repository of all Stuff Nifty!
www.reviewum.com - Professor Ratings + Teacher Reviews
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: How To Move All Topics From One Forum To Another ?

I still think the plugin, if done properly, is the way to go, since it removes the chance of human error (and is less work) smile

  • Registered: 2007-03-25
  • Posts: 960

Re: How To Move All Topics From One Forum To Another ?

yea me too

MyFootballCafe.com  is Now Online!
  • Registered: 2004-11-19
  • Posts: 186

Re: How To Move All Topics From One Forum To Another ?

I've been looking for this merge forum plugin and can't find it.  Can someone point the way?

Rob Ludlow 
www.Nifty-Stuff.com - Repository of all Stuff Nifty!
www.reviewum.com - Professor Ratings + Teacher Reviews
  • Registered: 2004-11-19
  • Posts: 186

Re: How To Move All Topics From One Forum To Another ?

Hmmm... still can't find that merge forums plugin.   I'll do it manually unless someone can point it out in the next 5 hours or so.

Rob Ludlow 
www.Nifty-Stuff.com - Repository of all Stuff Nifty!
www.reviewum.com - Professor Ratings + Teacher Reviews

15 Reply by MattF

  • MattF
  • Senior Member
  • Offline
  • From: South Yorkshire, England
  • Registered: 2007-03-15
  • Posts: 1,956

Re: How To Move All Topics From One Forum To Another ?

reviewum.com wrote:

Hmmm... still can't find that merge forums plugin.   I'll do it manually unless someone can point it out in the next 5 hours or so.

Plugins are listed on the main download page, not punres. big_smile big_smile

http://punbb.org/downloads.php

MattF's Website

  • Registered: 2004-11-19
  • Posts: 186

Re: How To Move All Topics From One Forum To Another ?

Doh!   Always the last place you look.   I'm so use to finding stuff on punres that I forget to look here.

I ended up just doing it manually... seemed to work like a charm.  Thanks anyway Matt for pointing that page out.  Lots of goodies there which I hadn't looked over in a year or more.

Rob Ludlow 
www.Nifty-Stuff.com - Repository of all Stuff Nifty!
www.reviewum.com - Professor Ratings + Teacher Reviews