310531 - Time Since Assignee Touched boolean chart causes SQL error

Status: RESOLVED DUPLICATE of bug 282702

(Bugzilla :: Query/Bug List, defect)

Description

[A. Karl Kornel]

User-Agent:       Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en-US) AppleWebKit/125.4 (KHTML, like Gecko, Safari) OmniWeb/v563.57
Build Identifier: 

When using the "Time Since Assignee Touched" "is equal to" boolean chart, an SQL error is triggered 
when the search takes place.

Reproducible: Always

Steps to Reproduce:
1. In an installation using the latest CVS version of Bugzilla, create a search that includes the following 
boolean chart: "Time Since Assignee Touched" "is equal to" "5"
2. Run the search
Actual Results:  
The search should have shown all bugs that, among other things, match the boolean query.  If the 
query is invalid, an error should have appeared explicitly telling me so.

Expected Results:  
The following software error was reported:

DBD::mysql::st execute failed: Unknown column 'bugs.owner_idle_time' in 'where clause' [for Statement 
"SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, 
map_products.name, bugs.bug_severity, bugs.priority, bugs.rep_platform, 
map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc FROM bugs  INNER 
JOIN profiles AS map_assigned_to ON (bugs.assigned_to = map_assigned_to.userid) INNER JOIN 
products AS map_products ON (bugs.product_id = map_products.id) LEFT JOIN bug_group_map  ON 
bug_group_map.bug_id = bugs.bug_id  AND bug_group_map.group_id NOT IN (6,14,13,7)  LEFT JOIN 
cc ON cc.bug_id = bugs.bug_id AND cc.who = 10711 WHERE ((bugs.owner_idle_time = '5')) AND 
bugs.creation_ts IS NOT NULL AND ((bug_group_map.group_id IS NULL)    OR (bugs.reporter_accessible 
= 1 AND bugs.reporter = 10711)     OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL)     OR 
(bugs.assigned_to = 10711) OR (bugs.qa_contact = 10711) ) GROUP BY bugs.bug_id ORDER BY 
bugs.bug_id "] at /var/www/html/bugzilla-tip/buglist.cgi line 855