109147 - cannot reopen several bugs at once

Status: RESOLVED DUPLICATE of bug 95430

(Bugzilla :: Creating/Changing Bugs, defect)

Description

[Per Cederqvist]

When I try to reopen several bugs at once, I get this error message:

	Software error:

	SELECT resolution FROM bugs WHERE bug_id = : You have an error in your	
	SQL syntax near '' at line 1 at globals.pl line 214.

I took a quick look at the code, and the problem is probably the
following code from line 779 of process_bug.cgi from the 2.14 release.
(The problem still exists in the current CVS file; see line 748 of
revision 1.105 of process_bug.cgi.):

    /^reopen$/  && CheckonComment( "reopen" ) && do {
                SendSQL("SELECT resolution FROM bugs WHERE bug_id =
$::FORM{'id'}");
        ChangeStatus('REOPENED');
        ChangeResolution('');
                if (FetchOneColumn() eq 'DUPLICATE') {
                        SendSQL("DELETE FROM duplicates WHERE dupe =
$::FORM{'id'}");
                }
        last SWITCH;

This code shouldn't use $::FORM{'id'}, but rather loop over @idlist.

This problem can be reproduced by running a query for all 
resolved/later bugs (assuming there are more than one of them,
follow the "Change several bugs at once" link, pressing the 
"Check All" button, pressing "Reopen bugs", and pressing
"Commit".  This will return the error message showed above.

Comment 1

[Matthew Tuck [:CodeMachine]]

*** This bug has been marked as a duplicate of 95430 ***