TypeError: can't compare datetime.datetime to str

[wmoore]

How to Reproduce

While doing a GET operation on /query, Trac issued an internal error. Query worked OK and after editing the 'Time Remaining' attribute on one ticket from the query it still worked, but then edited the Time on another ticket from the query and the query stopped working.

Request parameters:

{'col': [u'id',
         u'summary',
         u'status',
         u'type',
         u'priority',
         u'remaining_time'],
 'group': u'owner',
 'max': u'200',
 'order': u'priority',
 'sprint': u'2011-02-24 (6)',
 'status': [u'accepted', u'closed', u'new', u'reopened']}

User agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13

System Information

Trac	0.12
Agilo	1.3.2-PRO
Docutils	0.5
Genshi	0.6
GIT	1.7.3.4
mod_python	3.3.1
psycopg2	2.0.12
Python	2.6.6 (r266:84292, Feb 3 2011, 17:16:24) [GCC 4.1.2 (Gentoo 4.1.2 p1.3)]
pytz	2009j
RPC	1.1.0-r9395
setuptools	0.6c11
Subversion	1.6.15 (r1038135)
jQuery	1.4.2

Enabled Plugins

binary-agilo	1.3.2-PRO
TracGit	0.12.0.5dev
TracIncludeMacro	2.1
TracTocMacro	11.0.0.3
TracXMLRPC	1.1.0-r9395

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 513, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 235, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 933, in process_request
    return self.display_html(req, query)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 1052, in display_html
    data = query.template_data(context, tickets, orig_list, orig_time, req)
  File "build/bdist.linux-x86_64/egg/trac/ticket/query.py", line 730, in template_data
    if ticket['time'] > orig_time:
TypeError: can't compare datetime.datetime to str

[Remy Blank]

Likely a PluginIssue (AgiloForScrum), although we can't be sure from the traceback.

[anonymous]

Hm…. looking at this, of course it's possible we caused this, I woul surprise me though.

@reporter: can you reproduce the issue if you disable the agilo plugin temporarily? If so, could you please join our google group to help us resolve this issue? More details about the group at AgiloForScrum.

@rblank: thanks for wrangling. :)

[Remy Blank]

Replying to anonymous:

Hm…. looking at this, of course it's possible we caused this, I woul surprise me though.

Feel free to reopen this ticket if the issue is in Trac core.

[Martin Häcker <martin.haecker@…>]

Well, I might - but the reporter doesn't seem to have come back, so we still don't know how to reproduce this. Cheers!