Database Error

[Corrupter]

I keep getting emails with the following error..


Database error in vBulletin 3.0.0 Beta 4:

Invalid SQL: SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid
mysql error: Can't find file: 'threadviews.MYD' (errno: 2)

mysql error number: 1017

Can some light be shed on that please oh great ones

[fiNal]

I keep getting emails with the following error..


Database error in vBulletin 3.0.0 Beta 4:

Invalid SQL: SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid
mysql error: Can't find file: 'threadviews.MYD' (errno: 2)

mysql error number: 1017

Can some light be shed on that please oh great ones

try admincp -> import & maintenance -> Repair / Optimize Tables -> Check threadview, make sure that Optimize Tables & Repair Tables are set to yes and then click Continue.

im not sure whats this table for, cause it only has one field and no entries (on my board). Maybe its used if you disabled Update Thread Views Immediately or something like that.

btw: the MYD-file is the file where all the data of the mysql-table is stored... this file is missing now - maybe all the data of this table is lost