Posted on: 02/12/06 02:54pm
By: Anonymous (nobese)
?t says
Warning: fopen(/home/birarada/public_html/nobese_files/logs/error.log): failed to open stream: Permission denied in /home/birarada/public_html/nobese/lib-common.php on line 1692
An SQL error has occurred. Please see error.log for detail
at line 1692 says=
if( !$file = fopen( $logfile, 'a' ))
what should ? do
thanks
An SQL error has occurred.
Posted on: 02/12/06 03:04pm
By: Dirk
Make sure the error.log file is writable (as explained in the installation instructions). Then try again and quote the SQL error message it logged there ...
bye, Dirk
An SQL error has occurred.
Posted on: 02/12/06 03:16pm
By: Anonymous (nobese)
[QUOTE BY= Dirk] Make sure the error.log file is writable (as explained in the installation instructions). Then try again and quote the SQL error message it logged there ...
bye, Dirk[/QUOTE]
hi
? dit it writable. ok
error.log says
Sun Feb 12 22:12:19 2006 - 1054: Unknown column 'deleted' in 'where clause'. SQL in question: SELECT status FROM gl_users WHERE uid=deleted
An SQL error has occurred.
Posted on: 02/12/06 03:28pm
By: Dirk
Hmm, that's a bit of an odd error. Not quite sure what causes it.
Try deleting your cookies, especially the "geeklog" cookie.
bye, Dirk
An SQL error has occurred.
Posted on: 02/12/06 03:31pm
By: Anonymous (nobese)
i think fount database
$sql = 'SELECT * FROM `gl_users` LIMIT 0, 30 '
but now?
An SQL error has occurred.
Posted on: 02/12/06 03:35pm
By: Dirk
Not sure what you mean. Try deleting your cookies, as I said above.
bye, Dirk
An SQL error has occurred.
Posted on: 02/12/06 04:18pm
By: Anonymous (nobese)
[QUOTE BY= Dirk] Not sure what you mean. Try deleting your cookies, as I said above.
bye, Dirk[/QUOTE]
there is no problem now, but ý couldn't understand
An SQL error has occurred.
Posted on: 02/28/06 09:27pm
By: filbert
I am encountering a similar problem upgrading to 1.4.0sr1 from 1.3.11sr1.
when I chmod 777 the log files I see the SQL error message:
Tue Feb 28 20:17:49 2006 - 1054: Unknown column 'header_tid' in 'where clause'. SQL in question: SELECT format, filename, title FROM gl_syndication WHERE (header_tid = 'all')
I've deleted cookies in both IE and Firefox and still get the SQL error. Have fallen back to the 1.3.11 for now.
Any ideas?
An SQL error has occurred.
Posted on: 02/28/06 09:30pm
By: filbert
Oh, geez, never mind, rtfm.
I see you need to go to 1.3.11sr3 first then to 1.4 . . . I'll give that a try.
An SQL error has occurred.
Posted on: 03/01/06 03:12pm
By: Dirk
[QUOTE BY= filbert] I see you need to go to 1.3.11sr3 first then to 1.4 . . . [/QUOTE]
Actually, you don't. You can jump from any 1.3.11 version right to 1.4.0sr1. Just make sure you really update all the files.
bye, Dirk
An SQL error has occurred.
Posted on: 03/01/06 04:39pm
By: Anonymous (Deirdre)
I'm getting a similar error when I try to post a comment on my board:
"An SQL error has occurred. Please see error.log for details."
I've have looked all over my error log, I've search the boards for it's location, and tried searching the documentation. It's probably a really newb question, I'm feeling like I really qualify as such.
I do appreciate any help, or maybe I'm searching for the wrong thing, a point in the right direction would make my day!
An SQL error has occurred.
Posted on: 03/01/06 04:45pm
By: filbert
Re: where the logs are--Look in the /gl/logs/ directory (where /gl/ is wherever you installed Geeklog to.
For me, it was missing the teensy little step of upgrading the SQL database.
I'll go off now and whimper silently to myself in the corner over there.
An SQL error has occurred.
Posted on: 03/01/06 04:51pm
By: Anonymous (Deirdre)
Thank you! Wow, if it had been a snake it would have bitten me!
Now I just have to figure out what it means...
Wed 01 Mar 2006 14:35:57 MST - 1044: Access denied for user: 'deirdrexxxx@%' to database 'deirdrexxxx'. SQL in question: LOCK TABLES gl_comments WRITE
I'm guessing it has something to do with the permissions, I will go investigate!
An SQL error has occurred.
Posted on: 03/01/06 04:59pm
By: Dirk
An SQL error has occurred.
Posted on: 03/06/06 10:55pm
By: Anonymous (Deirdre)
I tried to follow the directions from that link, but I can't get access to Lock the tables (yes, I'm thinking about a different hoster now)
When I tried this alternative:
2. Remove all the "LOCK TABLE" "UNLOCK TABLE" SQL calls from comment.php. This should be okay if you have a low traffice site, but opens up the possiblity of corruption if two or more users try to save or delete comments at the same time.
I couldn't find any SQL calls in my comment.php file. Could it possibly be in a different file? I have the latest version of Geeklog installed.
Thank you very much for your help!
An SQL error has occurred.
Posted on: 03/07/06 01:20pm
By: Dirk
The LOCK/UNLOCK statements are in system/lib-comment.php now. I've just updated the FAQ - sorry about that.
bye, Dirk
An SQL error has occurred.
Posted on: 03/07/06 01:39pm
By: Anonymous (Deirdre)
Thanks! Got it working now. Stupid GoDaddy...