P4DTI issue job000704

TitleBugzilla fixes table shows the fixer, not the changer
Statusclosed
Priorityessential
Assigned userNick Barnes
OrganizationRavenbrook
DescriptionThe patched Bugzilla bug form has a fixes table showing Perforce fixes for the bug. The table has one row per fix record, showing the changelist number, date, description, and user. The "user" column shows the user who made the fix record, not the user who made the change. This is counter-intuitive, not very useful, and contrary to the P4DTI documentation, in particular the IG [1].
AnalysisIn bug_form.pl, the SQL join used for this table has an incorrect condition. Instead of "AND profiles.userid = p4dti_fixes.user", it should say "AND profiles.userid = p4dti_changelists.user".
How foundmanual_test
Evidence[1] <http://www.ravenbrook.com/project/p4dti/release/1.5.3/ig/#section-10>
Observed in1.5.3
Introduced in0.5.0
Created byNick Barnes
Created on2003-05-30 15:39:16
Last modified byNick Barnes
Last modified on2003-10-22 13:41:40
History2003-05-30 NB Created.

Fixes

Change Effect Date User Description
61290 closed 2003-10-22 13:41:31 Nick Barnes When reporting a fix, should ascribe it to the changelist's user, not the fix record's user (job000704).