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

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

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`.
Not Solved
Make sure you take a backup before running any of these queries as you will not be able to change it back
No PM support
My YouTube
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.

Forum Jump:

Users browsing this thread: 1 Guest(s)