Hello, I am getting and incorrect note reference id in the note history to a note just previously added. Here is the note:
(0000365) <http://evus-hgmth41:8888/mantis/view.php?id=80#c365> aschatte <http://evus-hgmth41:8888/mantis/view_user_page.php?id=23> (administrator) 2010-07-20 14:51 Here is the Note history associated with it: 2010-07-20 14:51 aschatte <http://evus-hgmth41:8888/mantis/view_user_page.php?id=23> Note Added: 0000366 The note history has a note reference id of 0000366 to refer to the note labeled 0000365. The code associated with this from Mantis.pm is # Add the comment $sql = "INSERT INTO mantis_bugnote_text_table(note) VALUES(?)"; $self->mantis_issue_sql( $sql, $comment ); # Find the bugnote_id needed by the comment association my $mantis_bugnote_text_table_id = $self->mantis_last_insert_id(); my $formatted_mantis_bugnote_text_table_id = sprintf("%07d", $mantis_bugnote_text_table_id); # Determine the state of the bug my $mantis_bug_view_state = $self->mantis_get_bug_view_state($bugid); # Associate the comment with the bug $sql = "INSERT INTO mantis_bugnote_table(bug_id, reporter_id, bugnote_text_id, view_state, date_submitted, last_modified) VALUES(?,?,?,?,unix_timestamp(), unix_timestamp())"; $self->mantis_issue_sql( $sql, $bugid, $reporter_id, $mantis_bugnote_text_table_id, $mantis_bug_view_state ); # Preserve bug history. Mantis proposes a 7-digit long format for bug ids. $sql = "INSERT INTO mantis_bug_history_table(user_id, bug_id, date_modified, field_name, old_value, new_value, type) VALUES(?,?,unix_timestamp(),'',?,'',2)"; $self->mantis_issue_sql( $sql, $reporter_id, $bugid, $formatted_mantis_bugnote_text_table_id ); Do you have any idea about how to fix this? Thanks, Alvin Schatte 12399 S. Hwy 121 Trenton, TX 75490 903/989-5503 (Home) 469/734-6987 (cell) <mailto:[email protected]> [email protected]
_______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
