MYSQL error, how do I fix?

Anyone know how I fix this mysql error? When I go to post a new thread this page pulls up with this error instead for this site: http://wwww.ARadarDetector.com

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT tag.tagtext, IF(tagthread.tagid IS NULL, 0, 1) AS taginthread
FROM tag AS tag
LEFT JOIN tagthread AS tagthread ON
(tag.tagid = tagthread.tagid AND tagthread.threadid = 0)
WHERE tag.tagtext IN ('radar guns','how its made radar');

MySQL Error : Table 'radar_radar.tagthread' doesn't exist
Error Number : 1146
Request Date : Sunday, December 20th 2009 @ 04:04:07 AM
Error Date : Sunday, December 20th 2009 @ 04:04:10 AM
Script : Radar Detector Reviews &amp Radar Detectors Forum Radar
Referrer : Radar Detector Reviews &amp Radar Detectors Forum Radar
IP Address : 98.200.123.114
Username : Radar Detector Reviews
Classname : vB_Database
MySQL Version : 5.0.85-community-log

Did you delete your tagthread table in the database? Check phpmyadmin.

If deleted what file do I need to reupload to fix?

I am looking in there and that file is gone.

You don't... you'd have to re-create the table in phpmyadmin, and then all your old tags are basically wiped out.

what vb version are you using?

3.8.4 what do you recommend I do?

I currently don't currently have access to a 3.8.4 install.... this is from 3.8.1. I'm pretty sure its the same (it didn't change from 3.7 to 3.8, so i doubt it changed to 3.8.4)

run this in phpmyadmin.
click in to your fourm DB
then click any table on the left nav.

then click the SQL tab

paste this

Code:

CREATE TABLE IF NOT EXISTS `tagthread` (
  `tagid` int(10) unsigned NOT NULL default '0',
  `threadid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tagid`,`threadid`),
  KEY `threadid` (`threadid`,`userid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

and run the query.


This will re-create the table and stop the errors, but all your old tags will be missing. There may be a tool in vb ACP that will indirectly rebuild tag info, like
Rebuild Thread Information

there's no direct tag tool. so, try a couple re-builders in the maintenance - rebuild counters section.