Edgewall Software
Modify

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:

Description

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 335, in dispatch_request
    dispatcher.dispatch(req)
  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>
Action
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.
Author


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

 
Note: See TracTickets for help on using tickets.