Dear FireBoard users,
In order to further develope the need of Joomla for a robust forum, FireBoard component has been moved to its own new home and new name. You can find more information regarding the Kunena, the successor of FireBoard, at kunena.com. The current forum here will stay for some time more for referencing needs. You can find the FireBoard files under joomlacode.org and other files
Upgrading to Kunena is highly recommended!

Kunena! - To Speak!

A revolution is coming... Kunena - Swahili for: To Speak! THE Next generation of native Joomla based Forum ultra component. Forget what you know about Joomla based forums...
Amazingly Simple Lean and Clean Easier Customization
Kunena is about to redefine the world of Joomla! with the most simplistic ultra component out there. For ultimate performance based on state of the art development techniques, Kunena! is about to bring you... With an integrated plugin system that will allow you to extend Kunena beyond your wildest imaginations...
SOLVED: How to merge forum categories?
TOPIC: SOLVED: How to merge forum categories?
#16601
SOLVED: How to merge forum categories? 10 Years, 3 Months ago  
I migrated from phpBB, where I knew how to delete a (slow) forum category, merging all its threads into another forum category.

This happens frequently with new Boards: The new website is built with lots of interesting categories, but the traffic isn\'t high enough to keep them all busy, so the owner decides to prune the number of topic areas, but doesn\'t want to lose any threads.

I want to consolidate the existing threads into fewer, broader, categories.

How do I do this with FireBoard?

Thanks.
JLW
#16601
SOLVED: How to merge forum categories? 10 Years, 3 Months ago  
I migrated from phpBB, where I knew how to delete a (slow) forum category, merging all its threads into another forum category.

This happens frequently with new Boards: The new website is built with lots of interesting categories, but the traffic isn\'t high enough to keep them all busy, so the owner decides to prune the number of topic areas, but doesn\'t want to lose any threads.

I want to consolidate the existing threads into fewer, broader, categories.

How do I do this with FireBoard?

Thanks.
JLW
#16647
Re:How to merge forum categories? 10 Years, 3 Months ago  
This is not possible at this time with Fireboard.
#16665
Re:How to merge forum categories? 10 Years, 3 Months ago  
Oh. :(


I am not at all averse to changing field contents of SQL tables via phpMyAdmin.

Is there a single forum-ID-field in a table-of-all-posts; such that, if the value of that field is changed for all the posts that had been in forum-A, it would effectively change the forum of the posts to forum-B, such that (if I didn\'t miss or mess any of them) all the threads would still be intact but in forum-B and without messing up the threads previously in forum-B?

---------

OK. I just looked at the tables. Question:

What would happen if I gave an SQL command to change the catID field to 8 in all of the rows in content_fb_messages that have catID=9 ?

Would that merge all the forum#9 threads into forum#8? Any problems envisaged???
JLW
#17846
Re:How to merge forum categories? 10 Years, 3 Months ago  
Well... nobody\'s said it should work, and nobody\'s said it won\'t. So I guess it\'s time to backup the database, do it, and see if it breaks everything. I\'ll report the results here.
JLW
#21560
Re:How to merge forum categories? 10 Years, 2 Months ago  
I tried it, and it appears to work.

In phpMyAdmin, I first backed up `content_fb_messages`.

Then ran a query like:

UPDATE `accordio_mambo1`.`content_fb_messages` SET `catid` = \'8\' WHERE `content_fb_messages`.`catid` =\'9\'

Then I unpublished the now empty forum category.

Then did it again for another pair of forum categories.

So far, it appears to have worked.

Result:
I merged two pairs of categories, turning a 7 category forum into a 5 category forum, eliminating the two categories that were least recently posted to.

If anybody tries something similar and discovers any obscure problems, please let me know.

So far, so good.
JLW
#49865
Re:SOLVED: How to merge forum categories? 9 Years, 6 Months ago  
this would be a very useful feature to have :)
#50119
Re:SOLVED: How to merge forum categories? 9 Years, 6 Months ago  
It\'s been over six months, and no problems have appeared. So all you need to do is change that one field.
JLW
#59236
Re:SOLVED: How to merge forum categories? 9 Years, 1 Month ago  
hi JLW,

thanks for the post, that is what I was looking!

Lets try!

Thanks!

-- EDITED --

That works! thank you again! B)
Page: 1