[sr #110262] db_query error on trackers when filtering by a text column

[Mike Miller]

URL:
  <https://savannah.nongnu.org/support/?110262>

                 Summary: db_query error on trackers when filtering by a text
column
                 Project: Savannah Administration
            Submitted by: mtmiller
            Submitted on: Fri 10 Jul 2020 02:27:38 PM PDT
                Category: Savannah trackers - bugs, tasks, etc.
                Priority: 5 - Normal
                Severity: 3 - Normal
                  Status: None
             Assigned to: None
        Originator Email: 
        Operating System: GNU/Linux
             Open/Closed: Open
         Discussion Lock: Any

    _______________________________________________________

Details:

After some recent change, I now get a db_query error from any tracker when
filtering by a text column in the "Display Criteria". It appears like the text
pattern is accidentally duplicated in the query string. For example, going to
this Administration support tracker, switching to the Advanced query form, and
entering "asdf" in the Summary field, gives this error message:


db_query: SQL query error Unknown column 'asdf' in 'where clause' in [SELECT
count(DISTINCT support.bug_id) AS count FROM user user_assigned_to, support
WHERE support.group_id='5802' AND (support.spamscore < 5 OR
submitted_by='80942') AND support.status_id IN ('1') AND (asdf AND summary
LIKE '%asdf%') AND user_assigned_to.user_id=support.assigned_to ]


The important bit is this part of the query


… AND (asdf AND summary LIKE '%asdf%') AND …





    _______________________________________________________

Reply to this item at:

  <https://savannah.nongnu.org/support/?110262>

_______________________________________________
  Message sent via Savannah
  https://savannah.nongnu.org/