Posted on: 04/26/06 11:53am
By: bedathur
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!
SQL Error on Login
Posted on: 04/26/06 02:14pm
By: Dirk
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
SQL Error on Login
Posted on: 04/26/06 09:08pm
By: rrangell
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