Red Hat Bugzilla – Bug 441992
catalog will not send the correct information after I(reviewer) check the "Make certification public" of bug #441211
Last modified: 2008-06-23 03:33:40 EDT
Description of problem:
Version-Release number of selected component (if applicable):
Just check the "Make certification public" box, and then submit you request. And
check whehter you get the one email to tell you hwcer-edit is removed.
Steps to Reproduce:
1. set me to be the reviewer of #441211;
2. finish the review;
3. close the cert as certified;
4. check the "make certification public" box;
5. I noticed I am in the send to list;
check my mail box, no info about hwcert-edit is mentioned.
check my mail box, I should get one mail to inform me hwcert-edit is removed.
This bug is caused by "the catalog saved a no useful timestamp value
:"0000-00-00 00:00:00" into the bug_when column in the bugs_activity tables".
Sothe BugMail module which send a mail to remind what changes has been made in
the cert can not select and mail out "the bug activity" or "bug modification"
items whose timestamp value == "0000-00-00 00:00:00".
Created attachment 302101 [details]
The patch to fix the bug
xisun, please take a look for other uses of now() in the code; seems like this
is a side effect from switching db's earlier. Perhaps that should be another bug?
Have token a look for the other uses of now() in the code, and opened a new
Patch has been summited into cvs.