Post reply

Corrupt SQL file how to restore?

  • December 23, 2017 at 8:21 am

    #341409

    why this error occurs? like and failure was not, and cleaning the antivirus.
    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
    FROM vb_thread AS thread
    LEFT JOIN vb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
    LEFT JOIN vb_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
    LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)
    LEFT JOIN vb_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
    WHERE thread.threadid IN (0,9839,6392,6391,1981,1473,88,1375)
    ORDER BY sticky DESC, lastpost DESC;
    SQL Error : Table './klon/vb_post' is marked as crashed and should be repaired
    Error Number : 145
    IP Address : 90.188.220.91
    Username : xD
    Classname : vB_Database
    SQL Version : 5.1.54

  • December 23, 2017 at 8:28 am

    #1973331

    Contact the vendor!
    😎

  • December 23, 2017 at 3:18 pm

    #1973347

    This has all the ear-markings of another one of "those" spam posts.  Someone who has never posted before and on their first visit or so posts something with a title about a corrupt database, the actual post is nearly unintelligible or not related to a real problem, and then sometime in the next week some rubber will answer with a link.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 23, 2017 at 4:12 pm

    #1973350

    I'm also a little amazed the OP says they're using SQL (Server?) Version 5, which I'm pretty sure never existed.  Even if it did, it would have been out of support for probably 12 or so years by now.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • December 23, 2017 at 4:32 pm

    #1973351

    It's not SQL Server. vBulletin uses MySQL. So, given the version, this is MySQL 5.1.54 (still pretty outdated)

    This isn't exactly T-SQL afterall - IF(votenum >= 1, votenum, 0) AS votenum,

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 24, 2017 at 8:04 am

    This was removed by the editor as SPAM

  • December 24, 2017 at 8:14 am

    #1973360

    powellsudie - Sunday, December 24, 2017 8:04 AM

    good day ! perhaps you should help in such a situation, the recovery via backup , but if you do not help, try sql repair. download the program (link removed)

    Reported as spam.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply