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/
