On Mon, 2010-07-26 at 14:38 -0500, Alvin Schatte wrote:
> Kristis,
> I tried reversing the order of the bug history table and bugnote table
> insertions to see if it would have an effect. Here is the new order in
> Mantis.pm line 466:
>
> ----------------------------------------------------------------------------
> -------------------
> # 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, sprintf("%07d",
> $mantis_bugnote_text_table_id) );
>
> # 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 );
> ----------------------------------------------------------------------------
> -------------------
>
> This yielded:
>
> ----------------------------------------------------------------------------
> -------------------
>
> Issue history:
> 2010-07-26 14:22 aschatte Note Added: 0000372
>
> ----------------------------------------------------------------------------
> -------------------
>
> Notes:
> (0000371)
> aschatte (administrator)
> 2010-07-26 14:22
>
> issue 0000080, issue 0000096- reverse note & note history MySQL
> database insertions to see what it does with the note reference id item.
>
>
> Branch: Cannot_be_determined
> Affected files:
> ---------------
> 2480 --> 2481
> rectifiers:VSS_Import/Rectifier/V-Series/PIC16F872/PFC/FW010010328_Standard
> Rectifiers/relnotes.txt
> ----------------------------------------------------------------------------
> -------------------
>
> It does not appear to have an effect.
>
> If there is something else I can try, please let me know.
>
> Regards,
> Alvin Schatte
> 12399 S. Hwy 121
> Trenton, TX 75490
> 903/989-5503 (Home)
> 469/734-6987 (cell)
> [email protected]
>
>
>
> -----Original Message-----
> From: Alvin Schatte [mailto:[email protected]]
> Sent: Monday, July 26, 2010 12:58 PM
> To: 'Kristis Makris'
> Subject: RE: [scmbug-users] Incorrect note id reference
>
> Thanks for the idea, Kristis. I'll try it as soon as I can and get back to
> you.
> Regards,
> 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: Monday, July 26, 2010 11:59 AM
> To: Alvin Schatte
> Cc: [email protected]
> Subject: Re: [scmbug-users] Incorrect note id reference
>
> Alvin, I'm sorry I can't be of more help. I don't understand why this error
> occurs, and in particular why it didn't occur before (in the past
> 5 years). I suspect it must be occurring due to a change in Mantis 1.2.0.
>
> If we were to entertain a thought, would you be able to try reversing the
> insert statements and see what happens ? So, first issue the insert in the
> mantis_bug_history_table, and then the insert in the mantis_bugnote_table.
>
>
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
