SMF Support > SMF 2.0.x Support

To delete and recreate often crashing, possibly corrupt personal_messages table

<< < (4/4)

ziycon:

--- Quote from: qureshi on April 04, 2012, 08:57:45 AM ---Hi Guys,

At the time I ran ziycon's repair command, the table was not marked as crashed. I'd repaired it a few days ago, and it has not crashed since.

I think I'll try pkcracks suggestion, and also I will post in a while with a status update.

Thanks for the help, guys.

Regards,
Nadeem

--- End quote ---
Based on the reponse that you posted there were some issues with the .MYI headers being corrupted which have been fixed by running the provied SQL statement, this statement is more then just a repair. It rebuilds the .MYI file from the .FRM files and replaces the existing .MYI file.

I would say just to keep an eye on the table for the next week or two and if you have any problems post back here.

Tables crash for many reasons, unexpected system crash, improper shutdown of a system, malware to name a few.

pkrack:
Regular crash of a specific table is spoting some thing more then accidental crash caused by server or any thing else. It may be due to three reasons
your table structure is stored in a file with some thing wrong or get wrong due to a bunch of reason

the data in the table may be causing the problem

some one is experimenting with your forum.

That was just my approach to the problem. Also contacting the host will be fruitfull . May be they have some thing crashed in their sql engine

Navigation

[0] Message Index

[*] Previous page