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

Attachment: 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

Reply via email to