Threadviews Error

[Nocturnal222]

threadviews Check Error: Incorrect file format 'threadviews'
threadviews Check Error: Corrupt
threadviews

I got this error after running the repair/optimize table as I do forum maintenance monthly. From there, we cant backup the forum

Anyway to have it fixed?


-m

[Lynne]

If you run repair/optimize on your threadviews table and get told:
threadviews Check Error: Incorrect file format 'threadviews'

Then run these queries to drop/recreate the table:

1:
DROP TABLE IF EXISTS threadviews;

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

If you have a table prefix, then be sure to add that (ie. prefixthreadviews)

[Nocturnal222]

Hello Ms Lynne..
Will this affect the files? Or will it delete important files? Or will any data be loss?

Thank You.
-m

[Lynne]

It won't affect any files - those are database queries. If you had any threadview counts waiting to be added to the total, then yes, you will lose that data. However, right now you don't have that data either since the table is having problems.

[Nocturnal222]

<font color="DarkRed">miss lynne,

thank you very much for the help.

kudos!

-m</font>