vb.org Archive - Board crashed after 6 months of no changes at all?? Please help! :(

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Board crashed after 6 months of no changes at all?? Please help! :( (https://vborg.vbsupport.ru/showthread.php?t=61944)

007	02-26-2004 12:39 PM

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

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:

Code:

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

02-26-2004 12:49 PM

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

02-26-2004 12:51 PM

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
[sql]
CHECK TABLE post
[/sql]

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

If this is the case
[sql]
REPAIR TABLE post
[/sql]

If this fails you hopefully got a backup ...

007	02-26-2004 12:55 PM

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

02-26-2004 01:04 PM

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

Boofo

02-26-2004 02:17 PM

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

007	02-26-2004 05:42 PM

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

Boofo

02-26-2004 05:48 PM

Anytime, my friend. ;)

filburt1

02-26-2004 06:15 PM

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/showthrea...threadid=51560

Boofo

02-26-2004 06:19 PM

Do you have a version for vB3 yet?

filburt1

02-26-2004 06:20 PM

Quote:

Originally Posted by Boofo

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.

All times are GMT. The time now is 05:26 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01290 seconds Memory Usage 1,728KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (11)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: