Geeklog Forums

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

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

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

Would reinstalling File Management fix my problem??

---

Bla bla bla

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