TypeError: unsupported type for timedelta microseconds component: unicode

[vinay.mohan.dass@…]

How to Reproduce

While doing a GET operation on /query, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'group': u'status',
 'milestone': u'Review2',
 'status': [u'assigned', u'new', u'accepted', u'reopened']}

User agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.116 Safari/537.36

System Information

Trac	0.12.3
Trac	0.12.3
Agilo	0.9.6.2
Babel	0.9.5
Docutils	0.7
FullBlog	0.1.1-r9430
Genshi	0.6
GIT	1.8.1.1
mod_wsgi	2.5 (WSGIProcessGroup trac_wsgi_04 WSGIApplicationGroup %{GLOBAL})
Pygments	1.4dev-20110115
pysqlite	2.4.1
Python	2.5.2 (r252:60911, Jan 24 2010, 18:02:01) [GCC 4.3.2]
Python	2.5.2 (r252:60911, Jan 24 2010, 18:02:01) [GCC 4.3.2]
pytz	2008c
pytz	2008c
RPC	1.1.2
setuptools	0.6c12
setuptools	0.6c12
SQLite	3.7.3
Subversion	1.7.8 (r1419691)
jQuery	1.4.4

Enabled Plugins

agilo	0.9.6.2
backlinks	N/A
backlinks-menu	N/A
TicketImport	0.8
TracAnnouncer	0.12.1.dev
TracCaptcha	0.2.2
TracDiscussion	0.8-r9877
TracFullBlogPlugin	0.1.1-r9430
TracGit	0.12.0.5dev
tracrpc.changeset	N/A
TracTocMacro	11.0.0.3
TracWysiwyg	0.12.0.3-r9676
TracXMLRPC	1.1.2

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/web/main.py", line 522, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/web/main.py", line 243, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/ticket/query.py", line 952, in process_request
    return self.display_html(req, query)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/ticket/query.py", line 1052, in display_html
    tickets = query.execute(req, db)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/ticket/query.py", line 340, in execute
    val = from_utimestamp(val)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.12.3-py2.5.egg/trac/util/datefmt.py", line 84, in from_utimestamp
    return _epoc + timedelta(microseconds=ts or 0)
TypeError: unsupported type for timedelta microseconds component: unicode

[Jun Omae]

It seems to be an InstallationIssue. If time type is used in [ticket-custom], that will occurs. Trac 0.12 doesn't support time type for custom fields.

[ticket-custom]
field_name = time
...

Make sure that [ticket-custom] section has no time type fields.

[Jun Omae]

No feedback, closing.