Corrupted changetime field prevents viewing of tickets
|Reported by:||Owned by:||Christopher Lenz|
Somehow the changetime field in a ticket of ours got changed to a non-integer number (1129000177.4728). This meant that any report including the ticket in question failed. I was able to go into the database and edit the offending record manually and restore service that way without having to use our daily backup.
We have 30+ users on 3 individual tracs for about 5 months now, this is the first time we've seen this particular error. We upgraded less than a week ago to 0.9b2-intertrac (I think it's ) on a completely new server.
Here is the traceback:
Python traceback Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/trac/web/modpython_frontend.py", line 206, in handler dispatch_request(mpr.path_info, mpr, env) File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 139, in dispatch_request dispatcher.dispatch(req) File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 107, in dispatch resp = chosen_handler.process_request(req) File "/usr/lib/python2.3/site-packages/trac/ticket/report.py", line 116, in process_request resp = self._render_view(req, db, id) File "/usr/lib/python2.3/site-packages/trac/ticket/report.py", line 354, in _render_view value['date'] = util.format_date(cell) File "/usr/lib/python2.3/site-packages/trac/util.py", line 201, in format_date return format_datetime(t, format, gmt) File "/usr/lib/python2.3/site-packages/trac/util.py", line 195, in format_datetime t = time.localtime(int(t)) ValueError: invalid literal for int(): 1129000177.47