Current time: 04-24-2014, 03:32 PM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[How To?] myBB sql query to change forum ID
03-28-2011, 05:10 PM
Post: #1
Not Solved Exclamation myBB sql query to change forum ID
How can I change forum ID? Like this..

http://www.vbulletin.com/forum/showthrea...48b7447907

For example I want to change /forum-3.html to /forum-1.html
Find all posts by this user
Quote this message in a reply
03-28-2011, 05:38 PM
Post: #2
Not Solved RE: myBB sql query to change forum ID
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`.

[Image: 16mJ9bI]
MyBBsmsAPP | MyStatus | ProProfile
Visit this user's website Find all posts by this user
Quote this message in a reply
03-28-2011, 06:31 PM
Post: #3
Not Solved RE: myBB sql query to change forum ID
Make sure you take a backup before running any of these queries as you will not be able to change it back
Visit this user's website Find all posts by this user
Quote this message in a reply
03-28-2011, 07:33 PM
Post: #4
Not Solved RE: myBB sql query to change forum ID
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.

Google SEO | Gravatar | Hooks | HTMLPurifier | Overview | Patches | PluginLibrary @ GitHub/frostschutz
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication