The secure CMS.

Welcome to Geeklog, Anonymous Thursday, April 25 2024 @ 04:03 pm EDT

Geeklog Forums

SQL Error when listing group members

 New Topic  Post Reply
 11/09/06 08:24am (Read 1,348 times)  
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
 Quote
 11/09/06 03:10pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
As usual, it's a good idea to try a search for the error message first ...

bye, Dirk
 Quote
 New Topic  Post Reply
All times are EDT. The time is now 04:03 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