Tony, for these just go to the three bugs in question on the live site and change the rep_platform values to the following: arm -> arm7 PC -> i386 Since there are only three then it is easy just to change the bugs. And then close this out. Thanks Dave
Dave, I have updated three bugs that have arm as rep_platform value. There are 433 bugs that have PC as rep_platform value and we can use the following sql query to change them to i386 UPDATE bugs SET rep_platform='i386' WHERE rep_platform='pc'; Tony
(In reply to comment #2) > Dave, > > I have updated three bugs that have arm as rep_platform value. > > There are 433 bugs that have PC as rep_platform value and we can use the > following sql query to change them to i386 > > UPDATE bugs SET rep_platform='i386' WHERE rep_platform='pc'; Hmm, I didn't realize there were so many. We will need to write a script that does the bugs table update as you mention but I think we also need to insert the changes into the bugs_activity log. I originally thought there were only a few which we could have just changed through the UI which does the activity for us. Tony, can you create a script for this? Thanks Dave
(In reply to comment #3) > (In reply to comment #2) > > Dave, > > > > I have updated three bugs that have arm as rep_platform value. > > > > There are 433 bugs that have PC as rep_platform value and we can use the > > following sql query to change them to i386 > > > > UPDATE bugs SET rep_platform='i386' WHERE rep_platform='pc'; > > Hmm, I didn't realize there were so many. We will need to write a script that > does the bugs table update as you mention but I think we also need to insert the > changes into the bugs_activity log. I originally thought there were only a few > which we could have just changed through the UI which does the activity for us. > > Tony, can you create a script for this? > > Thanks > Dave > > Please see attachment for the script. Thanks, Tony
Created attachment 297560 [details] change bugs.rep_platform's value from "PC" to "i386"
Comment on attachment 297560 [details] change bugs.rep_platform's value from "PC" to "i386" Code looks good Tony. Please run on bz-db1-test.devel.redhat.com 'bugs2' database and verify that data is proper converted. Also look through some sample bug reports on bz-web1-test.devel.redhat.com. If it looks good, then check the script into redhat directory in CVS. Put this bug into MODIFIED state and we will schedule it to be ran on live for Thursday. Thanks Dave
(In reply to comment #6) > (From update of attachment 297560 [details] [edit]) > Code looks good Tony. Please run on bz-db1-test.devel.redhat.com 'bugs2' > database and verify that data is proper converted. Also look through some > sample bug reports on bz-web1-test.devel.redhat.com. If it looks good, then > check the script into redhat directory in CVS. Put this bug into MODIFIED state > and we will schedule it to be ran on live for Thursday. > > Thanks > Dave > I have tested this script against bugs2 db on bz-db1-test.devel.redhat.com and it looked good. checked this script into redhat directory in CVS repository. Tony
Tony, I cannot remember, was this ran on production during one of our thursday updates? If yes, please close this as CURRENTRELEASE/2.18 Thanks Dave
(In reply to comment #8) > Tony, I cannot remember, was this ran on production during one of our thursday > updates? If yes, please close this as CURRENTRELEASE/2.18 > > Thanks > Dave Dave, I think we have done it on production server. mysql> select count(bug_id) from bugs where rep_platform='arm'; +---------------+ | count(bug_id) | +---------------+ | 0 | +---------------+ 1 row in set (0.30 sec) mysql> select count(bug_id) from bugs where rep_platform='pc'; +---------------+ | count(bug_id) | +---------------+ | 0 | +---------------+ 1 row in set (0.30 sec) Close this bug. Tony