TypeError: unsupported type for timedelta microseconds component: unicode

[varun84@…]

How to Reproduce

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

I exported the defects to csv and did some modification and reimported the files. The Import process was succesfull.When tried to open the defect details got this error.Requesting to look into the issue.Please provide some details on the issue

Request parameters:

{'id': u'1'}

User agent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; MS-RTC LM 8; InfoPath.3)

System Information

Trac	1.0.1
Babel	0.9.6
Genshi	0.6 (without speedups)
mod_wsgi	3.5 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})
pysqlite	2.6.3
Python	2.7.6 (default, Nov 10 2013, 19:24:18) [MSC v.1500 32 bit (Intel)]
setuptools	0.6c11
SQLite	3.7.6.2
Subversion	1.8.4 (r1534716)
jQuery	1.7.2

Enabled Plugins

ticketimport	0.8.3
tracaccountmanager	0.3.2

Python Traceback

Traceback (most recent call last):
  File "build\bdist.win32\egg\trac\web\main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "build\bdist.win32\egg\trac\web\main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "build\bdist.win32\egg\trac\ticket\web_ui.py", line 179, in process_request
    return self._process_ticket_request(req)
  File "build\bdist.win32\egg\trac\ticket\web_ui.py", line 528, in _process_ticket_request
    ticket = Ticket(self.env, id, version=version)
  File "build\bdist.win32\egg\trac\ticket\model.py", line 82, in __init__
    self._fetch_ticket(tkt_id)
  File "build\bdist.win32\egg\trac\ticket\model.py", line 127, in _fetch_ticket
    self.values[field] = from_utimestamp(value)
  File "build\bdist.win32\egg\trac\util\datefmt.py", line 113, in from_utimestamp
    return _epoc + timedelta(microseconds=ts or 0)
TypeError: unsupported type for timedelta microseconds component: unicode

[Jun Omae]

Seems to be work for me. It's possible to store a string in time and/or changetime columns of the ticket 1.

Make sure that time and changetime columns don't have a string using the following query.

sqlite> select id, time, changetime from ticket where time*1=0 or changetime*1=0;
id          time               changetime
----------  -----------------  ----------------
1           a1409927067774184  1409927076854404

See also comment:5:ticket:11654.

[Jun Omae]

No feedback.