diff options
author | terry%mozilla.org <> | 2000-01-23 06:43:29 +0100 |
---|---|---|
committer | terry%mozilla.org <> | 2000-01-23 06:43:29 +0100 |
commit | 6c604de4e442ea6fb716e6ca322a49773e795a74 (patch) | |
tree | 364422f2c6ac3f21fcaae83099ebb94d4da01ca4 /CGI.pl | |
parent | d9c667d9165679a7cbaaf38345158eac955c1f5d (diff) | |
download | bugzilla-6c604de4e442ea6fb716e6ca322a49773e795a74.tar.gz bugzilla-6c604de4e442ea6fb716e6ca322a49773e795a74.tar.xz |
AACK! checksetup.pl was stomping all over the new fielddefs table if
it got run more than once. This checkin fixes that, and also changes
the DumpBugActivity() routine to give me enough information to
hopefully repair the damaged mozilla.org database...
Diffstat (limited to 'CGI.pl')
-rw-r--r-- | CGI.pl | 8 |
1 files changed, 5 insertions, 3 deletions
@@ -778,12 +778,14 @@ sub DumpBugActivity { $datepart = "and bugs_activity.bug_when >= $starttime"; } my $query = " - SELECT fielddefs.name, bugs_activity.bug_when, + SELECT IFNULL(fielddefs.name, bugs_activity.fieldid), + bugs_activity.bug_when, bugs_activity.oldvalue, bugs_activity.newvalue, profiles.login_name - FROM bugs_activity,profiles,fielddefs + FROM bugs_activity LEFT JOIN fielddefs ON + bugs_activity.fieldid = fielddefs.fieldid, + profiles WHERE bugs_activity.bug_id = $id $datepart - AND fielddefs.fieldid = bugs_activity.fieldid AND profiles.userid = bugs_activity.who ORDER BY bugs_activity.bug_when"; |