Geeklog Forums

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.

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

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.

Well, something is certainly wrong with the groups and permissions. I'd suggest dropping the database and running the install script again.

bye, Dirk