MyBB Community Forums

Full Version: MyBB is automatically repairing a crashed table
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
Hello everyone!

Since some days, i am constantly getting the error " MyBB is automatically repairing a crashed table ".

I haven't installed anything new but just updated the forum to the last version recently.

As i'm using my forum with cpanel, i was able to find the crashed table. Infact when i click on the inbox tab, i get the errors.

The screenshots are attached.

Should i run the query indicated?


SELECT COUNT(*) AS total FROM mybbmm_privatemessages WHERE uid='1' AND folder='1' 

Regards.

[attachment=46069]
[attachment=46070]
try to repair the table with PhpMyAdmin
It shows me this.

[attachment=46071]

That means, it is being used.

Which query should be run?
REPAIR TABLE mybbmm_privatemessages;
Tried but same error.

[attachment=46072]
webspace or own server?

if webspace contact your hoster

maybe someone else has another idea, I just unfortunately not
I'm using a VPS.

Thanks for your time.
Do you have enough space left on your disk ?
The disk was also almost full because of the saved backups. But i have already deleted the old backups to have free space.
Remembers me a filesystem trouble. Try to check the disk and the filesystem. If it's ok:
1. turn your forum offline
2. save your database (alway save your database)
2. rename the table (it will change its files) to soemthing like mybbmm_privatemessages_copy
3. copy the renamed table to mybbmm_privatemessages
4. repair mybbmm_privatemessages

If everything ok, you can turn on your forum.
If something went wrong, use your backup.
Pages: 1 2