I updated to to the latest recommended version, which is 5.x-2.0-rc1. When I ran update.php:

Warning: Table 'drupal.vb_watchdog' doesn't exist query: watchdog INSERT INTO vb_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Table &amp;#039;drupal.vb_user&amp;#039; doesn&amp;#039;t exist\nquery: _drupalvb_init_user_map\nSELECT userid, username FROM vb_user</em> in <em>/var/www/html/includes/database.mysqli.inc</em> on line <em>151</em>.', 2, '', 'http://example/update.php?op=do_update', 'http://example/update.php?op=selection', 'example', 1209574037) in /var/www/html/includes/database.mysqli.inc on line 151
{ "status": true, "percentage": 100, "message": "Updating drupalvb module" }

When I click on the update summary link I get this page:

user warning: Table 'drupal.vb_user' doesn't exist query: _drupalvb_init_user_map SELECT userid, username FROM vb_user in /var/www/html/includes/database.mysqli.inc on line 151.

The update process was aborted prematurely while running update # in .module. All other errors have been logged. You may need to check the watchdog database table manually.

    * Main page
    * Administration pages

The following queries were executed
drupalvb module
Update #5100

    * No queries

Update #5200

    * CREATE TABLE {drupalvb_users} ( uid int(10) unsigned NOT NULL default '0', userid int(10) unsigned NOT NULL default '0', PRIMARY KEY (uid), KEY userid (userid) ) /*!40100 DEFAULT CHARACTER SET utf8 */;
CommentFileSizeAuthor
#8 drupalvb-DRUPAL-5--2.upgrade-prefix.patch660 bytessun

Comments

stevenpatz’s picture

stevenpatz
he/him
commented

Additionally when I go to any user's page I get:

user warning: Table 'drupal.vb_user' doesn't exist query: drupalvb_user_update SELECT userid, salt FROM vb_user WHERE username = 'joe' in /var/www/html/includes/database.mysqli.inc on line 151. 
user warning: Table 'drupal.vb_user' doesn't exist query: drupalvb_create_user SELECT userid FROM vb_user WHERE username = 'joe' in /var/www/html/includes/database.mysqli.inc on line 151. 
user warning: Table 'drupal.vb_usertitle' doesn't exist query: drupalvb_create_user SELECT title FROM vb_usertitle WHERE minposts = 0 in /var/www/html/includes/database.mysqli.inc on line 151. 
user warning: Table 'drupal.vb_user' doesn't exist query: drupalvb_create_user INSERT INTO vb_user (username, usergroupid, password, passworddate, usertitle, email, salt, showvbcode, languageid, timezoneoffset, posts, joindate, lastvisit, lastactivity, options) VALUES ('joe', '2', 'random_salt', '2008-04-30 14:29:51', 'Junior Member', '', '|?q', 1, 1, '-5', 0, '1209580191', '1209580191', '1209580191', '3415') in /var/www/html/includes/database.mysqli.inc on line 151. 
user warning: Table 'drupal.vb_userfield' doesn't exist query: drupalvb_create_user INSERT INTO vb_userfield VALUES (0, NULL, '', '', '', '') in /var/www/html/includes/database.mysqli.inc on line 151. 
user warning: Table 'drupal.vb_usertextfield' doesn't exist query: drupalvb_create_user INSERT INTO vb_usertextfield VALUES (0, NULL, NULL, NULL, NULL, '', NULL, NULL) in /var/www/html/includes/database.mysqli.inc on line 151. 
user warning: Table 'drupal.vb_user' doesn't exist query: drupalvb_set_login_cookies SELECT userid, password, salt FROM vb_user WHERE username = 'joe' in /var/www/html/includes/database.mysqli.inc on line 151.
sun’s picture

sun
Primary language German
Location Karlsruhe
commented

Please go to Drupal vB's database settings and check whether the connection is setup correctly and the table prefix is correct.

stevenpatz’s picture

stevenpatz
he/him
commented

In my settings.php file I have 

$db_url['default'] = 'mysqli://user:pass@localhost/drupal';
$db_url['vbulletin'] = 'mysqli://vbulletin:pass@example/vbulletin';

In the config.php file I have:

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

Which is what I had before the update, because there is no table prefix used for the vbulletin DB. is there somewhere else I need to check?

sun’s picture

sun
Primary language German
Location Karlsruhe
commented

Yes, database connection settings have been moved into the module settings page. See administer >> Site configuration >> Drupal vB >> Database

stevenpatz’s picture

stevenpatz
he/him
commented

That was the problem, I wouldn't have thought to check the Settings page before doing the update.php step. Perhaps checking to see what the $config['Database']['tableprefix'] = ''; is set to and using that in the install file. That might keep the support requests to a minimum.

sun’s picture

sun
Primary language German
Location Karlsruhe
commented

Has copying of config.php been required in 5.x-1.x?

stevenpatz’s picture

stevenpatz
he/him
commented

Yes it has. From the README of that version:

-- INSTALLATION --

* Install as usual, see http://drupal.org/node/70151 for further information.

* After installing vBulletin, copy config.php from your vBulletin includes/
  directory into Drupalvb's module folder.

* Edit your Drupal site's settings.php file to include the vBulletin database.
  This is a CRUCIAL step, and involves turning $db_url into an array that looks
  like this (around line 87; without code tags):
sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Active » Needs review
StatusFileSize
new drupalvb-DRUPAL-5--2.upgrade-prefix.patch660 bytes

Thanks -- so I guess, this should work out

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Needs review » Fixed

Thanks, committed.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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