Database Error ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • armagan
    Member
    • Nov 2001
    • 45
    • 3.8.x

    Database Error ?

    Database error in vBulletin 3.8.4:
    Invalid SQL:
    SELECT socialgroup.groupid, socialgroup.name, socialgroup.description, socialgroup.dateline, sgicon.dateline AS icondateline,
    sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height
    FROM vb3_socialgroupmember AS socialgroupmember
    INNER JOIN vb3_socialgroup AS socialgroup ON
    (socialgroup.groupid = socialgroupmember.groupid)
    LEFT JOIN vb3_socialgroupicon AS sgicon ON sgicon.groupid = socialgroup.groupid
    WHERE
    socialgroupmember.userid = 66730
    AND socialgroupmember.type = 'member'
    ORDER BY socialgroup.name;
    MySQL Error : Table './xxx_com_1/vb3_socialgroup' is marked as crashed and should be repaired
    Error Number : 145
    Request Date : Friday, September 18th 2009 @ 08:49:28 AM
    Error Date : Friday, September 18th 2009 @ 08:49:28 AM
    Script : http://www.xxx.com/forum/member.php?...etinfo&u=66730
    Referrer : http://www.xxx.com/forum/
    IP Address : 81.24.15.153
    Username : xxx
    Classname : vB_Database
    MySQL Version : 5.1.37
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #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.


    Comment

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