306364 - SQL crash when moving a bug to another product

Status: RESOLVED FIXED

(Bugzilla :: Creating/Changing Bugs, defect)

Description

[Frédéric Buclin]

Move a bug to another product:

DBD::mysql::st execute failed: Unknown column 'groups_id' in 'field list' [for
Statement "SELECT DISTINCT groups.id, isactive, oldcontrolmap.membercontrol,
newcontrolmap.membercontrol, CASE WHEN groups_id IN
(37,41,48,44,39,35,42,45,59,38,36,40,55,43) THEN 1 ELSE 0 END,
bug_group_map.group_id IS NOT NULL FROM groups LEFT JOIN group_control_map AS
oldcontrolmap ON oldcontrolmap.group_id = groups.id AND oldcontrolmap.product_id
= 4 LEFT JOIN group_control_map AS newcontrolmap ON newcontrolmap.group_id =
groups.id AND newcontrolmap.product_id = 40 LEFT JOIN bug_group_map ON
bug_group_map.group_id = groups.id AND bug_group_map.bug_id = 289 "] at
Bugzilla/DB.pm line 83
	Bugzilla::DB::SendSQL('SELECT DISTINCT groups.id, isactive,
oldcontrolmap.membercont...') called at
/var/www/html/cvsbugzilla/process_bug.cgi line 1657


groups_id should be groups.id. This is another regression from bug 304583.

Comment 1

[Frédéric Buclin]

Attachment: patch, v1

Comment 2

[Joel Peshkin]

Comment on attachment 194224 [details] [diff] [review]
patch, v1

That's it.  Thanks.

Comment 3

[Frédéric Buclin]

Checking in process_bug.cgi;
/cvsroot/mozilla/webtools/bugzilla/process_bug.cgi,v  <--  process_bug.cgi
new revision: 1.282; previous revision: 1.281
done