smf message table error

[California Dreamin]

Someone please help me, I'm a novice when it comes to this stuff and I'm stuck.

Here is my error:
Table './rrhs/smf_messages' is marked as crashed and last (automatic?) repair failed

Strange thing is, for the week that my mb has crashed, I've been getting email notifications that new users are pending approval. Of course impossible because no one can log onto the mb. Does this mean a hacker crashed my board?

I have tried repair_settings.php   did all the recommended settings and was able to get on to my admin panel I was able to upgrade from 1.1.4 to 1.1.7

I then got this error"
Table './rrhs/smf_messages' is marked as crashed and last (automatic?) repair failed
File: /home/rrhs/www/forum/Sources/RepairBoards.php
Line: 786

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

This morning I figured out how to login to myphpadmin and tried to run a repair on smf_messages (it said it was "in use": here is the response:
Table      Op      Msg_type      Msg_text
rrhs.smf_messages    repair    status    Table is already up to date

Can someone please tell me what I need to do next?!?!  Thanks in advance.

[California Dreamin]

@California Dreamin - Please start a new topic for you problem unless it is exactly the same as the OP.  When that person's problem is solved, this thread will be marked solved and your problem may not be fixed!

Quote from: JimM on December 17, 2008, 09:46:39 PM

    Quote from: Oldiesmann on December 08, 2008, 01:37:17 AM

        In some cases, a simple "REPAIR TABLE" doesn't work.

        Try one of these and see if either of these forms works:

        Code: [Select]
        REPAIR TABLE <tablename> EXTENDED;
        REPAIR TABLE <tablename> USE_FRM;
        Replace <tablename> with the actual name of the table. Try the first one, and if that doesn't work, try the second one. If neither of those works you may either have to delete and recreate the table (which will cause you to lose a lot of statistics) or have your host run a more powerful repair program on that table.


    You might want to try these suggestions by Oldiesmann.


If one of these suggestions doesn't fix your problem please open a new topic so we can help you get it fixed.


Jim, I tried your suggestion and this is what I get...maybe I'm not doing something right?

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<smf_messages> USE_FRM' at line 1

[JimM]

Leave off the <> and try it again.   As the instructions said, try the first one, then try the second one.

[California Dreamin]

Leave off the <> and try it again.   As the instructions said, try the first one, then try the second one.

Thank you, Thank you!  the 2nd one worked.

The only problem I have now is the messages and topics are all gone.  Is there a way to bring them back?

[California Dreamin]

Leave off the <> and try it again.   As the instructions said, try the first one, then try the second one.

Thank you, Thank you!  the 2nd one worked.

The only problem I have now is the messages and topics are all gone.  Is there a way to bring them back?

I'm still having this problem, can someone help me?

[JimM]

When you look at the table with phpMyAdmin can you see the messages and topics? 

[California Dreamin]

When you look at the table with phpMyAdmin can you see the messages and topics? 

Yes, but the records are O
I do have a backup there of both of those databases, but I have no idea how to restore those files over the 0 ones.

[JimM]

Have you gone to the Admin CP > Forum Maintenance > Recount all forum totals and statistics

[California Dreamin]

Have you gone to the Admin CP > Forum Maintenance > Recount all forum totals and statistics

I just tried this and it just hangs and I let it go for 2 1/2 hours. here is the message:

Not done yet!
To avoid overloading your server, the process has been temporarily paused. It should automatically continue in a few seconds. If it doesn't, please click continue below.
60%

I exited out of that and checked my message board, now all topics and messages are reset to 0

Can you help walk me though on how to take my backups in myphpadmin so I can restore my messages and topics?

[JimM]

Restoring a Database

Take a look at this topic and post back here if you get stuck.

[California Dreamin]

Restoring a Database

Take a look at this topic and post back here if you get stuck.

I don't have the backup database (backup_smf_messages and backup_smf_topics) on my local computer, it's on myphpadmin   how do I export it to my local computer so I can reupload them?
Sorry, I'm a real novice when it comes to these databases

[JimM]

This has some additional information.  Do you have a complete backup or just those tables?

How do I restore the database data?

[California Dreamin]

This has some additional information.  Do you have a complete backup or just those tables?

How do I restore the database data?

I have a complete backup that is a month and half old and I was really not wanting to resort to that as my board crashed at the of Nov and I restored back to then and then now just a few weeks later, it crashed again.  I run an board for high alumni and have had many new signups and don't want to lose everyone new  AGAIN

[JimM]

You may be able to check with your host to see if they have a more current backup.  Additionally you should mention the two occasions where you have had to restore due to crashed tables.  Open a support ticket there to see what they can do.  This appears to be a host related problem. 

[California Dreamin]

You may be able to check with your host to see if they have a more current backup.  Additionally you should mention the two occasions where you have had to restore due to crashed tables.  Open a support ticket there to see what they can do.  This appears to be a host related problem. 

Thanks, I have done that and they worked on it a little bit today for me but with the time difference from Ca to FL they did not totally resolve the missing topics or messages....yet
I was just hoping I could figure out myself

[JimM]

I understand but give your host time to fix it and hopefully it won't happen again.

[California Dreamin]

Ok, I got the error again today and for the 3rd time in 7 weeks that it's crashed and I'm unable to log into my forum

Table './rrhs/smf_messages' is marked as crashed and last (automatic?) repair failed

The host said that none of the other sites hosted on my server has not had any problems.

I have ran repair_settings.php
gone into phpmyadmin and ran repair optimize on the smf_messages
I ran repair tables extended.
nothing seems to work.
Any suggestions?

[SlammedDime]

If the table keeps crashing, then it is normally a problem with the hard disk that the database resides on.  If you're on shared hosting, you should bring this to your hosts attention and have them do a full disk check.  I'd also ask to be moved to a different server on the host.

Really though, this has nothing to do with SMF, it's all server related.

[California Dreamin]

Do you think it would help if I was to do a fresh install of the SMF software?


Tech support did tell me that I'm the only one that is having problems on that server and of course is blaming it on the software.

[JimM]

I don't think re-installing would do you any good.  The area on the disk where your database resides is evidently bad.  Ask you host to move you to another server/disk and then re-install. 

You are the only one having the problem on that server because your database is the only one occupying that specific spot on the disk.