Post Date: 7th Apr, 2017 - 10:34am / Post ID:
#
SMF Corrupt Tables - Can't Create New Tempfile
SMF Corrupt Tables - can't create new tempfile
If you are trying to access a part of your SMF site and get a message such as the one below:
QUOTE smf_personal_messages' is marked as crashed and last (Automatic?) repair failed
Then you will need to do a repair. Sometimes a simple repair via PhpMyAdmin or Shell will still spit out errors, so here is one of the best solutions but you will need shell access and run this command:
QUOTE myisamchk -r -f smf_personal_messages
If you get a message about "Smf_personal_messages" not being found then use the below as an example to navigate:
CODE root[at]host [~]# cd /var/lib/mysql/[TABLE NAME]
# myisamchk -r -f smf_personal_messages
You should then get a message like:
QUOTE - recovering (With sort) MyISAM-table 'smf_personal_messages'
Data records: 182570
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
Everything should now be restored. If not hopefully you would have made a backup prior to the crash which will now need to be restored (That's another operation).