Got error 127 from storage engine

[marcnyc]

SMF Version: SMF 1.1 RC3
I upgraded to 1.1 RC3 last week. Everything seemed smooth and seemed to work.
Today, with no intervention from my side, suddenly I get this error on FireFox:

Got error 127 from storage engine
File: /home/chaindlk/public_html/community/Sources/Subs.php
Line: 2506

and this error on Safari:
Please try again. If you come back to this error screen, report the error to an administrator.

by just pointing to my SMF installation.
Can somebody help me understand what this is, how to solve it and why it would happen from one day to the next? it was working this morning, I was using the forums...

[Oldiesmann]

[Micahel@localhost ~] # perror 127
OS error code 127: Key is missing
MySQL error code 127: Record-file is crashed

Run this query in phpMyAdmin:

Code Select Expand

REPAIR TABLE smf_log_online

That should fix your problem.

[marcnyc]

That did indeed fix the problem. Thank you very much for your super quick help!
Can I ask why this would happen and how to prevent it in the future?

[Oldiesmann]

I'm not sure there's any specific reason for that happening or anything you can do to really prevent it. Just make sure you've got SMF set to optimize your tables every so often to clear up overhead and prevent problems.

[marcnyc]

I had it set to 7 so I set it to 2, hopefully that will help prevent.
Thanks a lot!

[RoarinRow]

Hmmm, I got this error today today.  I did the repair and was able to get back in   

[mohoganybrwn]

I'm having the same problem but I am using 1.1.4 ...

[greyknight17]

Did you try repairing the smf_log_online table as mentioned above?

[mohoganybrwn]

No, because I didn't know if that was that was the correct one for my problem.
My error says:
Got error 127 from storage engine
File: /home/database/public_html/community/Sources/Display.php
Line: 105

so would I use the same code as mentioned above for this problem?

[mohoganybrwn]

Well I just tried it and it didn't fix the problem.  So what do I do now?

[mohoganybrwn]

Yay! I fixed the problem by myself.  For the people who have this same problem.  I went to Cpanel and clicked on "MySQL® Databases" and then checked the forum database. It let me know what was crashed or corrupt and just repaired the tables from there...and that was it! I hope this can help someone out.

[mohoganybrwn]

Well...I thought that fixed it...but once again I'm getting the same error.  Can anyone help me???

Got error 127 from storage engine
File: /home/xcolour/public_html/community/Sources/Display.php
Line: 105

[pvthudson01]

One bump up for me i am getting:

Got error 127 from storage engine
File: /home/content/p/v/t/pvthudson01/html/feedback/forum/Sources/Subs.php
Line: 2543

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

[greyknight17]

Try repairing the whole database in phpMyAdmin.