No announcement yet.

post table crash while repairing

  • Filter
  • Time
  • Show
Clear All
new posts

  • post table crash while repairing

    my db is approximately 300MB . after repair db post table is crashed ( i am using following command to repair)
    mysqlcheck -u root -p123 -a -c -o -r -f  --auto-repair forum
    after run above command

    Database error in vBulletin 3.7.3:
    Invalid SQL:
     SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
    , allowsmilie, pagetext_html, postparsed.hasimages, thread.iconid AS threadiconid, iconpath AS threadiconpath, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
    			FROM thread AS thread
    			LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
    			LEFT JOIN user AS user ON (user.userid = post.userid)
    LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 2) LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
    			WHERE thread.threadid IN(51569,51571,51590,51591)
    			AND thread.dateline > 1217029599
    			ORDER BY sticky DESC, thread.dateline DESC
    			LIMIT 10;
    MySQL Error   : Table './zode/post' is marked as crashed and last (automatic?) repair failed
    Error Number  : 144
    Request Date  : Tuesday, September 23rd 2008 @ 05:46:39 PM
    Error Date    : Tuesday, September 23rd 2008 @ 05:46:39 PM
    Script        :
    Referrer      : 
    IP Address    : 
    Username      : admin
    Classname     : vB_Database
    MySQL Version : 5.0.45-community-log

  • #2
    Are you able to run a repair through AdminCP (Or phpMyAdmin if you have it)?


    • #3
      anybody knows ?


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


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