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: 3 34 57 Why Join Help Register/Login via:Register/Login via:
Welcome Guest

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

Admin + Architect
[?] CPosts: 37,212
Posts: 47,385
Avg: 8.3 Post(s) / Day
Activity: 100%
[+] Gain: 4,768.24 FP
Charm: 330

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: 23 March 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.

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

Sponsored Links:

If you have input into "SMF Corrupt Tables - Can't Create New Tempfile" do not be shy, give your input
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



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

World Issues

China vs USA:
USA versus China versus Chinese versus Americans The role of its Army, Politics, and Status in the World. By News 17 Hours Ago
USA vs Syria:
versus U.S.A. Is Syria the next Iraq? By News 1 Week Ago
USA vs North Korea:
North Korea Nuclear Weapons
versus USA This country is no Iraq. What is the USA going to do? What will be the outcome? By Trans 1 Week Ago
North Korea vs South Korea:
versus North Korea Vs. South Korea By Skeptic 1 Week Ago
China Navy:
Chinese Aircraft Carrier
China Navy Beware the new Naval power, they are planning to come on stream with big naval might to match their ground forces. Chinese Aircraft Carrier - Chinese Navy By Chaser 1 Week Ago
North Korea Military:
Discuss  North Korea Military This Thread is about the North Korean Military itself - the kind of army, navy, and air force they have. By Wizard 15th Jan, 2018 - 9:36am
Russia vs. Syria:
Syria vs Russia By News 12th Dec, 2017 - 2:36am
Do You Know What To Do In A Nuclear Attack?:
Top  Do Know In Nuclear Attack By Gknightbc 18th Oct, 2017 - 9:45pm
Japan vs North Korea:
North Korea versus Japan versus War With Japan By Swell 17th Oct, 2017 - 4:17pm
USA vs Germany:
Germany versus U.S.A. By News 20th Sep, 2017 - 3:44pm
China Military:
China Military Technology Preparing For China. China is growing their military. China Military Technology - can it keep up with the US? By Abnninja 5th Mar, 2017 - 5:25pm