SMF Support > SMF 2.0.x Support

To delete and recreate often crashing, possibly corrupt personal_messages table

(1/4) > >>

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.



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

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?



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

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


#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.


[0] Message Index

[#] Next page

Go to full version