Hello Kristis, That fixed the timestamp problem. Attached is the resulting Mantis.pm file. However, it uncovered another problem that I'll report as a separate issue. Thanks for the help, Alvin Schatte 12399 S. Hwy 121 Trenton, TX 75490 903/989-5503 (Home) 469/734-6987 (cell) [email protected]
-----Original Message----- From: Kristis Makris [mailto:[email protected]] Sent: Tuesday, July 20, 2010 1:39 PM To: Alvin Schatte Cc: [email protected] Subject: Re: [scmbug-users] Mantis Time Stamp Hi Alvin, I believe this problem begun since Mantis 1.2.0. Have a look at: http://bugzilla.mkgnu.net/show_bug.cgi?id=1461 This should be easy to fix. I'd love to merge a patch. On Tue, 2010-07-20 at 13:34 -0500, Alvin Schatte wrote: > Hello, > > I am trying to integrate Mantis (V1.2.1) to Subversion using SCMbug. > I am trying to get the timestamp for the Mantis notes and note history > to come out right. Here is what a note header looks like: > (0000362) > aschatte (developer) > 1969-12-31 18:00 > > > > The corresponding Note History looks like: > > > > 1969-12-31 18:33 aschatte Note Added: 0000363 > > > > How do I get the right date? This appears to be generated by a > database call in Mantis.pm (line 466): > > > > # 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(?,?,?,?,now(), now())"; > > $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(?,?,now(),'',?,'',2)"; > > $self->mantis_issue_sql( $sql, $reporter_id, $bugid, sprintf("% > 07d", $mantis_bugnote_text_table_id) ); > > > > Thanks for the help, > > Alvin Schatte > > > > > _______________________________________________ > scmbug-users mailing list > [email protected] > http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
Mantis.pm
Description: Binary data
_______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
