Database error: taggreagate_TEmp

swapnil0545

New Member
Database error in vBulletin 3.8.3:

Code:
Invalid SQL:

       INSERT INTO taggregate_temp_1246164960
               SELECT threadid, COUNT(*) AS views
               FROM threadviews
               GROUP BY threadid;

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

swapnil0545

New Member
Now, I just saw my table
then when i threadview table it was corrupted I mean there was no datatype specified there and nothing was there
Instead there was written:
Can't find file: 'threadviews' (errno: 2)



I think I will have to delete my threadview table and make a new 1.

Can you guyz temme the code to make new threadview table with all the properties like datatype and all.
 

swapnil0545

New Member
I got the solution: Run these queries to recreate these tables:

1:
Code:
DROP TABLE IF EXISTS threadviews;

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

If you find you have the same error with the attachmentviews table, run this queries:

3:
Code:
DROP TABLE IF EXISTS attachmentviews;

4:
Code:
CREATE TABLE attachmentviews (
attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
KEY postid (attachmentid)
);
__________________
 
Top