Sudden SQL Error - The last 2 Days

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Bluetiereign
    Member
    • Nov 2004
    • 36
    • 3.0.3

    Sudden SQL Error - The last 2 Days

    Database error in vBulletin 3.8.3:

    Invalid SQL:

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

    MySQL Error : Incorrect file format 'threadviews'
    Error Number : 130
    Request Date : Saturday, August 22nd 2009 @ 03:36:30 PM
    Error Date : Saturday, August 22nd 2009 @ 03:36:30 PM
    Script : http://www.xxxxxx.net/forums/cron.php?rand=1250976988
    Referrer : http://www.xxxxxx.net/forums/forumdisplay.php?f=7
    IP Address : 66.183.43.180
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :




    Anyone have any idea what is happening here ?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Run these queries to recreate these tables:

    1:
    DROP TABLE IF EXISTS threadviews;

    2:
    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:
    DROP TABLE IF EXISTS attachmentviews;

    4:
    CREATE TABLE attachmentviews (
    attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
    KEY postid (attachmentid)
    );
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Bluetiereign
      Member
      • Nov 2004
      • 36
      • 3.0.3

      #3
      Thank you very much. Worked like a charm.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...