Table 'drupal.vb_watchdog' doesn't exist

AmokPaule - September 11, 2009 - 17:05
Project:Drupal vB
Version:6.x-2.x-dev
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:Unassigned
Status:fixed
Description

Hello,
im about to setup drupalvb with my vbulletin 3.8.4.
I get the following error when i activate the module.
Warning: Table 'drupal.vb_watchdog' doesn't exist query: INSERT INTO vb_watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:99:\"Table 'drhqeu.vb_setting' doesn't exist\nquery: SELECT varname, value FROM vb_setting\";s:5:\"%file\";s:101:\"/var/www/domains/test.acrania.eu/drupal/drupal_standart/drupal-6.13/modules/drupalvb/drupalvb.inc.php\";s:5:\"%line\";i:282;}', 3, '', 'http://test.acrania.eu/drupal/drupal_standart/drupal-6.13/?q=admin/settings/drupalvb/database', 'http://test.acrania.eu/drupal/drupal_standart/drupal-6.13/?q=admin/settings/drupalvb/database', '77.187.174.14', 1252688370) in /var/www/domains/test.acrania.eu/drupal/drupal_standart/drupal-6.13/includes/database.mysqli.inc on line 128

Warning: Table 'drupal.vb_watchdog' doesn't exist query: INSERT INTO vb_watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:325:\"Table 'drhqeu.vb_thread' doesn't exist\nquery: SELECT t.threadid, t.title, t.replycount, t.dateline AS created, t.postuserid AS userid, t.postusername AS name FROM vb_thread t INNER JOIN vb_forum f ON f.forumid = t.forumid WHERE f.showprivate = 0 AND t.lastpost >= 1252083570 ORDER BY t.dateline DESC LIMIT 5\";s:5:\"%file\";s:96:\"/var/www/domains/test.acrania.eu/drupal/drupal_standart/drupal-6.13/includes/database.mysqli.inc\";s:5:\"%line\";i:128;}', 3, '', 'http://test.acrania.eu/drupal/drupal_standart/drupal-6.13/?q=admin/settings/drupalvb/database', &# in /var/www/domains/test.acrania.eu/drupal/drupal_standart/drupal-6.13/includes/database.mysqli.inc on line 128

Im not sure wicht database is meant in the drupalvb readme but i tried the drupal db aswell as the vb database.
I also tried the stable module aswell as the development one.
Maybe someone can help :)

#1

AmokPaule - September 11, 2009 - 17:08
Assigned to:AmokPaule» Anonymous

#2

pbtam - September 21, 2009 - 04:54

i can't say this will work, but it worked for me. In the Drupal VB settings page, go to the Database tab, and at the bottom, delete the table prefix of vb_. good luck.

#3

sun - January 5, 2010 - 13:33
Title:Mysql error» Table 'drupal.vb_watchdog' doesn't exist
Status:active» fixed

Yes, you likely need to remove the database prefix for vB, if you don't use prefixed tables.

 
 

Drupal is a registered trademark of Dries Buytaert.