Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [How To?] myBB sql query to change forum ID
#1
Not Solved Exclamation 
How can I change forum ID? Like this..

http://www.vbulletin.com/forum/showthread.php/346987-How-can-I-change-forum-ID?s=860f1e88edd3e4c391799b48b7447907

For example I want to change /forum-3.html to /forum-1.html



Reply
#2
Not Solved
Run these;
PHP Code:
UPDATE `announcementsSET `fid` = '1' WHERE `fid` =5;
UPDATE `delayedmoderationSET `fid` = '1' WHERE `fid` =5;
UPDATE `forumpermissionsSET `fid` = '1' WHERE `fid` =5;
UPDATE `forumsSET `fid` = '1' WHERE `fid` =5;
UPDATE `forumsreadSET `fid` = '1' WHERE `fid` =5;
UPDATE `forumsubscriptionsSET `fid` = '1' WHERE `fid` =5;
UPDATE `moderatorlogSET `fid` = '1' WHERE `fid` =5;
UPDATE `moderatorsSET `fid` = '1' WHERE `fid` =5;
UPDATE `postsSET `fid` = '1' WHERE `fid` =5;
UPDATE `reportedpostsSET `fid` = '1' WHERE `fid` =5;
UPDATE `threadsSET `fid` = '1' WHERE `fid` =5

Replace `5` to the forum ID you want to `Change`.
Reply
#3
Not Solved
Make sure you take a backup before running any of these queries as you will not be able to change it back
Reply
#4
Not Solved
This user has been denied support. This user has been denied support.
Probably be easier & safer to just move all the threads to the forum you want them to be in (and/or create a new empty forum with the ID you want and then move them). There are too many things that can go wrong otherwise, since forum IDs are references in so many places (caches too).

Even better solution would be to never attempt to change any ids at all.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)