Play Text RPG ?

"Like" this Page

Welcome Guest

Forgot?

Resend Validation Email

Location: International Discussions > Index > Information Technology - IT > Web Design, Hosting, SEO, Client Help

G+

Posts: 1 - Views: 83

Rating: 0/10 out of 0 Votes

Add Reply
Thread Options
- Add Reply New Topic Add Poll Start Ad Subscribe
- Rate Thread:

Simple Machines

Post Date: 7th Apr, 2017 - 10:34am / Post ID: #

Quote

JB +

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:

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:

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:

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:

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!