non-existent tables and non-showing threads

Is there anything in the forum table? It sounds like this wasn't populated.

Additionally, when running the test and when migrating the data, there are two db tables that come up as errors even though they are not part of the vB database. It is looking for vb_system and vb_watchdog.

These are Drupal tables, the conversion script is generating errors so it goes to put them in the watchdog. As the current database is the Drupal database it can't find the tables... Rather confusing. :)

Ideally I'd like to know what the errors were preceding Drupal being unable to find system and watchdog. If there's just too much information, save the HTML page and upload it here (you'll have to change the extension to .txt though).

I also am seeing the same issue with Drupal 5.7 and

version = "5.x-1.0"
project = "vbtodrupal"
datestamp = "1205348416"

on http://xxx.net/admin/build/vbtodrupal/test

I see:

Warning: Table 'xxx_vBforum.vBsystem' doesn't exist query: SELECT * FROM vBsystem WHERE type = 'theme' in /home/xxx/public_html/includes/database.mysql.inc on line 172

Warning: Table 'xxx_drupal.vBwatchdog' doesn't exist query: INSERT INTO vBwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Table &amp;#039;xxx_vBforum.vBsystem&amp;#039; doesn&amp;#039;t exist\nquery: SELECT * FROM vBsystem WHERE type = &amp;#039;theme&amp;#039;</em> in <em>/home/xxx/public_html/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://xxx.net/admin/build/vbtodrupal/test', 'http://xxx.net/admin/build/vbtodrupal', '79.179.127.139', 1208176919) in /home/xxx/public_html/includes/database.mysql.inc on line 172

Now xxx_drupal is of course my Drupal DB and xxx_vBforum is my VB DB. Note that it's looking for xxx_vBforum.vBsystem which is not right, because system is a Drupal table. vB is my VB table prefix.

Also it's looking for xxx_drupal.vBwatchdog which is not right, because while it's got the Drupal DB, it's prefixing the table with the VB prefix!

To be complete, the above is what I see above the breadcrumbs "Home » Administer » Site building" Below the "Test" tab I see a warning :

user warning: Table 'xxx_vBforum.vBsystem' doesn't exist query: SELECT * FROM vBsystem WHERE type = 'theme' in /home/xxx/public_html/includes/database.mysql.inc on line 172.

and then I see:

Testing for vBulletin tables

    * Table vBthread: Yes
    * Table vBpost: Yes
    * Table vBuser: Yes
    * Table vBpm: Yes

Tables check passed!
Testing for PHP safe mode

Safe mode check passed!
Testing whether pictures are enabled

User picture check passed!
Testing Forum module has been enabled correctly

Forum check passed!

If the checks have succeeded you may continue with the migration

When I run the migration, however, no data is imported. :(

Any ideas?

Now xxx_drupal is of course my Drupal DB and xxx_vBforum is my VB DB. Note that it's looking for xxx_vBforum.vBsystem which is not right, because system is a Drupal table. vB is my VB table prefix.

Also it's looking for xxx_drupal.vBwatchdog which is not right, because while it's got the Drupal DB, it's prefixing the table with the VB prefix!

This is not actually related to the bug. Drupal is finding a problem whilst it's using the vb database, so it goes to log an error message and gets very confused (because the database hasn't been switched back). If the import went smoothly, that message wouldn't appear.

Anyway, thanks for helping, think I have an idea of how this problem can be tested. I'll have a look at it at some point in the next few days. :)

Have made some changes that should stop the errors appearing when clicking on the test tab. You guys are welcome to try the 5.x-1.x-dev on the vbtodrupal home page, however I doubt it will help with the actual import problems.

I've just tested with Drupal 5.7 and vB 3.6.2 (with table prefixes, in case that was causing the problems) and the import works fine for me. Am leaving the status of this as 'needs more info', as I'm going to need more information on exactly what happens during the import and whether the forum table is populated after it.

Looks like the error is coming from this line (266 in vbtodrupal.module):

$out['html'] .= '<li>'. t('Table %table: Yes', array('%table' => $table)) .'</li>';

The t function call using theming which uses the (hopefully default) drupal database.

I got rid of the t and just used plain text and it worked for me (the test).

$out['html'] .= '<li>'. 'Table '.$table.': Yes</li>';

My solution above worked for the Test. But when trying to migrate, I still ran into this issue. So I created a table in my vBulletin DB:

CREATE TABLE system (type VARCHAR(32));

ianshafer: it should be safe to use the t() function at that spot, as after each set of tables is imported, the database is switched back to the Drupal one. And, just to clarify, what version of vbtodrupal.module were you using, the -dev or 1.0?

The problems with some data not being imported is probably due to: #281861: If duplicate existing Drupal usernames exist, then VBulletin user and posts are skipped

Marking this as duplicate.