Need Help with Database

[Rohit]

Hello KWWH,

I run a forum on vB 3.8.4. Today I visited my site and everything was all right...but when I click on any thread...It says DATABASE ERROR. When I go to my Admin CP...there is also DATABASE ERROR.

The error shown is as below:

Database error in vBulletin 3.8.4:

Invalid SQL:

        SELECT 
            IF(votenum >= 1, votenum, 0) AS votenum,
            IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
         post.pagetext AS preview,
            thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
            thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
            thread.prefixid, thread.taglist, hiddencount, deletedcount
            , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
            , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
            
            , threadredirect.expires
            , post_user.displaygroupid AS post_user_displaygid, post_user.usergroupid AS post_user_usergid, last_post_user.displaygroupid AS last_post_user_displaygid, last_post_user.usergroupid AS last_post_user_usergid
        FROM _vbthread AS thread
            LEFT JOIN _vbdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
             LEFT JOIN _vbsubscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
            
            LEFT JOIN _vbpost AS post ON(post.postid = thread.firstpostid)
            
            LEFT JOIN _vbthreadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
            LEFT JOIN _vbuser AS last_post_user ON (thread.lastposter = last_post_user.username)
LEFT JOIN _vbuser AS post_user ON (thread.postuserid = post_user.userid)
        WHERE thread.threadid IN (0,55294,55293,55292,55291,55290,55289,55288,55287,55285,55284,54026,54025,54024,54022,54021,54020,54019,54016,54015,54014) 
        ORDER BY sticky DESC, lastpost DESC;

MySQL Error   : Table './netexper_netexpert/_vbpost' is marked as crashed and should be repaired
Error Number  : 145
Request Date  : Thursday, October 21st 2010 @ 06:00:36 PM
Error Date    : Thursday, October 21st 2010 @ 06:00:37 PM
Script        : http://netexpertz.org/forums/forumdisplay.php?f=32
Referrer      : http://netexpertz.org/forums/
IP Address    : 117.197.19.107
Username      : M@rDuK
Classname     : vB_Database
MySQL Version : 5.0.91-community

What should I do....Plz help me out

Rohit Reviewed by Rohit on 21st Oct 2010. Need Help with Database Hello KWWH, I run a forum on vB 3.8.4. Today I visited my site and everything was all right...but when I click on any thread...It says DATABASE ERROR. When I go to my Admin CP...there is also DATABASE ERROR. The error shown is as below: Database error in vBulletin 3.8.4: Invalid SQL: Rating: 5

[fbiotai93]

try to repair all SQL Database

[Rohit]

Thank you so much fbiotai93
I tried and it Worked !!!

[Spooky]

Completed - Closed