I just tried to install 5.x-2.0-beta1 and got the following errors:

  • user warning: Table 'drupal.vb_thread' doesn't exist query: SELECT threadid, title, postusername AS username FROM vb_thread WHERE lastpost >= 1200345948 ORDER BY lastpost DESC LIMIT 15 in /web/includes/database.mysql.inc on line 172.
  • user warning: Table 'drupal.vb_datastore' doesn't exist query: SELECT data FROM vb_datastore WHERE title = 'options' in /web/includes/database.mysql.inc on line 172.

Looking at your install file, I don't see anything to create vb_thread and vb_datastore files. Would be difficult for the code to find them if they don't exist. ;)

CommentFileSizeAuthor
#6 drupalvb-DRUPAL-5--2.db_.patch653 bytessun

Comments

sgdev’s picture

I said vb_thread and vb_datastore "files" above, but what I meant is database tables.

sgdev’s picture

Title: Install file is incomplete » Does not reference Forums DB

Ah ok a bit more research shows that this isn't about the install file, rather the code is pointing to the Drupal DB when it should be pointing to the forums. Changing the title accordingly.

FYI, my configuration has no table prefix. In config.php I have the following:

$config['Database']['tableprefix'] = '';

sun’s picture

This should not happen. Did you setup your database connection for vBulletin in DrupalvB's settings page after upgrading?

sgdev’s picture

I just looked at Home > Administer > Site configuration > Drupal vB Integration, and selected the database tab. The database connection is set as follows:

Host: localhost
Database: forum
Username: XXXXX (our user name)
Password: XXXXXXXXX (our password)
Table prefix: vb_

The first four fields are correct, but why is table prefix a required field? We are not using any table prefixes for our forums database. I should be able to have this blank but I cannot.

sgdev’s picture

Also very strange, if I look at the integration tab in Drupal vB Integration, it seems like the module doesn't even recognize where the forums are located. In 5.x-1.x, I could hover over "View the Forum" and the other links, and it would give me the right location. Now the word "forums" is completely missing from the URL. For example: "http://localhost/web//admincp" (should be "forums" in between the two slashes)

All I did was copy over the config.php file I was using for 5.x-1.x, so should be no issue with that.

sun’s picture

Status: Active » Needs review
StatusFileSize
new653 bytes

ok. First shot (the easy one). After applying this patch, you should be able to re-submit your database connection settings.

sgdev’s picture

Status: Needs review » Reviewed & tested by the community

Sometimes the right fix is the easy one. After clearing out "vb_" and saving, all errors have gone away. :) I will continue with my testing.

sun’s picture

Status: Reviewed & tested by the community » Fixed

Thanks, committed.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.