Welcome to Geeklog, Anonymous Friday, April 19 2024 @ 04:49 pm EDT

Geeklog Forums

SQL Error on Login


Status: offline

bedathur

Forum User
Newbie
Registered: 11/30/03
Posts: 12
curious
I am getting the following error every few visits to my site (rather, authenitcated visits):

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

And I see the following entry in error.log:


Wed Apr 26 10:41:28 2006 - 1030: Got error 12 from table handler. SQL in question: SELECT DISTINCT gl_sessions.uid,
username,photo FROM gl_sessions,gl_users WHERE
gl_users.uid = gl_sessions.uid AND start_time >=
1146065788 AND gl_sessions.uid 1 ORDER BY username


The problem seems to go away on its own a while later! Wondering if somebody could tell me what this is all about!

Thanks!
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Try a Google search for "Got error 12 from table handler". That seems to be a server setup issue and you should talk to your hosting service about it.

bye, Dirk
 Quote

Status: offline

rrangell

Forum User
Newbie
Registered: 04/07/06
Posts: 1
I got almost exactly the same error today. It has not gone away. I run Geeklog on my Mac laptop as a way to keep my thoughts in order - no one else uses it. And I love it.

The error showed up immediately after I allowed the system to update the java engine to J2SE 5.0 release 4. I am running Mac OS X 10.4.6.

I get the following on the webpage:
Warning: fopen(/Library/Apache2/htdocs/geeklog/logs/error.log): failed to open stream: Permission denied in /Library/Apache2/htdocs/geeklog/public_docs/lib-common.php on line 1702
An SQL error has occurred. Please see error.log for details.

My error log only has a dummy entry, and the console log contains nothing that seems relevant at all.

I am really bummed! Thought to look here to see if anyone else is having problems. It seems that bedathur is seeing a similar thing. Are you, bedathur, runnin on a mac? Did you recently update anything?

I can also get to the geeklog database via phpmyadmin, and other web aps that I run are okay. Any thoughts?

Thanks!
Bob
 Quote

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