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
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