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: 6 60 105 Why Join Help Register/Login via:Register/Login via:
Welcome Guest


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


Admin + Architect
*******
[?] CPosts: 36,676
Posts: 46,835
Avg: 8.3 Post(s) / Day
Activity: 100%
[+] Gain: 4,296.91 FP
Charm: 329

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



Post Date: 22 January 2018 / 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.

Post Date: Mon Jan 22 14:32:09 GMT 2018 / Post ID: #

Comment


Looking for more on smf corrupt tables can't create new tempfile this needs looking into quickly so as to find smf corrupt tables and know and maybe get a better idea.

Guest please SHARE: "SMF Corrupt Tables - Can't Create New Tempfile" on:

Sponsored Links:

To go deeper into this Topic ensure to Search unique terms for: SMF Corrupt Tables - Can't Create New Tempfile
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.

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-2018
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

Highlights

Ruler Of Kings 2 Text RPG General Discussion: What are your thoughts about this Topic? By Txtrpg 3.4 Days Ago
Mouth Wash vs Warm Salt Water: What are your thoughts about this Topic? By JoePublic 1 Week Ago
Happy New Year 2018: What are your thoughts about this Topic? By KNtoran 1 Week Ago
Global Climate Change: Will the earth's climate change on her own or are we the ones sending it in a disastrous direction? By Staple 1 Week Ago
Role-player Goals 2018: What are your thoughts about this Topic? By Wizard 1 Week Ago
ISIS - ISIL: What are your thoughts about this Topic? By Gknightbc 29th Dec, 2017 - 1:02am
Al Franken: What are your thoughts about this Topic? By LiberalLDS 9th Dec, 2017 - 6:54pm
Difference Between Love & Lust: What are your thoughts about this Topic? By Roleplay 9th Dec, 2017 - 5:12pm
Directly Meeting With Aliens: In this Thread are other Threads that asks the question: "Where are the aliens?" By KNtoran 20th Nov, 2017 - 2:52pm
Are People Born Gay Or Gay By Choice?: Is there a science behind why someone is / becomes homosexual? Is it neurological or biological? By Seraphina 18th Oct, 2017 - 12:40pm
The Media: What are your thoughts about this Topic? By Abnninja 16th Sep, 2017 - 4:17am