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: 1 49 122 Why Join Help Register/Login via:Register/Login via:
Welcome Guest

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

Admin + Architect
[?] CPosts: 36,393
Posts: 46,400
Avg: 8.5 Post(s) / Day
Activity: 100%
[+] Gain: 2,222.01 FP
Charm: 315

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: 26 July 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:

OPTIONS FOR DISCUSSION: About, How, When, Where, Why of 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
, please check your grammar before submitting. ?

 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



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

World Issues

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 KNtoran 1.6 Day(s) Ago
USA vs Germany:
Germany versus U.S.A. By Abnninja 1.8 Day(s) Ago
USA vs Syria:
versus U.S.A. Is Syria the next Iraq? By Abnninja 1.8 Day(s) Ago
Japan vs North Korea:
North Korea versus Japan versus War With Japan By investigator 4th Jul, 2017 - 10:29am
Russia vs. Syria:
Syria vs Russia By Abnninja 27th Jun, 2017 - 10:32pm
China vs USA:
USA versus China versus Chinese versus Americans The role of its Army, Politics, and Status in the World. By Abnninja 2nd Jun, 2017 - 10:12pm
North Korea vs South Korea:
versus North Korea Vs. South Korea By Abnninja 23rd May, 2017 - 8:52pm
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 Abnninja 17th May, 2017 - 3:03pm
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
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 News 17th Dec, 2016 - 12:39am