Modify ↓

Opened 15 years ago

Closed 11 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 15 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 12 years ago by Ryan J Ollos

Summary: deleting change does not update 'last modified' date → Deleting change does not update 'last modified' date

comment:3 Changed 11 years ago by Ryan J Ollos

Resolution: → wontfix
Status: new → closed

Closing tickets for deprecated plugin.

Modify Ticket

Change Properties
Set your email in Preferences
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.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.