Welcome to Geeklog Wednesday, August 12 2020 @ 09:35 am EDT

Geeklog Forums

DB Corrupted?


Status: offline

etegration

Forum User
Full Member
Registered: 20/02/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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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 Cool
 Quote

Status: offline

etegration

Forum User
Full Member
Registered: 20/02/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 Cool


Thanks a bunch! it worked! Take care in Germany.
http://www.etegration.com.sg http://www.itcow.com http://www.ministryofhosting.com
 Quote

All times are EDT. The time is now 09:35 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content