Board crashed after 6 months of no changes at all?? Please help! :(

[007]

Hi my board just recently crashed for no reason. I haven't done anything to it for nearly 6 months either. The SQL error I get is:Database error in vBulletin 2.3.0:

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

mysql error number: 1016

I don't understand what could cause this, and it doesn't look like the error is very specific. Please help if you have any idea what I should do. :surprised:

[Boofo]

Your post table looks like it is corrupted. Just do a Repair and Optimize on the table and it should take care of it. ;)

[Andreas]

There is a problem with the mySQL-backend: The file for table post (post.MYD) can't be opened.
This can be caused by hard disk damage for example.

Try

CHECK TABLE post


I think it will report Table was marked as crashed and should be repaired

If this is the case

REPAIR TABLE post


If this fails you hopefully got a backup ...

[007]

Awesome. Thanks guys. It's fixed. I had a backup but it was a few weeks old and I wasn't going to resort to it unless I had to. Thanks though. It's fixed. How does something like this suddenly happen though?

[Andreas]

Either a bug in mySQL (incorrect data written, crashed during write, etc.), or a hardware failure (hardisk failure, instable RAM, etc.)

[Boofo]

Or that unknown force that comes out of nowhere once in a while to add a little zest to our lives. ;)

[007]

Makes sense I guess. Thanks guys. Everything's working fine now. :)

[Boofo]

Anytime, my friend. ;)

[filburt1]

FWIW, PHP programs do not crash unless it miraculously takes the PHP interpreter down with it (which would be one hell of a script to do that).

Random hack plug that will fix this in the future: https://vborg.vbsupport.ru/showthread.php?s=&threadid=51560

[Boofo]

Do you have a version for vB3 yet?

[filburt1]

Do you have a version for vB3 yet?
No, but others in the thread have said that they've been able to port it to vB3.