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.
Try run to this query on your database using phpmyadmin
Repair TABLE smf_sessions;
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...........
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]
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.
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]
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. :(
Hello whatiswhat,
You're not doing something correctly. PM me with the forum link and access to phpMyAdmin.
-[n3rve]