URL:
<http://savannah.gnu.org/task/?12764>
Summary: Reproducible SQL query error on all issue/task/bug
trackers when removing sort column
Project: Savannah Administration
Submitted by: joshtriplett
Submitted on: Sun 11 Aug 2013 12:11:53 AM PDT
Should Start On: Sat 10 Aug 2013 12:00:00 AM PDT
Should be Finished on: Sat 10 Aug 2013 12:00:00 AM PDT
Category: System
Priority: 7 - High
Status: None
Privacy: Public
Percent Complete: 0%
Assigned to: None
Open/Closed: Open
Discussion Lock: Any
Effort: 0.00
_______________________________________________________
Details:
The following procedure will trigger an SQL query error on all issue/task/bug
tracker pages:
Open "Display Criteria", and change the query form to "Advanced". That will
display the "Submitted By" column.
Click on the "Submitted By" column heading to sort by it.
Open "Display Criteria", and change the query form to "Basic". That will hide
the "Submitted By" column.
You'll now get an SQL error page similar to the following:
db_query: SQL query error Unknown column 'user_submitted_by.user_name' in
'order clause' in [SELECT DISTINCT
bugs.group_id,bugs.priority,bugs.privacy,bugs.status_id,bugs.submitted_by
,bugs.bug_id,bugs.summary,bugs.resolution_id,user_assigned_to.user_name AS
assigned_to,bugs.date FROM bugs ,user user_assigned_to WHERE
bugs.group_id='68' AND (bugs.spamscore < 5 OR submitted_by='61092') AND
user_assigned_to.user_id=bugs.assigned_to ORDER BY user_submitted_by.user_name
ASC LIMIT 0,50]
_______________________________________________________
Reply to this item at:
<http://savannah.gnu.org/task/?12764>
_______________________________________________
Message sent via/by Savannah
http://savannah.gnu.org/
