View Revisions: Issue #25442

Summary 0025442: Wrong/duplicate bugnote_text_id in mantis_bugnote_table
Revision 2019-02-04 19:07 by cproensa
Description

After we upgraded to MantisBT 2.11.1 in December 2018, users have noticed phantom notes added to their ticket/issue with their names on it. A query of the database shows that we have multiple bug_id pointing to the same bugnot_text_id. Attached is a screenshot showing the result of the select statement below. It show three bugnote pointing to the same bugnote_text. Those 3 notes were submitted within 15 seconds by different users in different issue#. Can you please advise what the issue/cause may be?

select id, bug_id, reporter_id, bugnote_text_id, view_state,
dateadd(ss,date_submitted,'1/1/1970') as date_submitted, dateadd(ss,last_modified,'1/1/1970') as last_modified
from [dbo].[mantis_bugnote_table]
where bugnote_text_id=2023681

Revision 2019-02-04 17:44 by juliexn
Description

After we upgraded to MantisBT 2.11.1 in December 2018, users have noticed phantom notes added to their ticket/issue with their names on it. A query of the database shows that we have multiple bug_id pointing to the same bugnot_text_id. Attached is a screenshot showing the result of the select statement below. It show three bugnote pointing to the same bugnote_text. Those 3 notes were submitted within 15 seconds by different users in different issue#. Can you please advise what the issue/cause may be?

select id, bug_id, reporter_id, bugnote_text_id, view_state,
dateadd(ss,date_submitted,'1/1/1970') as date_submitted, dateadd(ss,last_modified,'1/1/1970') as last_modified
from [dbo].[mantis_bugnote_table]
where bugnote_text_id=2023681