Announcement

Collapse
No announcement yet.

User database error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] User database error

    Database error in vBulletin 4.1.10:

    Invalid SQL:

    SELECT userid, username, posts
    FROM user
    ORDER BY posts DESC;

    MySQL Error : Table 'user' is marked as crashed and should be repaired
    Error Number : 1194
    Request Date : Monday, February 6th 2012 @ 08:04:22 PM
    Error Date : Monday, February 6th 2012 @ 08:04:22 PM
    Script : http://www.coloradoevo.com/cmps_index.php
    Referrer : http://www.vbadvanced.com/forum/showthread.php?p=220950
    IP Address : 174.51.92.115
    Username : Gumba
    Classname : vB_Database
    MySQL Version : 5.1.56
    www.coloradoevo.com

  • #2
    Table is marked as crashed and should be repaired.

    Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin Control Panel -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot access the Admin CP, then you can 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:

    http://www.vbulletin.com/forum/showt...threadid=44909

    You may have to ask your host to try and repair this for you.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Related Topics

    Collapse

    Working...
    X