msf mysterious crash??

Started by whatiswhat, August 19, 2008, 10:49:01 PM

Previous topic - Next topic

whatiswhat

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: hxxp:www.painbrain.com/forum/ [nonactive]

Hopefully somebody can tell me what happened.

vbgamer45

Try run to this query on your database using phpmyadmin

Repair TABLE smf_sessions;


Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

whatiswhat

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...........

N3RVE

Welcome to SMF, whatiswhat ::)

You should open phpMyAdmin (What is phpMyAdmin?), 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]
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

whatiswhat

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. 

N3RVE

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]
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

whatiswhat

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.  :(

N3RVE

Hello whatiswhat,

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

-[n3rve]
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

Advertisement: