Question Table doesn't exist

[Darin]

got this when I tried to delete a test bid in manage bids in the sponsors
area

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT bidid, bidid AS title
FROM dbtech_forumads_bid
WHERE bidid = 1;

MySQL Error : Table 'arborist_newforum.dbtech_forumads_bid' doesn't exist

The plugin was successfully installed so I don't understand why this table is missing. Can I fix this without have to uninstall and re-install it again?

 

[Fillip H.]

Try running

	CREATE TABLE IF NOT EXISTS `dbtech_forumads_bid` (
		`bidid` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`userid` int(10) unsigned NOT NULL DEFAULT '0',
		`approved` tinyint(1) unsigned NOT NULL DEFAULT '0',
		`dateline` int(10) unsigned NOT NULL DEFAULT '0',
		`pricesid` int(10) unsigned NOT NULL DEFAULT '0',
		`currencyid` char(3) NOT NULL,
		`amount` double unsigned NOT NULL DEFAULT '0.01',
		PRIMARY KEY (`bidid`)
	) ENGINE=MyISAM