Welcome to Geeklog, Anonymous Monday, December 23 2024 @ 09:15 am EST
Geeklog Forums
SQL Error when listing group members
Status: offline
Chump
Forum User
Newbie
Registered: 03/10/05
Posts: 4
Error is such: 1054: Unknown column 'gl_users.uid' in 'on clause'. SQL in question: SELECT DISTINCT gl_users.uid,username,fullname,email,photo,regdate,lastlogin FROM gl_users,gl_group_assignments LEFT JOIN gl_userinfo ON gl_users.uid=gl_userinfo.uid WHERE gl_users.uid > 1 AND gl_users.uid = gl_group_assignments.ug_uid AND (gl_group_assignments.ug_main_grp_id IN (31,1)) ORDER BY username asc
Any ideas?
Chump
Any ideas?
Chump
11
9
Quote
All times are EST. The time is now 09:15 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