Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 07:30 pm EST

Geeklog Forums

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


Alex

Anonymous
Hi, I am getting the following error An SQL error has occured. Please see error.log for details.

Here is what the error log reads:

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 ()

Do I have a corrupt table or is something else going on? Any help would be great. The last function that was performed was the admin user was giving admin rights to a story to a user while the user was logged on.

Thanks
Alex
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The error message means that the user is not a member of any group - which shouldn't happen, as every registered user is at least a member of the All Users and Logged-In Users groups.

See if you can log in as a (User) Admin and fix that user's group membership.

bye, Dirk
 Quote

Status: offline

nobese

Forum User
Chatty
Registered: 01/20/06
Posts: 44
my situation is the sameSad

but i couldnt to enter as an admin to my geelog site

how can i solve that problem using mysql database

i think if i can undo last operation from the access its solve easly



thamnks






Quote by Dirk: The error message means that the user is not a member of any group - which shouldn't happen, as every registered user is at least a member of the All Users and Logged-In Users groups.

See if you can log in as a (User) Admin and fix that user's group membership.

bye, Dirk
 Quote

All times are EST. The time is now 07:30 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