The Ultimate Weblog System

Welcome to Geeklog
Tuesday, February 09 2010 @ 06:31 PM EST


 Forum Index > Support > Installation New Topic Post Reply
 DB Corrupted?
 |  Printable Version
etegration
 June 24 2006 04:34 AM (Read 1789 times)  
Forum Full Member
Full Member

Status: offline

Registered: 02/20/02
Posts: 179

I suddenly had this "An SQL error has occurred. Please see error.log for details." and as usual visited the logs and saw...

06/22/06 20:08:19 - 1034: Incorrect key file for table 'gl_sessions'; try to repair it. SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '66.249.65.42' AND uid = 1
06/22/06 20:08:20 - 1034: Incorrect key file for table 'gl_sessions'; try to repair it. SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '66.249.65.42' AND uid = 1
06/22/06 20:32:08 - 1034: Incorrect key file for table 'gl_sessions'; try to repair it. SQL in question: DELETE FROM gl_sessions WHERE uid = 1 AND start_time
06/22/06 20:32:11 - 1034: Incorrect key file for table 'gl_sessions'; try to repair it. SQL in question: DELETE FROM gl_sessions WHERE uid = 1 AND start_time
06/22/06 21:53:08 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '66.249.65.42' AND uid = 1
06/22/06 21:53:25 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '66.249.65.42' AND uid = 1
06/22/06 21:59:58 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '66.249.65.42' AND uid = 1
06/22/06 22:00:01 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '66.249.65.42' AND uid = 1
06/22/06 22:00:02 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '66.249.65.42' AND uid = 1
06/22/06 22:00:03 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '66.249.65.42' AND uid = 1

then it's more or less the same after 22nd june...what can i do to resolved this? restore the db? anyway to repair it?


http://www.etegration.com.sg http://www.itcow.com http://www.ministryofhosting.com
 
Profile Email Website PM
Quote
Dirk
 June 24 2006 07:36 AM  
Forum Admin
Admin

Status: offline

Registered: 01/12/02
Posts: 12492

As the error message itself(!) already suggested: Try to repair the table. It's an option in phpMyAdmin, if you have access to that. Or find some other way to execute this SQL request:

PHP Formatted Code
REPAIR TABLE gl_sessions;
 

bye, Dirk

P.S. Greetings from FrOSCon


 
Profile Email Website PM
Quote
etegration
 June 24 2006 23:57 PM  
Forum Full Member
Full Member

Status: offline

Registered: 02/20/02
Posts: 179

Quote by Dirk: As the error message itself(!) already suggested: Try to repair the table. It's an option in phpMyAdmin, if you have access to that. Or find some other way to execute this SQL request:
PHP Formatted Code
REPAIR TABLE gl_sessions;

 

bye, Dirk

P.S. Greetings from FrOSCon


Thanks a bunch! it worked! Take care in Germany.


http://www.etegration.com.sg http://www.itcow.com http://www.ministryofhosting.com
 
Profile Email Website PM
Quote
Content generated in: 0.77 seconds
New Topic Post Reply



 All times are EST. The time is now 06:31 PM.
Normal Topic Normal Topic
Locked Topic Locked Topic
Sticky Topic Sticky Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Able to post 
Filtered HTML Allowed 
Censored Content