SMF Corrupt Tables - Can't Create New Tempfile

- Computer Issues, Video Gaming - Posted: 7th Apr, 2017 - 10:34am

Text RPG Play Text RPG ?
 

Posts: 1 - Views: 750
Simple Machines
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:

international 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:

international 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:

international CODE
root[at]host [~]# cd /var/lib/mysql/[TABLE NAME]
# myisamchk -r -f smf_personal_messages


You should then get a message like:

international 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).



Sponsored Links:

 
> TOPIC: SMF Corrupt Tables - Can't Create New Tempfile
 

▲ TOP


International Discussions Coded by: BGID®
ALL RIGHTS RESERVED Copyright © 1999-2024
Disclaimer Privacy Report Errors Credits
This site uses Cookies to dispense or record information with regards to your visit. By continuing to use this site you agree to the terms outlined in our Cookies used here: Privacy / Disclaimer,