Edgewall Software
Modify ↓

Opened 17 years ago

Closed 17 years ago

#8049 closed enhancement (duplicate)

Milestone name change not updated in ticket_changes

Reported by: olivier.elshocht@… Owned by:
Priority: normal Milestone:
Component: ticket system Version: none
Severity: minor Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

When changing a milestone name (milestone.name), trac correctly updates the ticket table (tickets.milestone) but does not update the ticket change table. The following trigger fixes this:

CREATE TRIGGER update_milestone_name UPDATE OF name ON milestone

BEGIN

UPDATE ticket_change SET oldvalue = new.name WHERE field = 'milestone' AND oldvalue = old.name; UPDATE ticket_change SET newvalue = new.name WHERE field = 'milestone' AND newvalue = old.name;

END;

Attachments (0)

Change History (1)

comment:1 by Christian Boos, 17 years ago

Milestone: 0.11.3
Resolution: → duplicate
Status: new → closed

Duplicate of #4582.

See #5658 for a discussion of the more general problem.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.