No announcement yet.

Threadviews database error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Threadviews database error

    I get this database error when I run the Threadviews scheduled task, does anyone know what the problem may be?

    Database error in vBulletin 3.7.4:

    Invalid SQL:

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

    MySQL Error : Table 'threadviews' is marked as crashed and should be repaired
    Error Number : 1194
    Request Date : Thursday, April 9th 2009 @ 08:02:33 PM
    Error Date : Thursday, April 9th 2009 @ 08:02:34 PM
    Script :
    Referrer :
    IP Address : xxxxxxxxxx
    Username : xxxxxxxx
    Classname : vb_database
    MySQL Version : 4.1.22-standard

  • #2
    To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

    If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

    You may have to ask your host to try and repair this for you.
    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.


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