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

Started by WantSome, April 23, 2023, 05:09:51 AM

Previous topic - Next topic

WantSome

Hello,

Running 2.0.19

Yesterday I was unable to connect to my website because of this message:

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

I logged into Cpanel and ran check database, it showed the following errors:

[.smf_messages] Table is marked as crashed and last repair failed   
[.smf_messages] Found key at page -1 that points to record outside datafile

I then ran 'repair database' in cpanel and it said that there has been a successful repair.  But when I tried to access my website I still get the crashed message and when I ran check database in cpanel I still get the above errors.

So after some searching on this forum I also tried to do the repair via myphp

REPAIR TABLE `smf_messages`

When it r an this query, it said it's successful, but when I clicked on smf_messages it tells me
Error #144 - Table './smf_messages' is marked as crashed and last (automatic?) repair failed

After this, I got a 500 connection error so I called my host who after some long investigation told me something about running out of space on the server and he said he was building a new server.  Late last night he messaged me to say everything was fixed.

But, when I logged on this morning I'm still getting the crashed table issue, and none of the repair options worked.

Obviously I've called my host again, but he's not answering.  Until he does, I wonder if you lovely people had any suggestions?

Regards,






Doug Heffernan

If the repair will not work, there is nothing that can be done till the server disk space issue has been fixed.

Are you on a shared hosting plan, or do you have your own vps/dedicated box?

WantSome

I am on a shared hosting plan and the host has said he fixed the issue with the disk space but clearly it's not resolved.  He still hasn't responded but it's sunday and clearly that's not included in the 24/7/365 service plan.

I've been thinking of upgrading to a dedicated server or something like it but it's more costly and I don't make money from my website it's just a hobby.

Sir Osis of Liver

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Steve

Quote from: Sir Osis of Liver on April 23, 2023, 03:47:17 PMJust move to a better host.
Both Sir O and @Kindred have recommended the hosts they use many times here. I'd give either/both of them a look. More than likely moving to either one will be cheaper and supported better than the one you're on now.
DO NOT pm me for support!

Advertisement: