Announcement

Collapse
No announcement yet.

2.2.8 down, which error from this message ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 2.2.8 down, which error from this message ?

    My board is down and the message displayed is:

    Database error in vBulletin 2.2.8:

    Invalid SQL: SELECT COUNT(*) AS posts FROM post
    mysql error: Can't open file: 'post.MYI'. (errno: 145)

    mysql error number: 1016

    Date: Tuesday 17th of August 2004 09:54:47 PM


    So is this an error 145 or 1016 or both ?

    And from here I do what ?

  • #2
    Your post table crashed. pload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

    http://www.yourdomain.com/forum/admi...html=1&check=1

    [Of course change the exact URL as appropriate for your forums.]

    If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok (except the session table which you can ignore.)

    Also please read this important announcement:

    http://www.vbulletin.com/forum/showt...180#post694180
    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


    • #3
      OK, board is off and repair.php has been uploaded. The URL you gave me, when changed to my domain, comes back as not found. Maybe I've got it wrong. I used http://mydomain/forumdirectory/adm...?html=1&check=1


      Is it supposed to be /adm...? and nothing before html=1&check=1

      or ?

      Comment


      • #4
        I can find the script at http://mydomain/forumdirectory/admin/repair.php

        It states the following:

        Example Usage:

        repair.php?html=1&check=1 (most common usage, will check a forum and return html results)


        So it looks like the URL you gave me was truncated in your post and it should end with admin/repair.php?html=1&check=1

        Comment


        • #5
          OK, I'm back up after running it a second time.

          So now do I just leave repair.php in the admin directory ?

          As always, thanks for the great support Steve!!!!!!!!!!!

          Can I send you a pizza or some dancing girls ?

          Comment


          • #6
            If your Admin directory if htaccess protected then leave it there. Otherwise remove it.

            Also my wife says I should take the pizza.
            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...
            X