Table crash

New Member Joined: May 26, 2007 Posts: 9

When i open my site today, ill recieve this.

Could not query forums information

DEBUG MODE

SQL Error : 1194 Table 'p' is marked as crashed and should be repaired

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( nuke_bbforums f LEFT JOIN nuke_bbposts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN nuke_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 180
File : index.php

Well, this things happens i thought and open my phpmyadmin to do a repair on table p, but there is no table p?. No changes were made at all before this error appiered. If it was'nt hacked to say.

Any suggestions how i can repair this, the database i quite large, about 300MB.

Thanks in advance

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

nuke_bbposts p

That statement (from your query) means that table nuke_bbposts is referenced as p. So, you need to repair table nuke_bbposts.

Posted: Mon Jul 21, 2008 6:23 pm

Thanks, i did the repair on that table and everything went online again.

But, when i accessed sentinel and under tracked ip's, all entries were gone. I then did a repair on the tracked ip table and the list went up again. Now everything was alright.

But now again, as i write this, i recieve a new error regarding the sql server. Now its reporting that the

System Configuration Table - it's missing.

Hmm. i waited for 2 mins and reloaded the page. Now, ill recieve the same error i got this morning.

SQL Error : 1194 Table 'p' is marked as crashed and should be repaired

Ill guess, to resolve this ill just have to do a new repair on the bbposts table but what could be causing this? Could it be some trouble with my sql server??

Really strange

Posted: Mon Jul 21, 2008 7:57 pm

Without a doubt. I'd contact your host and have them try a repair of the database. If it continues then there's a good chance that your disc drive may be going bad.

Worker Joined: Oct 26, 2004 Posts: 134 Location: Boston

Raven wrote:

Without a doubt. I'd contact your host and have them try a repair of the database. If it continues then there's a good chance tat your dick drive may be going bad.

??? Raven I think you need more sleep Laughing

Leave him alone everyone and some one wake him up in the am Wink

Posted: Tue Jul 22, 2008 3:53 pm

I corrected my original post but left your comment in because, well, ROTFL

Posted: Tue Jul 22, 2008 3:55 pm

Did you gave someone else acces to your site/ftp/cpanel ... whatever...?
I would getting paranoïd , check my ftp log's etc... see if files where changed since...???
al this not make sence... btw do you have some installer files on your site?
install.php or something.. or old upgrade files of your forum?

Grtzzz wHiTeHaT Wink

Posted: Tue Jul 22, 2008 7:02 pm

This doesn't feel good. Now, ive got an other table that has crashed.

The site seems to function normal during the day, this is the third night in a row some table crash.

Ive been doublechecking my logs and ive been in touch with my webhoster. Accordning to them, there is no error with the sql server, and my time recordings that the table crashed, they cant find anything matching in their logs.

This time its nuke_bbsearch_wordmatch

Posted: Wed Jul 23, 2008 2:42 pm

Sorry for the off topic guys Thanks for leaving it Raven. When I seen the replies I just about fell out of my chair laughing Thanks for the Smile RavensScripts