Thank you Alvin, but I do have to ask, what database are you using ?
The solution you provide uses unix_timestamp(), which probably won't be available in all databases. On Tue, 2010-07-20 at 15:04 -0500, Alvin Schatte wrote: > 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
signature.asc
Description: This is a digitally signed message part
_______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
