View Issue Details

IDProjectCategoryView StatusLast Update
0007631mantisbtbugtrackerpublic2007-12-21 23:16
Reporterrobocoder Assigned Tovboctor  
PrioritynormalSeveritytweakReproducibilityN/A
Status closedResolutionfixed 
Product Version1.0.6 
Target Version1.1.0Fixed in Version1.1.0a3 
Summary0007631: Notes appear in the wrong order
Description

If notes are quickly added to an issue within the same second, the notes
share the same date/time stamp. As a result, on occasion, the notes may
appear out of order when viewing the bug. (This situation is more likely to
arise as a result of importing bugs.)

In bugnote_view.inc.php, I would suggest changing the SQL SELECT as follows:

< # get the bugnote data
< $query = "SELECT *
< FROM $t_bugnote_table
< WHERE bug_id='$f_bug_id' $t_restriction
< ORDER BY date_submitted $t_bugnote_order";

to:

   # get the bugnote data
   $query = "SELECT *
                   FROM $t_bugnote_table
                   WHERE bug_id='$f_bug_id' $t_restriction
                   ORDER BY date_submitted,id $t_bugnote_order";
TagsNo tags attached.

Activities

vboctor

vboctor

2007-02-19 23:49

manager   ~0014067

The correct fix is:

$query = "SELECT *
FROM $t_bugnote_table
WHERE bug_id='$f_bug_id' $t_restriction
ORDER BY date_submitted $t_bugnote_order, id $t_bugnote_order";