1218403 - hitting DBD::mysql::db selectcol_arrayref failed: Table 'bugs.bugs_g2' doesn't exist on b.m.o

Status: RESOLVED DUPLICATE of bug 889650

(bugzilla.mozilla.org :: General, defect)

Description

[:Gavin Sharp [email: [e-mail]]]

STR:
1) Load https://bugzilla.mozilla.org/buglist.cgi?j_top=AND_G&f1=flagtypes.name&o1=substring&o2=changedby&f4=flagtypes.name&query_format=advanced&f3=flagtypes.name&f2=flagtypes.name&v1=review&v2=gavin.sharp%40gmail.com
2) That's it!

I get:

DBD::mysql::db selectcol_arrayref failed: Table 'bugs.bugs_g1' doesn't exist [for Statement "SELECT bugs.bug_id AS bug_id FROM bugs LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id AND NOT ( security_map.group_id IN (19,31,10,9,4,7,8,149,162,119,69,161,98,160,120,33,29,27,191,96,190,188) ) LEFT JOIN cc AS security_cc ON bugs.bug_id = security_cc.bug_id AND security_cc.who = 103593 LEFT JOIN bugs AS bugs_g1 ON bugs.bug_id = bugs_g1.bug_id LEFT JOIN bugs_activity AS act_69_1 ON bugs_g1.bug_id = act_69_1.bug_id AND act_69_1.fieldid = 69 AND act_69_1.who = 103593 LEFT JOIN attachments AS attach_69_1 ON act_69_1.attach_id = attach_69_1.attach_id WHERE bugs.creation_ts IS NOT NULL AND (security_map.group_id IS NULL OR (bugs.reporter_accessible = 1 AND bugs.reporter = 103593) OR (bugs.cclist_accessible = 1 AND security_cc.who IS NOT NULL) OR bugs.assigned_to = 103593 OR bugs.qa_contact = 103593) AND ( 1 = 1 AND ( EXISTS ( SELECT 1 FROM bugs_g1 bugs_1 LEFT JOIN attachments AS attachments_1 ON bugs_1.bug_id = attachments_1.bug_id LEFT JOIN flags AS flags_1 ON bugs_1.bug_id = flags_1.bug_id AND (flags_1.attach_id = attachments_1.attach_id OR flags_1.attach_id IS NULL) LEFT JOIN flagtypes AS flagtypes_1 ON flags_1.type_id = flagtypes_1.id WHERE bugs_1.bug_id = bugs_g1.bug_id AND INSTR(CONCAT(flagtypes_1.name, flags_1.status), 'review') > 0 ) ) AND act_69_1.bug_when IS NOT NULL AND COALESCE(attach_69_1.isprivate, 0) = 0 ) GROUP BY bugs.bug_id ORDER BY bug_id LIMIT 500 "]

Comment 1

[Dylan Hardison [:dylan] (he/him)]

It seems related to the j_top=AND_G parameter. That's the causal factor for generating incorrect sql.

Comment 2

[Dylan Hardison [:dylan] (he/him)]

j_top=AND_G is the option "Match ALL of the following against the same field:".
It appears the the AND_G cannot be used on the Flags field.