Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

cant find file gforum_Session.MYD

Quote Reply
cant find file gforum_Session.MYD
Hello all!

Something broke last night around midnight. Here is the error that I receive when I try to access my forum gforum.cgi:

A fatal error has occurred:
GT::Session::SQL (15428): Failed to execute query: 'DELETE FROM gforum_Session WHERE ( session_date < ? )' Reason: Can't open file: 'gforum_Session.MYD'. (errno: 145) at /home/sites/site30/web/cgi-bin/forum/admin/GT/Session/SQL.pm line 263.


Please enable debugging in setup for more details.




Here are the debugging details:

A fatal error has occurred:
GT::Session::SQL (15967): Failed to execute query: 'DELETE FROM gforum_Session WHERE ( session_date < ? )' Reason: Can't open file: 'gforum_Session.MYD'. (errno: 145) at /home/sites/site30/web/cgi-bin/forum/admin/GT/Session/SQL.pm line 263.


Please enable debugging in setup for more details.Stack Trace======================================GForum (15967): GT::Base::error called at /home/sites/site30/web/cgi-bin/forum/admin/GT/Session/SQL.pm line 263 with arguments (GT::Session::SQL=HASH(0x8203730), Failed to execute query: 'DELETE FROM gforum_Session WHERE ( session_date < ? )' Reason: Can't open file: 'gforum_Session.MYD'. (errno: 145)).GForum (15967): GT::Session::SQL::cleanup called at /home/sites/site30/web/cgi-bin/forum/admin/GForum/Authenticate.pm line 380 with arguments (GT::Session::SQL=HASH(0x8203730), 3600).GForum (15967): GForum::Authenticate::auth_valid_session called at /home/sites/site30/web/cgi-bin/forum/admin/GForum/Authenticate.pm line 39 with no arguments.GForum (15967): GForum::Authenticate::__ANON__ called at /home/sites/site30/web/cgi-bin/forum/admin/GT/Plugins.pm line 91 with no arguments.GForum (15967): GT::Plugins::dispatch called at /home/sites/site30/web/cgi-bin/forum/admin/GForum/Authenticate.pm line 39 with arguments (GT::Plugins, /home/sites/site30/web/cgi-bin/forum/admin/Plugins/GForum, auth_valid_session, CODE(0x8333a5c)).GForum (15967): GForum::Authenticate::auth called at /home/sites/site30/web/cgi-bin/forum/admin/GForum.pm line 523 with arguments (valid_session).GForum (15967): GForum::_plg_authenticate called at /home/sites/site30/web/cgi-bin/forum/admin/GT/Plugins.pm line 91 with no arguments.GForum (15967): GT::Plugins::dispatch called at /home/sites/site30/web/cgi-bin/forum/admin/GForum.pm line 486 with arguments (GT::Plugins, /home/sites/site30/web/cgi-bin/forum/admin/Plugins/GForum, authenticate, CODE(0x826ab98)).GForum (15967): GForum::authenticate called at /home/sites/site30/web/cgi-bin/forum/gforum.cgi line 53 with no arguments.GForum (15967): main::main called at /home/sites/site30/web/cgi-bin/forum/admin/GT/Plugins.pm line 91 with no arguments.GForum (15967): GT::Plugins::dispatch called at /home/sites/site30/web/cgi-bin/forum/gforum.cgi line 22 with arguments (GT::Plugins, /home/sites/site30/web/cgi-bin/forum/admin/Plugins/GForum, main, CODE(0x82e2ad4)).System Information======================================Perl Version: v5.00503Gossamer Forum Version: 1.1.8GForum.pm version: 1.118GT::SQL Version: 1.099GT::Template Version: 2.084DBI.pm Version: 1.14@INC = /home/sites/site30/web/cgi-bin/forum/admin /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 .GT::SQL::error = Failed to execute query: 'DELETE FROM gforum_Session WHERE ( session_date < ? )' Reason: Can't open file: 'gforum_Session.MYD'. (errno: 145)CGI Cookies======================================gforum_1006370746_remember => 62290637c2664a86426ef6f0c7a7a521ENVIRONMENT======================================DOCUMENT_ROOT => /home/sites/site30/webGATEWAY_INTERFACE => CGI/1.1GT_TMPDIR => /home/sites/site30/web/cgi-bin/forum/admin/tmpHTTP_ACCEPT => */*HTTP_ACCEPT_ENCODING => gzip, deflateHTTP_ACCEPT_LANGUAGE => en-usHTTP_CACHE_CONTROL => max-stale=0HTTP_COOKIE => gforum_1006370746_remember=62290637c2664a86426ef6f0c7a7a521HTTP_HOST => www.investingdd.comHTTP_REFERER => http://www.investingdd.comHTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)PATH => /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/binPATH_INFO => /cgi-bin/forum/gforum.cgiPATH_TRANSLATED => /home/sites/site30/web/cgi-bin/forum/gforum.cgiQUERY_STRING => REDIRECT_SCRIPT_URI => httGT::Session::SQL (15967): Failed to execute query: 'DELETE FROM gforum_Session WHERE ( session_date < ? )' Reason: Can't open file: 'gforum_Session.MYD'. (errno: 145) at /home/sites/site30/web/cgi-bin/forum/admin/GT/Session/SQL.pm line 263.p://www.investingdd.com/cgi-bin/forum/gforum.cgiREDIRECT_SCRIPT_URL => /cgi-bin/forum/gforum.cgiREDIRECT_STATUS => 200REDIRECT_UNIQUE_ID => PWOYokF7GUwAAALZWZEREDIRECT_URL => /cgi-bin/forum/gforum.cgiREMOTE_ADDR => 140.32.16.100REMOTE_PORT => 40949REQUEST_METHOD => GETREQUEST_URI => /cgi-bin/forum/gforum.cgiSCRIPT_FILENAME => /usr/cgiwrap/cgiwrapSCRIPT_NAME => /cgi-bin/forum/gforum.cgiSCRIPT_URI => http://www.investingdd.com/cgi-bin/forum/gforum.cgiSCRIPT_URL => /cgi-bin/forum/gforum.cgiSERVER_ADDR => 65.123.25.76SERVER_ADMIN => adminSERVER_NAME => www.investingdd.comSERVER_PORT => 80SERVER_PROTOCOL => HTTP/1.0SERVER_SIGNATURE => SERVER_SOFTWARE => Apache/1.3.20 Sun Cobalt (Unix) mod_ssl/2.8.4 OpenSSL/0.9.6b PHP/4.1.2 mod_auth_pam_external/0.1 FrontPage/4.0.4.3 mod_perl/1.25UNIQUE_ID => PWOYokF7GUwAAALZWZE
Quote Reply
Re: [shiner] cant find file gforum_Session.MYD In reply to
If you have telnet or ssh access (for future reference) you can login and enter:

perror error_number

...to find the cause of the error. So in this case:

perror 145

Error code 145: Unknown error 145
145 = Table was marked as crashed and should be repaired

There are a couple of things you can do. First using mysqlman, in the SQL monitor enter:

REPAIR TABLE gforum_Session

This is the same as:

myisamchk -r table_name

Alternatively you may need a more thorough repair. You can view your options by typing the following from telnet/ssh:

myisamchk --help

Last edited by:

PerlPod: Aug 21, 2002, 7:48 AM
Quote Reply
Re: [PerlPod] cant find file gforum_Session.MYD In reply to
PerlPod ~ THANKS!!!!

REPAIR TABLE gforum_Session worked like a charm. How does something like that happen in the first place? I consider myself pretty fortunate that the session table was the only one effected. I am back online again - thanks!
Quote Reply
Re: [shiner] cant find file gforum_Session.MYD In reply to
This may help:

http://www.mysql.com/...d_MyISAM_tables.html