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 owner will remain coderanger.
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.