Forums being imported as Containers

Well that's not good! I'll leave this open as obviously it's a bug, in the meantime containers are stored in the variables table, under the name forum_containers. It's a serialised array, but hopefully you'll be able to work out the format, it'll look something like this:

a:5:{i:0;s:7:"1000040";i:1;s:7:"1000020";i:2;s:7:"1000022";i:3;s:7:"1000023";i:4;s:7:"1000025";}

Deleting parts of this will make the containers -- with the corresponding tid (term id) -- into forums, make a copy of the contents of this field though, in case everything goes wrong and you need to start from the beginning again (just copy and paste it to a text editor).

For example, if we have a container called Designing Your Website, with a tid of 1000020 (accessible via: http://www.webmaster-forums.net/forum/1000020 -- we have a redirect to push browsers to the pretty URL, but you get the idea) and we need to turn that from a container to a forum, we would delete i:1;s:7:"1000020";, then re-number the existing entries like so:

a:4:{i:0;s:7:"1000040";i:1;s:7:"1000022";i:2;s:7:"1000023";i:3;s:7:"1000025";}

Notice that the a:4: bit is saying 'This is an array with four elements.' and i:0 ... i:1 ... i:2 etc. are the array's index, while s:7 is the length of array element. Obviously, text inside the speech marks is the value of the array element.

Hope this helps.

I'm going to assume this is no longer an issue, since it has been a while and no-one else has reported the same issue.

Please re-open this bug if this is still happening though. Thanks! :)

I am having this issue as well.

All vb forums are imported, but only vb child forums show up as actual forums in drupal, any vb forum that is not a child shows up as a container in drupal. I went back into my vb site and moved all forums that were not a child into a "master" forum, making all of the original non-child forums a child of the "master" forum. after attempting to re-import all vb forums now show up as forums in drupal, with the "master" forum showing up as a container, but none of posts are there, all imported forums show zero posts.

oops, forgot to set back to active, sorry.

Thanks for re-opening this. Unfortunately I have yet to see the issue myself, so for now I'm at a bit of a loss to explain/fix it.

When I get some free time, I'll try to reproduce it. In the meantime, all the advice I can offer is to hack the array in the variables table, as shown in #1.

The good news is that I've now seen this bug in the wild. Expect a fix soon. :)

Strangely this bug was showing on an imported forum, then the next time I imported the data from vBulletin it imported containers/forums/sub-forums correctly.

It's possible -- though unlikely -- that something I changed in development fixed the issue. Until this bug is reproducible it's going to be marked as needing more info, however.

The version I'm using is from HEAD, though I'll be making a 6.x-2.x branch soon.

I've just imported a vBulletin forum and had this problem. The forum in Vbulletin has no sub-forums, just 13 "top level" forums. Upon import all the posts have been brought in (can be seen in the admin->content pages) but the forums themselves are empty as they are just "containers"

I also had three import errors, probably a side issue:
- "Table 'vbulletin.cache' doesn't exist query: UPDATE cache SET data ...(lots of stuff)... serialized = 1 WHERE cid = 'theme_registry:' in C:\wamp\www\drupal-6.20\includes\cache.inc on line 109."
- "Table 'vbulletin.cache' doesn't exist query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:' in C:\wamp\www\drupal-6.20\includes\cache.inc on line 26."
- "Table 'vbulletin.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in C:\wamp\www\drupal-6.20\includes\theme.inc on line 471"

not sure why it's trying to read/write to vbulletin.cache and vbulletin.system when it should be updating the drupal database tables "cache" and "system" instead...

Postscript: Using the guidance in the top post, I changed "forum_containers" in the variable table to "a:0:{}" and cleared the cache. Then I revisited the forum and all the posts were there.

Thanks for the module.

not sure why it's trying to read/write to vbulletin.cache and vbulletin.system when it should be updating the drupal database tables "cache" and "system" instead...

Just an aside: this happens because it's switched to the vBulletin database, Drupal always expects the current database to be a Drupal database. It gets away with this, unless there is an error during the import, then a chain reaction of stuff occurs as Drupal tries to output an error.

Just an aside: this happens because it's switched to the vBulletin database, Drupal always expects the current database to be a Drupal database. It gets away with this, unless there is an error during the import, then a chain reaction of stuff occurs as Drupal tries to output an error.

I'm having a similar problem:

An error occurred. /batch?id=19&op=do <br /> <b>Warning</b>: Table &#039;my_vbulletin_db.system&#039; doesn&#039;t exist query: SELECT * FROM system WHERE type = &#039;theme&#039; in <b>/home/*****/public_html/*****/includes/database.mysql.inc</b> on line <b>135</b><br /> <br /> <b>Warning</b>: Unknown column &#039;headers&#039; in &#039;field list&#039; query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = &#039;theme_registry:&#039; in <b>/home/*****/public_html/*****/includes/database.mysql.inc</b> on line <b>135</b><br /> <br /> <b>Warning</b>: Unknown column &#039;cid&#039; in &#039;where clause&#039; query: UPDATE cache SET data = &#039;a:5:{s:11:\&quot;author_pane\&quot;;a:0:{}s:6:\&quot;ctools\&quot;;a:0:{}s:13:\&quot;views_content\&quot;;a:0:{}s:15:\&quot;facebook_status\&quot;;a:0:{}s:6:\&quot;panels\&quot;;a:4:{s:19:\&quot;pane_rounded_shadow\&quot;;O:8:\&quot;stdClass\&quot;:3:{s:8:\&quot;filename\&quot;;s:93:\&quot;sites/all/modules/panels/plugins/style_bases/pane/pane_rounded_shadow/pane_rounded_shadow.inc\&quot;;s:8:\&quot;basename\&quot;;s:23:\&quot;pane_rounded_shadow.inc. . . 

Any ideas where it might be going wrong? It's D6 with the dev version of the module. VB4...

Great module... the posts are there, but it's not quite working because of that error.

Just committed a fix for this, hooray!

It's fixed in commit 229c0c8.