Simple Machines Community Forum

Customizing SMF => SMF Coding Discussion => Aiheen aloitti: rendi - joulukuu 30, 2005, 05:57:17 AP

Otsikko: Help me my forum death File './smf/smf_sessions.MYD' not found (Errcode: 2)
Kirjoitti: rendi - joulukuu 30, 2005, 05:57:17 AP
i got this msg
File './smf/smf_sessions.MYD' not found (Errcode: 2)
Otsikko: Re: Help me my forum death File './smf/smf_sessions.MYD' not found (Errcode: 2)
Kirjoitti: Grudge - joulukuu 30, 2005, 06:07:19 AP
Go to PHPMyAdmin and REPAIR the smf_sessions table. It sounds like MySQL has a problem.
Otsikko: Re: Help me my forum death File './smf/smf_sessions.MYD' not found (Errcode: 2)
Kirjoitti: rendi - joulukuu 30, 2005, 07:11:41 AP
i dont find "REPAIR" on my PHPMyAdmin menu  :( can i flush database from mysql cmd ??
Otsikko: Re: Help me my forum death File './smf/smf_sessions.MYD' not found (Errcode: 2)
Kirjoitti: xenovanis - joulukuu 30, 2005, 05:12:38 IP
Run this query in phpMyAdmin:

REPAIR TABLE smf_sessions;
Otsikko: Re: Help me my forum death File './smf/smf_sessions.MYD' not found (Errcode: 2)
Kirjoitti: rendi - joulukuu 30, 2005, 07:41:11 IP
THANKS YOU  ;)
Otsikko: Re: Help me my forum death File './smf/smf_sessions.MYD' not found (Errcode: 2)
Kirjoitti: Kesvirit - tammikuu 16, 2006, 07:54:16 IP
   Thank you!  I just had this same problem today.   And here it is already solved.  I was afraid I'd have to do something crazy.

For the record the full error info I got back from the database was:

{my databasename}.smf_sessions
warning  : Table is marked as crashed
warning  : 2 clients are using or haven't closed the table properly
error    : Record at pos: 135700 is not remove-marked
error    : record delete-link-chain corrupted
error    : Corrupt