savannah-hackers-public
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Savannah-hackers-public] [task #12764] Reproducible SQL query error on


From: Josh Triplett
Subject: [Savannah-hackers-public] [task #12764] Reproducible SQL query error on all issue/task/bug trackers when removing sort column
Date: Sun, 11 Aug 2013 07:11:54 +0000
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:23.0) Gecko/20100101 Firefox/23.0 Iceweasel/23.0

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/




reply via email to

[Prev in Thread] Current Thread [Next in Thread]