2.2.8 down, which error from this message ?

[vNovice]

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 ?

[Steve Machol]

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

[vNovice]

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 ?

[vNovice]

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

[vNovice]

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 ?

[Steve Machol]

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

Also my wife says I should take the pizza.