Modify

Opened 6 years ago

Closed 19 months ago

#4443 closed enhancement (wontfix)

Deleting change does not update 'last modified' date

Reported by: theultramage@… Owned by: coderanger
Priority: normal Component: TicketDeletePlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

I use this plugin for deletion of spam comments in tickets. I noticed that even though I delete a comment, the 'last modified' date doesn't revert to the last posting date, and the 2 year old ticket stays on top of the list.

This might cause some confusion, so I suggest adjusting the date when the comment to be deleted is the most recent one.

Attachments (0)

Change History (3)

comment:1 Changed 6 years ago by theultramage@…

After getting a bunch of ancient tickets bumped up to the first page by spam, I used Firefox's "SQLite Manager" plugin to run the following queries to correct the "last modified" column:

UPDATE ticket
SET   changetime = (SELECT MAX(time) FROM ticket_change WHERE ticket = id)
WHERE changetime > (SELECT MAX(time) FROM ticket_change WHERE ticket = id)
UPDATE ticket
SET   changetime = time
WHERE changetime != time
AND NOT EXISTS (SELECT 1 FROM ticket_change WHERE ticket = id)

comment:2 Changed 2 years ago by rjollos

  • Summary changed from deleting change does not update 'last modified' date to Deleting change does not update 'last modified' date

comment:3 Changed 19 months ago by rjollos

  • Resolution set to wontfix
  • Status changed from new to closed

Closing tickets for deprecated plugin.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.