Bug 500957

Dave,

'Cause hwcert code has been changed to process bugs.resolution field properly when reopening a bug, this clean up is most likely to be an one-time thing.  I think we just need the simple sql query to do it.

mysql> UPDATE bugs SET resolution="" WHERE bug_id IN (325631, 471077, 472124);

Any thoughts?


Thanks,
Tony

(In reply to comment #1)
> Dave,
> 
> 'Cause hwcert code has been changed to process bugs.resolution field properly
> when reopening a bug, this clean up is most likely to be an one-time thing.  I
> think we just need the simple sql query to do it.
> 
> mysql> UPDATE bugs SET resolution="" WHERE bug_id IN (325631, 471077, 472124);
> 
> Any thoughts?
> 
> 
> Thanks,
> Tony  

Problem was since the hwcert code did not do this properly when the bug was reopened it did not get the proper activity log entry at that time. So we may
need to make a log entry as well as change the bugs table. You can do this pretty easily by using the core BZ modules.

#!/usr/bin/perl

use lib '.';
use Bugzilla;
use Bugzilla::Bug;

Bugzilla->set_user(Bugzilla::User->new({name => 'bugzilla'});

foreach my $id (325631, 471077, 472124) {
    my $bug = Bugzilla::Bug->new($id);
    $bug->clear_resolution();
    $bug->update();
}


Or something like that. Then have eng-sysadmins to run the script on the live server for you.

Dave

Dave,


Thanks for your suggestion.  I attached a script which should do the bugs.resolution clean up.  If you are happy with it, I will ask our sysadmin to run it on the live server.


Thanks,
Tony

Created attachment 344401 [details]
script to set bugs.resolution to '' if the bug is in open state bug bugs.resolution is not ''

Comment on attachment 344401 [details]
script to set bugs.resolution to '' if the bug is in open state bug bugs.resolution is not ''

Tony. Looks good. Coordinate with eng-systems to get this executed on the live server.

Dave

eng-system has run it on the live server.

Close this bug.