Welcome to Geeklog, Anonymous Monday, December 23 2024 @ 12:59 am EST
Geeklog Forums
SQL Error on Login.
Status: offline
demon_llama
Forum User
Newbie
Registered: 12/06/03
Posts: 2
I managed to setup Geeklog on an Apache Server 1.3.27
, with MySQL4a and PHP4.2.3:
Each time I try and login through Geeklog as a superuser or otherwise I get this error
12/06/03 07:16:12 PM - 1064: You have an error in your SQL syntax 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 ()
Previously I had another error, however that is fixed, I have racked my brains and I have not a clue about what the problem is. I am conversant in SQL and PHP and I can't figure out what the prob is. Please help.
, with MySQL4a and PHP4.2.3:
Each time I try and login through Geeklog as a superuser or otherwise I get this error
12/06/03 07:16:12 PM - 1064: You have an error in your SQL syntax 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 ()
Previously I had another error, however that is fixed, I have racked my brains and I have not a clue about what the problem is. I am conversant in SQL and PHP and I can't figure out what the prob is. Please help.
11
12
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Did you change anything in the group permissions (or user's memberships in groups)? Every user should at least be a member of the "All Users" and "Logged-in Users" groups.
However, the "IN ()" in the above SQL request indicates that the user you tried to log in as is not a member of any group.
bye, Dirk
However, the "IN ()" in the above SQL request indicates that the user you tried to log in as is not a member of any group.
bye, Dirk
13
13
Quote
Status: offline
demon_llama
Forum User
Newbie
Registered: 12/06/03
Posts: 2
I havent altered anything in the database that was not gl_user table related. I also havent been able to log in to change any permissions of any kind.
11
12
Quote
All times are EST. The time is now 12:59 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