Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: whatiswhat on August 19, 2008, 10:49:01 PM

Title: msf mysterious crash??
Post by: whatiswhat on August 19, 2008, 10:49:01 PM
My forum was running fine. Have not made any changes then one day this is what you get when you try to access it.
This is what comes up:

: Can't open file: 'smf_sessions.MYI' (errno: 145)
/forum/Sources/Load.php
2004


I am hosing it on Yahoo small business domains
the url is: http://www.painbrain.com/forum/

Hopefully somebody can tell me what happened.
Title: Re: msf mysterious crash??
Post by: vbgamer45 on August 19, 2008, 11:15:29 PM
Try run to this query on your database using phpmyadmin

Repair TABLE smf_sessions;


Title: Re: msf mysterious crash??
Post by: whatiswhat on August 20, 2008, 11:17:54 AM
Thanks for the suggestion. Unfortunately I can not figure out how to do that. I cannot find "phpmyadmin" in the database?
I am rather ignorant when it comes to PHP.
can you be more specific?
Thanks...........
Title: Re: msf mysterious crash??
Post by: N3RVE on August 20, 2008, 11:30:41 AM
Welcome to SMF, whatiswhat ::)

You should open phpMyAdmin (What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)), click on the SQL tab and run that query.
If you can't find phpMyAdmin, contact your Host or check your hosting account for any other DMS that can be used to repair the crashed table.

Alternatively, we can do this with some script.

<?php
include_once('SSI.php');
global 
$db_prefix;

$adminsquirt db_query("REPAIR TABLE {$db_prefix}members",__FILE____LINE__);

?>



Create a new .php file, dump that code in, then point a browser to that file.

-[n3rve]
Title: Re: msf mysterious crash??
Post by: whatiswhat on August 20, 2008, 12:43:50 PM
Thaks again
I managed to get MySQL going on my hosting service and accessed phpmyadmin
I entered
Repair TABLE smf_sessions;
into the mySql quiry.

now the error is:

: File './smf/smf2_sessions.MYD' not found (Errcode: 13)
/phpbb/Sources/Load.php
2004

I R so confused. I am running two installs of msf on the same domain but isolated in different folders. Could this have caused a problem? They ran fine for several months before this problem happened. The file names are different ie msf and msf2. 
Title: Re: msf mysterious crash??
Post by: N3RVE on August 20, 2008, 01:17:38 PM
Drop the table by running
DROP TABLE `smf_sessions`

Then re-create it with

CREATE TABLE {$db_prefix}sessions (
  session_id char(32) NOT NULL,
  last_update int(10) unsigned NOT NULL,
  data text NOT NULL,
  PRIMARY KEY (session_id)
) TYPE=MyISAM;


Replace {db_prefix} with your prefix.

-[n3rve]
Title: Re: msf mysterious crash??
Post by: whatiswhat on August 20, 2008, 02:32:58 PM
OOps! That crashed mySQL database. Had to run yahoos repair utility. At this point Im thinking I don't really know what Im doing so perhaps deleting msf and reinstalling might be the best solution. I really didn't have that many subscribers anyway.  :(
Title: Re: msf mysterious crash??
Post by: N3RVE on August 21, 2008, 04:41:24 AM
Hello whatiswhat,

You're not doing something correctly. PM me with the forum link and access to phpMyAdmin.

-[n3rve]