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

[nobody]

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

Changes by: Mathieu Roy <address@hidden>
Date: Wed 05/07/03 at 22:30 (Europe/Paris)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | babar




=================== BUG #3510: FULL BUG SNAPSHOT ===================


Submitted by: mmb                     Project: Savannah                     
Submitted on: Wed 05/07/03 at 19:42
Category:  PHP Engine                 Severity:  5 - Average                
Priority:  None                       Bug Group:  None                      
Resolution:  None                     Assigned to:  babar                   
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