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
angelic
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?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Make sure your error.log is writable (refer to the installation instructions for details), then try again - and then quote the error message from error.log here.

bye, Dirk
 Quote

Korral

Anonymous
Thanks for the reply.

This file is empty i think is writable, im going to verify it.

Beste regards.
 Quote

Korral

Anonymous

A comment. This morning the page works and now not. I don´t change anything.

Thanks.
 Quote

Korral

Anonymous
I verify the security of the directory and the file, and its Ok.
I don´t know what´s happening
 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
 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 Confused

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
 Quote

Korral

Anonymous
Thank you very much.

But i can´t logon to the system.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Did you try to create a new account (register as a new user with your own site)?

bye, Dirk
 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
 Quote

Korral

Anonymous
You can see the error here.

Korral.net
 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
 Quote

ruwen

Anonymous
Hi!

I have the same error. An admin played around with the groups Sad

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?
 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