MySQL Error: Can't find file: 'vb3_threadviews' (errno: 2)

[SecTa]

Greetings. I've got the following error continuously sent to administrative mail:

Database error in vBulletin 3.6.8:

Invalid SQL:

	INSERT INTO vb3_taggregate_temp_1203980580
		SELECT threadid, COUNT(*) AS views
		FROM vb3_threadviews
		GROUP BY threadid;

MySQL Error  : Can't find file: 'vb3_threadviews' (errno: 2)
Error Number : 1017
Date         : Tuesday, February 26th 2008 @ 01:03:09 AM
Script       : http://www.mysite.net/cron.php?&rand=133123
Referrer     : http://www.mysite.net/showthread.php?t=31885&page=2
IP Address   : xxx.xx.xxx.xxx
Username     : Unregistered
Classname    : vb_database

Tried to do optimize/repair several times - problem still there:

vb3_threadredirect  	Check  	Status: OK
vb3_threadredirect 	Optimize 	Status: Table is already up to date
vb3_threadviews 	Check 	Error: Can't find file: 'vb3_threadviews' (errno: 2)
vb3_threadviews 	  	
vb3_upgradelog 	Check 	Status: OK
vb3_upgradelog 	Optimize 	Status: Table is already up to date

Running vB 3.6.8pl2. DB maintenance was done recently and there were no errors occurred back then...

[Jake Bunce]

Since the repair is failing and that table doesn't contain any important information, I recommend you drop and recreate the table with these two queries:

DROP TABLE threadviews

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

[SecTa]

thanks, that worked