The secure CMS.

Welcome to Geeklog, Anonymous Saturday, November 23 2024 @ 07:38 am EST

Geeklog Forums

Unknown column 'gl_users.uid' in 'on clause'. SQL

 New Topic  Post Reply
 03/21/06 12:50pm (Read 1,863 times)  
Status: offline

lguhr

Forum User
Newbie
Registered: 07/09/03
Posts: 3
Location:Sweden
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
 Quote
 03/21/06 06:15pm  
Status: offline

Dirk

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

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