Database Error - one table is missing

N

nitins60

New Member
Code: 
Database error in vBulletin 3.8.0:

Invalid SQL:
SHOW KEYS FROM vb_subscribediscussion;

MySQL Error   : Table 'admin_forum.vb_subscribediscussion' doesn't exist
Error Number  : 1146
Request Date  : Saturday, January 17th 2009 @ 09:00:07 AM
Error Date    : Saturday, January 17th 2009 @ 09:00:07 AM
Script        : http://forum/admincp/repair.php?do=fixunique
Referrer      : http:/forum/admincp/repair.php?do=list
IP Address    : 59.97.226.136
Username      : xxxxxxx
Classname     : vB_Database
MySQL Version : 5.0.45

i can guess, one table is missing in database after upgrading to vb 3.8.0

can any one kindly post the default table data or sql query to create...
 
That is pretty weird this table missing ...?


CREATE TABLE `subscribediscussion` (
`subscribediscussionid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`discussionid` int(10) unsigned NOT NULL,
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribediscussionid`),
UNIQUE KEY `userdiscussion` (`userid`,`discussionid`),
KEY `discussionid` (`discussionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Click to expand...


Makes me worry that the install had a problem ...
 
nitins60 said:
how can i reinstall?? becoz i have upgraded from vb3.7.4.....
Click to expand...

That's a tough one. Subscribediscussion is a 3.8.0 table, it didn't exist in previous releases which means that the upgrade script should have created it for you. You might think about rerunning the upgrade and see if it picks up the fact that table are missing.
 
Just restore a backup of your database and try upgrade again.
If that probelm exists, open your phpmyadmin and execute the query as in post#2
 
You must log in or register to reply here.
Back
Top