Status: offline

lguhr

Forum User
Newbie
Registered: 07/09/03
Posts: 3
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

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
That's a known bug with MySQL 5 (the last of those, hopefully) and has already been fixed in CVS.

bye, Dirk