reopened tickets broken on trac0.11rc1

[anonymous]

after upgdate trac from 0.10.4 to 0.11rc1 all tickets with reopened status broken

How to Reproduce

1) set ticket/XXX status = repoened

2) While doing a GET operation on /ticket/574, Trac issued an internal error.

Request parameters:

{'id': u'574'}

User Agent was: Opera/9.50 (Windows NT 5.1; U; ru)

System Information

Trac	0.11rc1
Python	2.4.4 (#2, Apr 5 2007, 18:43:10) [GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)]
setuptools	0.6c6
SQLite	3.3.8
pysqlite	2.3.2
Genshi	0.4.4
Pygments	0.10
Subversion	1.4.2 (r22196)
SilverCity	0.9.7
jQuery:	1.2.3

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py", line 417, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py", line 197, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/ticket/web_ui.py", line 153, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/ticket/web_ui.py", line 495, in _process_ticket_request
    get_reporter_id(req, 'author'), field_changes)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/ticket/web_ui.py", line 1128, in _insert_ticket_data
    for change in self.rendered_changelog_entries(req, ticket):
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/ticket/web_ui.py", line 1226, in rendered_changelog_entries
    for group in self.grouped_changelog_entries(ticket, None, when):
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/ticket/web_ui.py", line 1306, in grouped_changelog_entries
    changelog = ticket.get_changelog(when=when, db=db)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/ticket/model.py", line 319, in get_changelog
    log.append((datetime.fromtimestamp(int(t), utc), author, field,
ValueError: invalid literal for int(): 2008-06-12 11:30:14+00:00

i have additional ticket state workflow (added Testing status etc.)

[Jonas Borgström]

Do you have any Trac plugins installed?

Can you run the following SQL query using the sqlite command line client and include the output:

SELECT time, field FROM ticket_change WHERE ticket=574;

[anonymous]

i have following 0.10 plugin list

[components] # current installed but not worked plugins tracgantt.* = enabled tracreposearch.* = enabled # need for Eclipse Mylyn integration removed after install 0.11rc1 # tracrpc.* = enabled

# ​http://trac-hacks.org/wiki/TracSlimTimerPlugin # currently on, may be bug in TracSlimTimerPlugin tracslimtimer.* = enabled

# ​http://trac-hacks.org/wiki/WikiTemplatesPlugin # commented after install 0.11rc1 #webadmin.* = enabled

# ​http://trac-hacks.org/wiki/WikiTemplatesPlugin # removed after install 0.11rc1 replace by IncludeMacro # wikitemplates.* = enabled

# ​http://trac-hacks.org/wiki/IncludeMacro, current ON includemacro.* = enabled

SELECT time, field FROM ticket_change WHERE ticket=574;

--------------│--------------------
        time  │  field             
--------------│--------------------
1213 270 147  │  comment           
1213 270 147  │  resolution        
1213 270 147  │  status            
1213 270 214  │  comment           
1213 270 214  │  resolution        
1213 270 214  │  status            
         0    │slimtimer_id        
--------------│--------------------

[Slach]

after disabled SlimTimerPlugin and use sqlite command line client

sqlite> SELECT * FROM ticket_change WHERE field='slimtimer_id' and ticket=574;
574|2008-06-12 11:30:14+00:00|syabro|slimtimer_id|0|477556
sqlite> SELECT * FROM ticket_change WHERE field='slimtimer_id' and time LIKE '%-%';
573|2008-06-12 11:29:58+00:00|syabro|slimtimer_id|0|477555
574|2008-06-12 11:30:14+00:00|syabro|slimtimer_id|0|477556
sqlite> DELETE FROM ticket_change WHERE field='slimtimer_id' and time LIKE '%-%';
OK

field time must be integer, but slimtimer maybe save datetime value (hmm, SQLite is a really strange database ;) bug fixed, bug report with link sended to trac-hacks

[Christian Boos]

(clearing report:35)