SMF Corrupt Tables - Can't Create New Tempfile

- Web Design, Hosting, SEO, Client Help - Posted: 7th Apr, 2017 - 10:34am

Register Login Text RPG Play Text RPG ?     New: 4 53 121 Why Join Help Register/Login via:Register/Login via:
Welcome Guest


Posts: 1 - Views: 83 Rating: 0/10 out of 0 Votes
Simple Machines
Post Date: 7th Apr, 2017 - 10:34am / Post ID: #


Admin + Architect
*******
[?] CPosts: 36,881
Posts: 46,994
Avg: 8.5 Post(s) / Day
Activity: 100%
[+] Gain: 2,971.33 FP
Charm: 325

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[i]Replying to:[/i] 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).


Post Date: 24 September 2017 / Post ID: #

, "SMF Corrupt Tables - Can't Create New Tempfile" is a Web Design, Hosting, SEO, Client Help Topic but its lacking your input! Be first to Reply to SMF Corrupt Tables - Can't Create New Tempfile! You will then have 1 Posts and 1 Core Posts! International Comment Add Comment now or scroll down for [Fast Reply] box.
Guest please SHARE: "SMF Corrupt Tables - Can't Create New Tempfile" on:

Sponsored Links:

We may have more on SMF Corrupt Tables - Can't Create New Tempfile, Search first and if not Start A NEW Topic if SMF Corrupt Tables - Can't Create New Tempfile is not what you had in mind.
Options Fast Reply Add Reply Add Poll


No Registration Required!

We welcome input from visitors:
Add Comment As A Guest
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.

 Enable Smilies  Enable Signature

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


Share:

Like:

Donate Compare Membership
International Discussions Coded by: BGID® ALL RIGHTS RESERVED Copyright © 1999-2017
Disclaimer Privacy Report Errors Credits

Latest Topics


Key: Background for Upgraded Members
Updated every 5 minutes See More

Latest Member Intro

Newest Members

Updated every: 31 minutes

Latest Photos

Life's A Beach: Maracas, Trinidad
Life's A Beach: Maracas, Trinidad
Uploaded by: JB
Rated: 0/10 + 10 comments
Last comment: BabyTrini 7th Sep, 2017 - 4:08pm
▲ Rate Photo! ▲ Add Pic
Kntoran's Medals
8 comments
Rate My Pic!
Abnninja Army Pics
23 comments
Rate My Pic!
Baby Mourning Doves
8 comments
Rate My Pic!
JB's Home Made Pizza 3
11 comments
Rate My Pic!
Pre-Workout
9 comments
Rate My Pic!
My Current Project
12 comments
Rate My Pic!
Desert 1991
9 comments
Rate My Pic!
Playing Pool
1 comments
Rate My Pic!

Updated every: 55 minutes