SMF Support > SMF 2.0.x Support

To delete and recreate often crashing, possibly corrupt personal_messages table

(1/4) > >>

qureshi:
Hi there,

The personal_messages table crashes often, a few times a week.
Repairs through PhpMyadmin fixes it, but not permanently.
It has been an issue for a while, and the host offers only temporary solutions.
The crashes return, and it's always "personal_messages is marked as crashed".

I've researched a bit, and the cause seems to be corruption.
The solution then is to truncate the table, export the SQL, drop the table, and then restore it.

However, I suspect there is more to it than this.

Please, do give me short pointers on what I should do and watch out for.

Thanks,

Nadeem

pkrack:
A.o.A nadeem , if you need to drop the table then just copy its data and delete it and when create a new one then add the data to it. No need to drop whole database. Also check if your users are doing some thing wrong intentionally or unintentionally

qureshi:
A.o.A pkcrack.

Thanks for the swift reply. I have a few questions.

1. Wouldn't copying the data preserve the corruption?

2. What are the things users could be doing wrong?

Thanks,

Nadeem

ziycon:
Try running the below SQL command first and post the response here.

--- Code: ---REPAIR TABLE {prefix}personal_messages USE_FRM;
--- End code ---

qureshi:
@ziycon,

#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_personal_messages USE_FRM' at line 1

Thanks for joining in.

Navigation

[0] Message Index

[#] Next page

Go to full version