Ticket #4271 (closed defect: wontfix)
Opened 5 years ago
Last modified 5 years ago
All timestamp related fields return today's date (ie time, changetime)
| Reported by: | lawrielo@… | Owned by: | jonas |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | timeline | Version: | 0.9.6 |
| Severity: | major | Keywords: | |
| Cc: | |||
| Release Notes: | |||
| API Changes: | |||
Description
Hi,
I have been using trac for over 6 months and had not encountered any problems until today. For some reason all of the date's displayed for tickets created, some of which were created several month's ago have changed to today's date. The ticket history at the top right hand corner of the ticket is correct but the logs under the ticket are all showing today's date. The events displayed in the timeline also show all of today's date too. Can anyone explain to me what would have corrupted the pysqlite database to only return today's date for all time fields?
Regards,
Attachments
Change History
comment:1 Changed 5 years ago by cboos
comment:2 Changed 5 years ago by mgood
- Keywords needinfo added
comment:3 Changed 5 years ago by lawrielo@…
I did what you suggested and it returns 44 ids (which is the same amount as the number of tickets), and the time is all today's date.
Other resources are affected too.
Thanks.
comment:4 Changed 5 years ago by mgood
Has anyone been running any database queries on Trac? Maybe they accidentally ran an update query on the tickets and updated the time. Are you using any scripts or plugins with Trac? Which ones? Maybe there's a bug in one of these that's updated the time of all the tickets.
comment:5 Changed 5 years ago by lawrielo@…
I'm only using the repository search plugin to allow users to include the subversion repository in their searches. I have removed the plugin and have still noticed that the timestamps of all items in trac change whenever i refresh the trac timeline page. I think that is the problem. Is there a fix for this?
comment:6 Changed 5 years ago by Lawrence Lo <lawrielo@…>
- Severity changed from normal to major
comment:7 Changed 5 years ago by cboos
Any follow-up on this? Otherwise we'll close the ticket as wontfix, since no one else ever saw this issue, nor do I see how it could happen in normal circumstances.
comment:8 Changed 5 years ago by cboos
- Keywords needinfo removed
- Resolution set to wontfix
- Status changed from new to closed
Nobody was able to reproduce that error, and I don't see how we could help here.
A guess which is worth any other, it could have been a modified trac-post-commit-hook which was misbehaving…
Can you have a direct look in the database using the sqlite3 command-line tool?
e.g. do select id, time from ticket.
Is this problem limited to tickets, or are the other resources affected as well?