Advertisement:

Author Topic: msf mysterious crash??  (Read 2869 times)

Offline whatiswhat

  • Newbie
  • *
  • Posts: 9
msf mysterious crash??
« 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: hxxp:www.painbrain.com/forum/ [nonactive]

Hopefully somebody can tell me what happened.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,628
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: msf mysterious crash??
« Reply #1 on: August 19, 2008, 11:15:29 PM »
Try run to this query on your database using phpmyadmin
Code: [Select]
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

Offline whatiswhat

  • Newbie
  • *
  • Posts: 9
Re: msf mysterious crash??
« Reply #2 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...........

Offline N3RVE

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,907
  • Gender: Male
    • N3RVE.COM
Re: msf mysterious crash??
« Reply #3 on: August 20, 2008, 11:30:41 AM »
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.
Code: [Select]
<?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

Offline whatiswhat

  • Newbie
  • *
  • Posts: 9
Re: msf mysterious crash??
« Reply #4 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. 

Offline N3RVE

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,907
  • Gender: Male
    • N3RVE.COM
Re: msf mysterious crash??
« Reply #5 on: August 20, 2008, 01:17:38 PM »
Drop the table by running
Code: [Select]
DROP TABLE `smf_sessions`
Then re-create it with
Code: [Select]
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

Offline whatiswhat

  • Newbie
  • *
  • Posts: 9
Re: msf mysterious crash??
« Reply #6 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.  :(

Offline N3RVE

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,907
  • Gender: Male
    • N3RVE.COM
Re: msf mysterious crash??
« Reply #7 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]
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