Edgewall Software

Opened 8 years ago

Closed 8 years ago

#3476 closed defect (fixed)

Report error.

Reported by: tdkim@… Owned by: daniel
Priority: normal Milestone: 0.10
Component: report system Version: devel
Severity: normal Keywords: report, time
Cc: tdkim@…
Release Notes:
API Changes:


Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 335, in dispatch_request
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 220, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/trac/ticket/report.py", line 89, in process_request
    resp = self._render_view(req, db, id)
  File "/usr/lib/python2.4/site-packages/trac/ticket/report.py", line 343, in _render_view
    value['date'] = format_date(cell)
  File "/usr/lib/python2.4/site-packages/trac/util/datefmt.py", line 68, in format_date
    return format_datetime(t, format, gmt)
  File "/usr/lib/python2.4/site-packages/trac/util/datefmt.py", line 58, in format_datetime
    t = time.localtime(int(t))
ValueError: invalid literal for int(): 1127824200.89

This is the sql query.

SELECT p.value AS __color__,
   t.milestone AS __group__,
   (CASE status 
      WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
      ELSE (CASE owner WHEN '$USER' THEN 'font-weight: bold' END)
    END) AS __style__,
   id AS ticket, summary, component, status, 
   resolution,version, t.type AS type, priority, owner,
   changetime AS modified,
   time AS _time,reporter AS _reporter
  FROM ticket t,enum p
  WHERE p.name=t.priority AND p.type='priority'
  ORDER BY (milestone IS NULL), milestone, (status = 'closed'), 
        (CASE status WHEN 'closed' THEN modified ELSE (-1)*p.value END) DESC

I think that this is not a sql query problem. The sql query works correctly for my other Trac repository.

Attachments (0)

Change History (3)

comment:1 Changed 8 years ago by eblot

  • Milestone changed from 0.9.7 to 0.10

Milestone cannot be set to 0.9.7 if the problem occurs in development branch.

comment:2 Changed 8 years ago by anonymous

  • Cc tdkim@… added

comment:3 Changed 8 years ago by jonas

  • Resolution set to fixed
  • Status changed from new to closed

Fixed in [3662]

Add Comment

Modify Ticket

Change Properties
<Author field>
as closed The owner will remain daniel.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from daniel to the specified user.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.