Welcome to Geeklog, Anonymous Friday, March 29 2024 @ 04:33 am EDT

Geeklog Forums

SQL problem of some sort.


Status: offline

ShdwRulr

Forum User
Regular Poster
Registered: 09/13/03
Posts: 78
My geeklog told me to check my error.log file. I got this when I checked the error.log file.

Fri Jan 16 21:09:12 2004 - 1016: Can't open file: 'gl_filemgmt_filedetail.MYI'. (errno: 145). SQL in question: SELECT COUNT(*) FROM gl_filemgmt_filedetail WHERE status=0

What on earth does that mean?
Bla bla bla
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
That doesn't look good ... Effectively it says that MySQL is missing one of its files.

You may want to contact your hosting service.

Otherwise, have your backup ready before you try to repair said table from phpMyAdmin (try "analyze table" first).

bye, Dirk
 Quote

Status: offline

ShdwRulr

Forum User
Regular Poster
Registered: 09/13/03
Posts: 78
Then I went to MySQL and did an "Analyze Table" and I got this.
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1.

So, what do I need to do to fix my problem?

Also, I dont have a backup.
Bla bla bla
 Quote

Status: offline

ShdwRulr

Forum User
Regular Poster
Registered: 09/13/03
Posts: 78
Would reinstalling File Management fix my problem??
Bla bla bla
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
As I said above, somehow one of MySQL's files has been deleted. This is not something that can happen due to a bug or some other problem in Geeklog. It may have been due to a problem with the file system or the file has been deleted by some other means.

I'd suggest contacting your hosting service or, if it's your own server, to run a file system check. Also, I wouldn't trust the database too much any more and would reinstall it from a backup.

bye, Dirk
 Quote

All times are EDT. The time is now 04:33 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