Log in

View Full Version : How to Change ForumID


GhoHan
02-10-2009, 04:37 PM
Anyone or Coder here please help

How i can change the forumID?
I have try to change but Not working fully.

I Using this code runing on phpmyadmin for change the forumid

2 is current forumid
7 is new forumid


UPDATE `vb_access` SET `forumid` = '7' WHERE `vb_access`.`forumid` =2;
UPDATE `vb_announcement` SET `forumid` = '7' WHERE `vb_announcement`.`forumid` =2;
UPDATE `vb_forum` SET `forumid` = '7' WHERE `vb_forum`.`forumid` =2;
UPDATE `vb_forumpermission` SET `forumid` = '7' WHERE `vb_forumpermission`.`forumid` =2;
UPDATE `vb_forumread` SET `forumid` = '7' WHERE `vb_forumread`.`forumid` =2;
UPDATE `vb_moderator` SET `forumid` = '7' WHERE `vb_moderator`.`forumid` =2;
UPDATE `vb_moderatorlog` SET `forumid` = '7' WHERE `vb_moderatorlog`.`forumid` =2;
UPDATE `vb_podcast` SET `forumid` = '7' WHERE `vb_podcast`.`forumid` =2;
UPDATE `vb_rssfeed` SET `forumid` = '7' WHERE `vb_rssfeed`.`forumid` =2;
UPDATE `vb_subscribeforum` SET `forumid` = '7' WHERE `vb_subscribeforum`.`forumid` =2;
UPDATE `vb_tachyforumpost` SET `forumid` = '7' WHERE `vb_tachyforumpost`.`forumid` =2;
UPDATE `vb_thread` SET `forumid` = '7' WHERE `vb_thread`.`forumid` =2;


Any Idea how to change and working Fully

Marco van Herwaarden
02-11-2009, 08:09 AM
What is the reason you want to do this? You should never have to manually edit any id.

Dismounted
02-11-2009, 08:16 AM
Doing so may break some parts of the system if you are not very, very careful as well.