By shankarchem on

HI,
I migrated a forum from other drupal installation. I appended the following tables using SQL Scripts

forum
node
node access
node revisions
term date
term hierarchy
term node
node comment statistics

However the container appear as forums in drupal. How to change the forums to containers. What parameters (table and Field) in the database define if it is a forum or container?

⋅ Categories: Drupal 5.x

Comments

dnewkerk’s picture

dnewkerk commented

**Edit: I just searched my database and found: forum_containers within the variable table. That may be what you need.
Has a value for me of: a:6:{i:0;i:1;i:1;i:9;i:2;i:16;i:3;i:19;i:4;i:24;i:5;i:31;}

I have 6 containers on this forum... and the taxonomy term IDs of the containers in the forum are: 1, 9, 16, 31, 19, 24
Looks like each are represented, preceded by the other numbers in order from 0 - 5.

Doesn't make much sense to me why it would be stored this way, but... :P

-- David
absolutecross.com

As If’s picture

As If commented

You can explode that array by running a print_r on it. Here's a page that automates that process:
http://asifproductions.com/unserialize.html

By mimicking the format you can add your own lines to the array. Each line will look something like this...
i:15;s:4:"1451";
...where "1451" is the forum you want to change into a container.

ALSO... If you need to move forum topics around, you simply have to do two things;

UPDATE forum SET tid = [NEWTID] WHERE tid = [OLDTID];
and
UPDATE term_node SET tid = [NEWTID] WHERE tid = [OLDTID];

-------------------------------------------
Interactive Worlds and Immersive Obsessions
http://www.asifproductions.com