Database error: taggreagate_TEmp

Discussion in 'Programming' started by swapnil0545, Jun 28, 2009.

  1. swapnil0545

    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)
     
  2. swapnil0545

    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.
     
  3. swapnil0545

    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)
    );
    __________________
     
  4. Hoxxy

    Hoxxy New Member

    [mod]Please remember to [code ] wrap [/code] any code you post.[/mod]
     

Share This Page