Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: WantSome on April 23, 2023, 05:09:51 AM

Title: Table smf_messages' is marked as crashed and last (automatic?) repair failed
Post by: WantSome on April 23, 2023, 05:09:51 AM
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,





Title: Re: Table smf_messages' is marked as crashed and last (automatic?) repair failed
Post by: Doug Heffernan on April 23, 2023, 09:53:29 AM
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?
Title: Re: Table smf_messages' is marked as crashed and last (automatic?) repair failed
Post by: WantSome on April 23, 2023, 11:55:54 AM
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.
Title: Re: Table smf_messages' is marked as crashed and last (automatic?) repair failed
Post by: Sir Osis of Liver on April 23, 2023, 03:47:17 PM
Just move to a better host.
Title: Re: Table smf_messages' is marked as crashed and last (automatic?) repair failed
Post by: Steve on April 23, 2023, 05:37:11 PM
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.