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

Attached Image 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:

Attached Image 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:

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


You should then get a message like:

Attached Image 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:


Comment Add Comment As A Guest
Important Guest, please be considerate by using the appropriate tags as well as checking your grammar before submitting or it will be deleted. See: Constructive Posting Policy.

# Characters:
0
# Words:
0
# Sentences:
0
# Paragraphs:
0
Reading Time:
0
Optional:
Search

Tip TIP: Press above button ONCE only. If you come back here via the [Back] button on your browser then you will need to click [More Options] button (below) first in order to re-enable your ability to Post.

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



International Discussions Coded by: BGID®
ALL RIGHTS RESERVED Copyright © 1999-2025
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,