taskSavannah Administration - Tasks: task #12764, Reproducible SQL query error on...

 
 

task #12764: Reproducible SQL query error on all issue/task/bug trackers when removing sort column

Submitter:  Josh Triplett <joshtriplett>
Submitted:  Sun 11 Aug 2013 07:11:53 AM UTC
   
 
Should Start On:  Sat 10 Aug 2013 07:00:00 AM UTC Should be Finished on:  Sat 10 Aug 2013 07:00:00 AM UTC
Category:  System Priority:  * 7 - High
Status:  Need Info Privacy:  Public
Assigned to:  agn Open/Closed:  Closed
* Mandatory Fields

Add a New Comment Rich Markup
   

Wed 27 Aug 2014 09:16:03 PM UTC, comment #2: 

Hello John,

I am closing this task due to inactivity.
If this is still an issue, please reply and it will be re-opened.

Regards,
 - Assaf

Assaf Gordon <agn>
Site Administrator
Tue 12 Aug 2014 12:58:44 AM UTC, comment #1: 

Hello,
I'm reviewing old tasks in GNU Savannah.

As of August 2014, I was not able to reproduce the error with the steps listed in this task.

Are you still experiencing these issues?
If within two weeks I still do not get a reply, I will close this
request.

Regards,
- Assaf

Assaf Gordon <agn>
Site Administrator
Sun 11 Aug 2013 07:11:53 AM UTC, original submission:  

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]

Josh Triplett <joshtriplett>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by agn (Posted a comment)
  • -email is unavailable- added by joshtriplett (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 4 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2014-08-27 agn StatusWait reply Need Info
        Open/ClosedOpen Closed
    2014-08-12 agn StatusNone Wait reply
        Assigned toNone agn

    Back to the top

    Powered by Savane 3.13-f8d8.
    Corresponding source code