Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 10:03 pm EST

Geeklog Forums

SQL errors all over the place


Status: offline

Don

Forum User
Full Member
Registered: 06/09/04
Posts: 153
I don't know what the heck happened, but any time I click on Stories, Topics, or just about any link in the Admin error, I get this:

An SQL error has occurred. Please see error.log for details.

Nothing is showing up in error.log (yes, it's writable), although I was getting an error in the gl_stories table, and ran a repair.

Now the database is reading okay, but I'm still getting the SQL error on my home page and the home page will not come up.

I have no idea what is going on, and I'm trying to reproduce what caused the error, if I can get my site started back up.

Can anyone point me to something obvious? I gotta get to bed, but I don't want to leave the site down.

On Edit: I restored the database from the latest backup, ran a check on the database and got this error:

myisamchk:error: Size of index file is: 123904
Should be: 135168


What does this mean, and why is it causing SQL errors all over the place?

- D
 Quote

ironmax

Anonymous
What is the url to your site?
 Quote

Status: offline

Don

Forum User
Full Member
Registered: 06/09/04
Posts: 153
Blah3.com.

I currently have the site disabled while I try to figure this out.

- D

 Quote

ironmax

Anonymous
It seems to be working fine now. Although I did not post to any forum groups, everything looked okay to me...no errors from my view point.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Don: An SQL error has occurred. Please see error.log for details.

Nothing is showing up in error.log (yes, it's writable)

Also check the directory it's in.

bye, Dirk
 Quote

All times are EST. The time is now 10:03 pm.

  • 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