threadviews table deleted

[TruthElixirX]

I think my host accidentally deleted my threadviews table . I get this error:

Database error in vBulletin 3.6.8:

Invalid SQL:

       INSERT INTO ukvba_taggregate_temp_1215561360
               SELECT threadid, COUNT(*) AS views
               FROM ukvba_threadviews
               GROUP BY threadid;

MySQL Error  : Can't find file: 'ukvba_threadviews' (errno: 2)
Error Number : 1017
Date         : Wednesday, July 9th 2008 @ 12:16:07 PM
Script       : http://www.neighbours.co.uk/vbadvance/cron.php?&rand=790579
Referrer     : http://neighbours.co.uk/
IP Address   : 86.130.7.97
Username     : Unregistered
Classname    : vB_Database 

I figured my thread views are gone forever, but is there anyway I can recreate the table to stop getting error emails and make it work from here on out?

[Steve Machol]

You can run this query to create that table:

CREATE TABLE threadviews (
threadid INT UNSIGNED NOT NULL DEFAULT '0',
KEY threadid (threadid)
);

[TruthElixirX]

Hm, now this is interesting:

I tried running the query from the admincp and received this message:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1050
error desc: Table 'ukvba_threadviews' already exists

[Steve Machol]

Run this:

DROP TABLE IF EXISTS ukvba_threadviews;

Then this:

CREATE TABLE ukvba_threadviews (
threadid INT UNSIGNED NOT NULL DEFAULT '0',
KEY threadid (threadid)
);