Modify

Opened 8 years ago

Closed 4 years ago

#4443 closed enhancement (wontfix)

Deleting change does not update 'last modified' date

Reported by: theultramage@… Owned by: Noah Kantrowitz
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 8 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 5 years ago by Ryan J Ollos

Summary: deleting change does not update 'last modified' dateDeleting change does not update 'last modified' date

comment:3 Changed 4 years ago by Ryan J Ollos

Resolution: wontfix
Status: newclosed

Closing tickets for deprecated plugin.

Modify Ticket

Action
as closed The owner will remain Noah Kantrowitz.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.