database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • matcom gsm
    New Member
    • Jan 2011
    • 18
    • 3.8.x

    database error

    i have this error in this forum

    Database error in vBulletin 3.8.4:

    Invalid SQL:

    SELECT COUNT(post.dateline) AS postcount, post.userid, user.userid, user.username, user.lastpostid, user.posts, user.usergroupid,
    IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid
    FROM post AS post
    JOIN user AS user ON (post.userid = user.userid)


    WHERE dateline > 1323126000
    GROUP BY post.userid
    ORDER BY postcount DESC
    LIMIT 5;

    MySQL Error : Table './matcom_forum/post' is marked as crashed and should be repaired
    Error Number : 145
    Request Date : Tuesday, December 6th 2011 @ 10:03:19 AM
    Error Date : Tuesday, December 6th 2011 @ 10:03:21 AM
    Script : http://www.matcomgsm.com/index.php
    Referrer :
    IP Address : 41.155.64.37
    Username : MatCom Gsm
    Classname : vB_Database
    MySQL Version : 5.1.56

    and my adcmincp work how will i solve this step by step b ecause im a beginer thanks in advance
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    Your post table has crashed. Go to Maintenance > Repair/Optimize tables > select the post table and repair/optimize it. You may have to do this a couple of times until it says OK.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

    • matcom gsm
      New Member
      • Jan 2011
      • 18
      • 3.8.x

      #3
      it work for me thanks but can you tell me how this happen and how nto prevent it in future

      Comment

      • Zachery
        Former vBulletin Support
        • Jul 2002
        • 59097

        #4
        It shouldn't have happened, and there is no way for your as a normal user to prevent it.

        Comment

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