summaryrefslogtreecommitdiffstats
path: root/CGI.pl
diff options
context:
space:
mode:
Diffstat (limited to 'CGI.pl')
-rw-r--r--CGI.pl8
1 files changed, 5 insertions, 3 deletions
diff --git a/CGI.pl b/CGI.pl
index 4ad0064f3..8770da748 100644
--- a/CGI.pl
+++ b/CGI.pl
@@ -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";