Geeklog Forums

I've searched these forums up and down... I see lots of similar problems, but none of the fixes ive tried seem to work...

I have the typical SQL error, see error.log for details

and then

Mon 17 Sep 2007 21:49:25 GMT+4 - 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 ()

I know its a problem with my user groups...

All group list provide results except for logged in users and all users (from the admin > group manager > memberlists)

Any ideas what changes I need to make to my gl_group_assignments table?

Or is the solution something completely different?

Thanks so much for everyones help!!!

Have you looked at this topic? Near the end you will see a small script you can create on your site that should get you going again.

Thanks!
Mark

mevans , Thank you for your help, but I'm still having problems - after editing, uploading, and running that script, i get the following error:

Parse error: syntax error, unexpected T_VARIABLE in /home/downtown/public_html/fixdb.php on line 14

Any other ideas?

Make sure you read the post following my code, there was a small error that is documented. If you are still having problems, cut and paste your fixdb.php here (place it between [ code ] blocks so it will format properly and we'll find the error.

lol, please don't think of me as a php moron...

the quote was For those who want to use that last code snippet be sure to move
the semicolon outside the double quotes on line 14 ($sql = ...)

the line is





semicolon = ; is currently outside of ($sql=)

Where am I going wrong???

Well, it is actually the line before that one that is wrong. Here is the corrected version:



Give this one a try and let's see if it works a little better.

Thanks!
Mark

the script ran just fin, but when I go to my group manager and try to list both the "all users" member list and the "logged in users" member list, I get a page cannot be displayed error....

The list shows me (admin) for all other group lists...

For reference:

all users = grp_id=2
logged in users = grp_id=13

I would recommend looking at your Geeklog error.log and possibly your web servers error log for clues.

I'm not sure what else to tell you without a little more info.

Thanks!
Mark

Well, I apparently haven't had the issue since I ran the script (not showing up on the error log) So thanks so much mevans!!!!!