Hi
I get the following error when I try to show a list of all user in a group.
Text Formatted Code
tis 21 mar 2006 18.17.17 - 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 (4,1)) ORDER BY username asc ;
I tried to do the same on the Demo Site and it works.
Any ideas?
Maybe related to
this?
-----------------------
THX / LG
I'm running GL 1.4.0sr2 on Apache 2.0.54 with PHP 5.0.4 and MySQL 5.0.16-standard