Welcome to Geeklog, Anonymous Thursday, December 26 2024 @ 09:41 am EST
Geeklog Forums
Help. Home page error. An SQL error has ocurred
Korral
Anonymous
Hi to all.
Sorry for my english. i´m from spain.
Today mi home page look that this:
Warning: fopen(/home/juanjoc/public_html/system/logs/error.log): failed to open stream: Permiso denegado in /home/juanjoc/public_html/lib-common.php on line 1702
An SQL error has occurred. Please see error.log for details.
Can anybody help me?
Sorry for my english. i´m from spain.
Today mi home page look that this:
Warning: fopen(/home/juanjoc/public_html/system/logs/error.log): failed to open stream: Permiso denegado in /home/juanjoc/public_html/lib-common.php on line 1702
An SQL error has occurred. Please see error.log for details.
Can anybody help me?
15
7
Quote
Korral
Anonymous
Thanks for the reply.
This file is empty i think is writable, im going to verify it.
Beste regards.
This file is empty i think is writable, im going to verify it.
Beste regards.
16
9
Quote
Korral
Anonymous
A comment. This morning the page works and now not. I don´t change anything.
Thanks.
11
9
Quote
Korral
Anonymous
I verify the security of the directory and the file, and its Ok.
I don´t know what´s happening
I don´t know what´s happening
13
11
Quote
Korral
Anonymous
Sorry
I permit write access to error.log and get this error
Please for help me.
ERROR:
mar 11 abr 2006 00:03:44 CEST - 1064: 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. SQL in question: SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN ()
The version of MYSQL is : 4.0.25-standard.
My isp changed the version and now not work?
Thank you
11
11
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
I wish I knew why some people seem to run into this problem
Did you edit any users or groups before that happened? The error basically means that the current user is not a member of any groups. But in Geeklog, every (registered) user has to be at least in the two groups "All Users" and "Logged-in Users".
See if you can log in as another user (register a new account if necessary). If that works, you can upgrade that second account to a root account and maybe use it to fix the original account.
HTH
bye, Dirk
Did you edit any users or groups before that happened? The error basically means that the current user is not a member of any groups. But in Geeklog, every (registered) user has to be at least in the two groups "All Users" and "Logged-in Users".
See if you can log in as another user (register a new account if necessary). If that works, you can upgrade that second account to a root account and maybe use it to fix the original account.
HTH
bye, Dirk
12
10
Quote
Korral
Anonymous
Thank you very much.
But i can´t logon to the system.
But i can´t logon to the system.
11
13
Quote
Korral
Anonymous
Thanks for your answer.
I have explained myself badly. It always leaves the message error (An SQL error has occurred. Please see error.log for details) I can´t access anything. I do not see anything absoltully when I connect myself to the Web (only the SQL error). I Can´t do login, and i can´t create users.
Best regards
I have explained myself badly. It always leaves the message error (An SQL error has occurred. Please see error.log for details) I can´t access anything. I do not see anything absoltully when I connect myself to the Web (only the SQL error). I Can´t do login, and i can´t create users.
Best regards
10
17
Quote
Korral
Anonymous
12
10
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Okay, if everybody gets that error, then it looks like a problem with the database. A backup would come in handy at this point ...
There may be a way to fix this issue with some carefully selected SQL requests, but I don't exactly have the patience to put those together now. Restoring a backup would be safer anyway.
bye, Dirk
There may be a way to fix this issue with some carefully selected SQL requests, but I don't exactly have the patience to put those together now. Restoring a backup would be safer anyway.
bye, Dirk
12
10
Quote
ruwen
Anonymous
Hi!
I have the same error. An admin played around with the groups
I cant login/register with anybody.
I took a loke into the database and i found that I am in the groups 2 (All Users) and 13 (Logged-In).
But I always get the same error. Any Ideas?
I have the same error. An admin played around with the groups
I cant login/register with anybody.
I took a loke into the database and i found that I am in the groups 2 (All Users) and 13 (Logged-In).
But I always get the same error. Any Ideas?
12
10
Quote
All times are EST. The time is now 09:41 am.
- 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