The secure CMS.

Welcome to Geeklog, Anonymous Saturday, December 28 2024 @ 03:03 am EST

Geeklog Forums

SQL Error Help

 New Topic  Post Reply
 08/23/06 09:10am (Read 1,283 times)  

Matt

Anonymous
working
I tried accessing my site and got this message: An SQL error has occured. Please see error.log for details

Here is some of the error log....
Text Formatted Code
Wed Aug 23 06:00:04 2006 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '199.21.28.14' AND uid = 1
Wed Aug 23 06:00:08 2006 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '64.46.248.8' AND uid = 1
Wed Aug 23 06:03:47 2006 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '192.132.64.2' AND uid = 1
Wed Aug 23 06:05:16 2006 - 1016: Can't open file: 'gl_sessions.MYI' (errno: 145). SQL in question: DELETE FROM gl_sessions WHERE remote_ip = '72.30.132.11' AND uid = 1
 


Any ideas? I've tried repairing the gl_sessions table with no luck as well as emptying gl_sessions.
 Quote
 08/23/06 01:54pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Matt: I've tried repairing the gl_sessions table with no luck

Hmm, that should usually solve the problem. What happened when you tried?

If nothing else helps, you could drop the table and recreate it (table definition is in sql/mysql_tableanddata.php).

bye, Dirk
 Quote
 New Topic  Post Reply
All times are EST. The time is now 03:03 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