164064 - You have an error in your SQL syntax near ')) LEFT JOIN cc selectVisible_cc ON bugs.bug_id = selectVisible_cc.bug_id AND se' at line 1 at globals.pl line 276.

Status: RESOLVED WORKSFORME

(Bugzilla :: Query/Bug List, defect)

Description

[timeless]

Please stand by ...
Content-type: text/html
Software error:
SELECT DISTINCT bugs.bug_id, bugs.groupset, bugs.bug_severity, bugs.priority,
bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution,
bugs.short_desc FROM bugs, profiles map_assigned_to, profiles map_reporter LEFT
JOIN profiles map_qa_contact ON bugs.qa_contact = map_qa_contact.userid,
attachments attachments_0 LEFT JOIN attachstatuses attachstatuses_0_1 ON
(attachments_0.attach_id = attachstatuses_0_1.attach_id AND
attachstatuses_0_1.statusid IN (4,11,12,16,20,24,31,33,36)) LEFT JOIN
attachstatuses attachstatuses_0_2 ON (attachments_0.attach_id =
attachstatuses_0_2.attach_id AND attachstatuses_0_2.statusid IN ()) LEFT JOIN cc
selectVisible_cc ON bugs.bug_id = selectVisible_cc.bug_id AND
selectVisible_cc.who = 15223 WHERE ((bugs.groupset & 704) = bugs.groupset OR
(bugs.reporter_accessible = 1 AND bugs.reporter = 15223) OR
(bugs.cclist_accessible = 1 AND selectVisible_cc.who = 15223 AND not
isnull(selectVisible_cc.who)) OR (bugs.assigned_to = 15223) OR (bugs.qa_contact
= 15223)) AND bugs.assigned_to = map_assigned_to.userid AND bugs.reporter =
map_reporter.userid AND bugs.bug_id = attachments_0.bug_id AND bugs.bug_id =
attachments_0.bug_id AND bugs.bug_id = attachments_0.bug_id AND (bugs.resolution
= '') AND (bugs.product = 'Browser') AND (bugs.op_sys = 'BeOS') AND
(attachments_0.ispatch = '1') AND (attachstatuses_0_1.statusid IS NOT NULL) AND
(attachstatuses_0_2.statusid IS NOT NULL) ORDER BY bugs.bug_id : You have an
error in your SQL syntax near ')) LEFT JOIN cc selectVisible_cc ON bugs.bug_id =
selectVisible_cc.bug_id AND se' at line 1 at globals.pl line 276.

For help, please send mail to the webmaster ([e-mail]), giving this
error message and the time and date of the error. 

Query intent:
resolution: ---
os: BeOS
product: Browser
attachment is patch
attachment has-review
attachment has-super-review

Cause: User error
'has-superreview' instead of 'has-super-review'. it'd be nice if i got a
friendly error explaining that has-superreview isn't recognized.

Comment 1

[Bradley Baetz (:bbaetz)]

Bleh. Searching sucks.

Comment 2

[Dawn Endico]

how did the user manage to make this mistake? by hacking the url?

Comment 3

[timeless]

this stuff comes from boolean charts. there are no hints about attachment status
values so i typed from memory.

Comment 4

[Bradley Baetz (:bbaetz)]

right - we need to add a check in our select for attachment status matches
there, and either make it so that nothing matches.

We can't throw an error without having OR queries give an error when results
would be retreived. We may want to do so anyway though, maybe

Comment 5

[Max Kanat-Alexander]

I can't reproduce with the above URL anymore, because of course attachment
statuses don't work anymore.

Timeless, can you still reproduce the error with the current flags system?

Comment 6

[timeless]

i can't think of a way...