use of datetime() function in report causes invalid literal for float() error

[doug@…]

While trying to create a report that would format dates in CSV for Excel I managed to create a report that crashes the writer and does not allow for editing or deltion.

---

Python Traceback Traceback (most recent call last):

File "/usr/local/python/lib/python2.4/site-packages/trac/web/main.py", line 393, in dispatch_request

dispatcher.dispatch(req)

File "/usr/local/python/lib/python2.4/site-packages/trac/web/main.py", line 243, in dispatch

resp = chosen_handler.process_request(req)

File "/usr/local/python/lib/python2.4/site-packages/trac/ticket/report.py", line 88, in process_request

resp = self._render_view(req, db, id)

File "/usr/local/python/lib/python2.4/site-packages/trac/ticket/report.py", line 346, in _render_view

valuedate = format_date(cell, tz=req.session.get_timezone())

File "/usr/local/python/lib/python2.4/site-packages/trac/util/datefmt.py", line 86, in format_date

return format_datetime(t, tz, format, gmt)

File "/usr/local/python/lib/python2.4/site-packages/trac/util/datefmt.py", line 76, in format_datetime

t = time.localtime(float(t))

ValueError: invalid literal for float(): 3217572-11-26 12:00:00

---

I'm quite sure it was the use of datetime() in the following query:

SELECT p.value AS color,

id AS ticket, summary, component, version, milestone, t.type AS type,

(CASE status WHEN 'assigned' THEN owner

' *' ELSE owner END) AS owner,

datetime(time) AS created, changetime AS _changetime, description AS _description, reporter AS _reporter

FROM ticket t LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE status IN ('new', 'assigned', 'reopened') ORDER BY p.value, milestone, t.type, time

The biggest problem is that this report now can no longer be edited or deleted.

[anonymous]

This is a dupe of #4510.