How to move multiple Topics from one Forum to another?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
tonzodehoo
Registered User
Posts: 118
Joined: Tue Feb 13, 2007 9:21 pm

How to move multiple Topics from one Forum to another?

Post by tonzodehoo »

Is there a way to move a lot of Topics from one forum to another? I want to move a lot of topics about between different forums but the one at a time method that exists is too slow.
User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by HGN »

When in viewforum, select MCP (Moderator Control Panel), tickmark the topics you want to move and with the dropdownlist (combobox) select the desired action "Move". Submit and choose the destination forum.
rsandr
Registered User
Posts: 39
Joined: Fri Nov 27, 2009 9:47 am
Location: East Lancs, UK
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by rsandr »

So in viewforum I click MCP.
I can't see a list of topics?
Am I missing something?
User avatar
ric323
Former Team Member
Posts: 22910
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by ric323 »

What do you see when you enter the MCP?

There have been some recent reports of some MODs blocking some MCP functions.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions
rsandr
Registered User
Posts: 39
Joined: Fri Nov 27, 2009 9:47 am
Location: East Lancs, UK
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by rsandr »

(Tabs)* Main* Moderation queue* Reported posts* User notes* Warnings* Moderator logs* Banning

* Front page Main
Latest 5 posts awaiting approval

There are no posts waiting for approval.


Summat like that above.
Cheers,
Rick
Attachments
Screenshot-4.jpg
Screenshot-4.jpg (45.65 KiB) Viewed 5545 times
User avatar
ric323
Former Team Member
Posts: 22910
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by ric323 »

Do you have "Ajax Chat" installed?
If yes, see here: http://www.phpbb.com/community/viewtopi ... #p12160495
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions
rsandr
Registered User
Posts: 39
Joined: Fri Nov 27, 2009 9:47 am
Location: East Lancs, UK
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by rsandr »

Thanks!
TheDani
Registered User
Posts: 371
Joined: Tue Apr 10, 2012 12:48 pm

Re: How to move multiple Topics from one Forum to another?

Post by TheDani »

What if I want to move all topics from one forum to another forum? Renaming the forum isn't the solution here, because I want to move all topics from a couple of forums to that one collective forum.

Can I simply run a query like this?

Code: Select all

UPDATE phpbb_posts SET forum_id = 38 WHERE forum_id IN (10, 2, 17, 3, 4)
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51899
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by stevemaury »

In the ACP, delete the forum and choose the option to move the posts to the desired forum.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
TheDani
Registered User
Posts: 371
Joined: Tue Apr 10, 2012 12:48 pm

Re: How to move multiple Topics from one Forum to another?

Post by TheDani »

stevemaury wrote:In the ACP, delete the forum and choose the option to move the posts to the desired forum.
No thanks - that would mean I would have to recreate the forum and all the settings + forum permissions and group forum permissions.
User avatar
Lumpy Burgertushie
Registered User
Posts: 68559
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by Lumpy Burgertushie »

TheDani wrote:
stevemaury wrote:In the ACP, delete the forum and choose the option to move the posts to the desired forum.
No thanks - that would mean I would have to recreate the forum and all the settings + forum permissions and group forum permissions.
which would take all of about 2 minutes maybe.


doing it any other way would take much longer.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
TheDani
Registered User
Posts: 371
Joined: Tue Apr 10, 2012 12:48 pm

Re: How to move multiple Topics from one Forum to another?

Post by TheDani »

more like 2 hours. I have about 10 groups and about 15 forums. This means going through permission settings for 150 group forum pairs, and each pair has lots of tabs, each with lots of options. In addition, you have forum permission and group permission... Anyway, what about the SQL I suggested above? I have traced the id's for the forums. Will it break my board, or just move the topics?
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51899
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by stevemaury »

Copy the permissions of the old forum to the new one before deleting the old one.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
TopSpace
Registered User
Posts: 61
Joined: Fri Feb 20, 2015 1:09 pm

Re: How to move multiple Topics from one Forum to another?

Post by TopSpace »

HGN wrote:When in viewforum, select MCP (Moderator Control Panel), tickmark the topics you want to move and with the dropdownlist (combobox) select the desired action "Move". Submit and choose the destination forum.
how to check all topics by one click?
User avatar
Brf
Support Team Member
Support Team Member
Posts: 52305
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: How to move multiple Topics from one Forum to another?

Post by Brf »

If you want to move ALL of the topics from a forum, then go to Manage Forums and delete the old forum. It will give you the option to move all of topics.
Locked

Return to “[3.0.x] Support Forum”