#3476: Report error.
-------------------------------+--------------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: daniel
Type: defect | Status: new
Priority: normal | Milestone: 0.9.7
Component: report system | Version: devel
Severity: normal | Keywords: report,time
-------------------------------+--------------------------------------------
{{{
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.
--
Ticket URL: <http://trac.edgewall.org/ticket/3476>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
