Edgewall Software
Modify

Opened 10 years ago

Closed 10 years ago

#11743 closed defect (worksforme)

TypeError: unsupported type for timedelta microseconds component: unicode

Reported by: varun84@… Owned by:
Priority: normal Milestone:
Component: ticket system Version: 1.0.1
Severity: normal Keywords: needinfo
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

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

Attachments (0)

Change History (2)

comment:1 by Jun Omae, 10 years ago

Component: generalticket system
Keywords: needinfo added

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.

comment:2 by Jun Omae, 10 years ago

Resolution: worksforme
Status: newclosed

No feedback.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.