[Savannah-dev] [Bug #3510] Typo in SQL query in frontend/php/admin/userlist.php

[nobody]

=================== BUG #3510: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3510&group_id=11

Submitted by: mmb                     Project: Savannah                     
Submitted on: Wed 05/07/2003 at 12:42
Category:  PHP Engine                 Severity:  5 - Average                
Priority:  None                       Bug Group:  None                      
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Effort:  0.00                         

Summary:  Typo in SQL query in frontend/php/admin/userlist.php

Original Submission:  There are an extra ',' and a missing space in the query 
string, so the sql query  is silently failing and no user list is shown.

In frontend/php/admin/userlist.php

The query has be changed from:
$result = db_query("SELECT user.user_id AS user_id, user.user_name AS 
user_name, user.status AS status, ,user.people_view_skills AS 
people_view_skills"
. "FROM user,user_group "
. "WHERE user.user_id=user_group.user_id AND "
. "user_group.group_id=$group_id ORDER BY user.user_name");

to:
$result = db_query("SELECT user.user_id AS user_id, user.user_name AS 
user_name, user.status AS status, "               ."user.people_view_skills AS 
people_view_skills "               . "FROM user,user_group "
. "WHERE user.user_id=user_group.user_id AND "
. "user_group.group_id=$group_id ORDER BY user.user_name");

Marco



No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3510&group_id=11