282702 - Malformed Boolean "Time Since Owner Touched" fails

Status: RESOLVED WORKSFORME

(Bugzilla :: Query/Bug List, defect, P3)

Description

[Tomas Kopal]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20050110 Firefox/1.0 (Debian package 1.0+dfsg.1-2)
Build Identifier: 

When searching for bugs the owner didn't touch for certain interval, sql error
is printed.

Query:
https://bugzilla.mozilla.org/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&resolution=DUPLICATE&resolution=---&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=owner_idle_time&type0-0-0=greaterthan&value0-0-0=5+days

Error:
DBD::mysql::st execute failed: Unknown column 'greaterthan' in 'on clause' [for
Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority,
bugs.bug_status, bugs.resolution, bugs.bug_severity, bugs.priority,
bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution,
bugs.short_desc FROM bugs, profiles AS map_assigned_to  LEFT JOIN longdescs
comment_idle_0 ON (comment_idle_0.who = bugs.assigned_to AND
comment_idle_0.bug_id = bugs.bug_id AND comment_idle_0.bug_when >
DATE_SUB(NOW(), INTERVAL greaterthan DAY)) LEFT JOIN bugs_activity
activity_idle_0 ON ((activity_idle_0.who = bugs.assigned_to OR
activity_idle_0.fieldid = 34) AND activity_idle_0.bug_id = bugs.bug_id AND
activity_idle_0.bug_when > DATE_SUB(NOW(), INTERVAL greaterthan DAY)) LEFT JOIN
bug_group_map  ON bug_group_map.bug_id = bugs.bug_id  LEFT JOIN cc ON cc.bug_id
= bugs.bug_id AND cc.who = 140826 WHERE bugs.assigned_to =
map_assigned_to.userid AND (comment_idle_0.who IS NULL AND activity_idle_0.who
IS NULL) AND ((bugs.resolution IN ('DUPLICATE',''))) AND ((0=0)) AND
((bug_group_map.group_id IS NULL)    OR (bugs.reporter_accessible = 1 AND
bugs.reporter = 140826)     OR (bugs.cclist_accessible = 1 AND cc.who IS NOT
NULL)     OR (bugs.assigned_to = 140826) OR (bugs.qa_contact = 140826) ) GROUP
BY bugs.bug_id ORDER BY bugs.resolution "] at Bugzilla/DB.pm line 62
	Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, bugs.priority,
bugs.bug_s...') called at /opt/webtools/bugzilla/buglist.cgi line 762



Reproducible: Always

Steps to Reproduce:

Comment 1

[Joel Peshkin]

This is a combination of a documentation problem (should be "5d" not "5 + days")
and a validation problem (should give a nice pretty error if the user does
something wrong)

Comment 3

[:glob ✱]

that query now throws the following error:  '5 days' is not a legal date