ValueError: year is out of range

[tracadmin]

How to Reproduce

While doing a GET operation on /report/6, Trac issued an internal error.

(please provide additional details here) Hi am getting above error only under for "All Tickets By Milestone (Including closed)" menu under Tickets. Please help me to fix this issue.

Request parameters:

{'id': u'6'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.22) Gecko/20110902 Firefox/3.6.22

System Information

Trac	0.11.7
Python	2.4.3 (#1, May 5 2011, 16:39:10) [GCC 4.1.2 20080704 (Red Hat 4.1.2-50)]
setuptools	0.6c12
MySQL	server: "5.1.56-community-log", client: "5.0.67", thread-safe: 1
MySQLdb	1.2.1
Genshi	0.6
mod_wsgi	3.2 (WSGIProcessGroup WSGIApplicationGroup 172.30.2.16|/projects)
Agilo	0.9.4
Subversion	1.6.11 (r934486)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 450, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 227, in dispatch
    data, content_type)
  File "/usr/lib/python2.4/site-packages/trac/web/chrome.py", line 774, in render_template
    stream.render(method, doctype=doctype, out=buffer)
  File "/usr/lib/python2.4/site-packages/genshi/core.py", line 183, in render
    return encode(generator, method=method, encoding=encoding, out=out)
  File "/usr/lib/python2.4/site-packages/genshi/output.py", line 58, in encode
    for chunk in iterator:
  File "/usr/lib/python2.4/site-packages/genshi/output.py", line 339, in __call__
    for kind, data, pos in stream:
  File "/usr/lib/python2.4/site-packages/genshi/output.py", line 826, in __call__
    for kind, data, pos in stream:
  File "/usr/lib/python2.4/site-packages/genshi/output.py", line 670, in __call__
    for kind, data, pos in stream:
  File "/usr/lib/python2.4/site-packages/genshi/output.py", line 771, in __call__
    for kind, data, pos in chain(stream, [(None, None, None)]):
  File "/usr/lib/python2.4/site-packages/genshi/output.py", line 586, in __call__
    for ev in stream:
  File "/usr/lib/python2.4/site-packages/genshi/core.py", line 288, in _ensure
    for event in stream:
  File "/usr/lib/python2.4/site-packages/genshi/core.py", line 288, in _ensure
    for event in stream:
  File "/usr/lib/python2.4/site-packages/trac/web/chrome.py", line 839, in _strip_accesskeys
    for kind, data, pos in stream:
  File "/usr/lib/python2.4/site-packages/genshi/core.py", line 288, in _ensure
    for event in stream:
  File "/usr/lib/python2.4/site-packages/trac/web/chrome.py", line 828, in _generate
    for kind, data, pos in stream:
  File "/usr/lib/python2.4/site-packages/genshi/core.py", line 288, in _ensure
    for event in stream:
  File "/usr/lib/python2.4/site-packages/genshi/template/base.py", line 605, in _include
    for event in stream:
  File "/usr/lib/python2.4/site-packages/genshi/template/markup.py", line 378, in _match
    ctxt, start=idx + 1, **vars):
  File "/usr/lib/python2.4/site-packages/genshi/template/markup.py", line 378, in _match
    ctxt, start=idx + 1, **vars):
  File "/usr/lib/python2.4/site-packages/genshi/template/markup.py", line 327, in _match
    for event in stream:
  File "/usr/lib/python2.4/site-packages/genshi/template/base.py", line 545, in _flatten
    for kind, data, pos in stream:
  File "/usr/lib/python2.4/site-packages/genshi/core.py", line 288, in _ensure
    for event in stream:
  File "/usr/lib/python2.4/site-packages/genshi/path.py", line 588, in _generate
    subevent = next()
  File "/usr/lib/python2.4/site-packages/genshi/template/base.py", line 605, in _include
    for event in stream:
  File "/usr/lib/python2.4/site-packages/genshi/template/markup.py", line 327, in _match
    for event in stream:
  File "/usr/lib/python2.4/site-packages/genshi/template/markup.py", line 316, in _strip
    event = next()
  File "/usr/lib/python2.4/site-packages/genshi/template/base.py", line 545, in _flatten
    for kind, data, pos in stream:
  File "/usr/lib/python2.4/site-packages/genshi/core.py", line 288, in _ensure
    for event in stream:
  File "/usr/lib/python2.4/site-packages/genshi/path.py", line 588, in _generate
    subevent = next()
  File "/usr/lib/python2.4/site-packages/genshi/template/base.py", line 605, in _include
    for event in stream:
  File "/usr/lib/python2.4/site-packages/genshi/template/markup.py", line 316, in _strip
    event = next()
  File "/usr/lib/python2.4/site-packages/genshi/template/base.py", line 565, in _flatten
    result = _eval_expr(data, ctxt, vars)
  File "/usr/lib/python2.4/site-packages/genshi/template/base.py", line 277, in _eval_expr
    retval = expr.evaluate(ctxt)
  File "/usr/lib/python2.4/site-packages/genshi/template/eval.py", line 178, in evaluate
    return eval(self.code, _globals, {'__data__': data})
  File "/usr/lib/python2.4/site-packages/trac/ticket/templates/report_view.html", line 120, in <Expression u"cell.value != '' and format_date(int(cell.value)) or '--'">
    <td class="date" py:attrs="td_attrs">${cell.value != '' and format_date(int(cell.value)) or '--'}
  File "/usr/lib/python2.4/site-packages/trac/util/compat.py", line 135, in newfunc
    return func_(*(args + fargs), **dict(kwargs, **fkwargs))
  File "/usr/lib/python2.4/site-packages/trac/util/datefmt.py", line 144, in format_date
    return format_datetime(t, format, tzinfo=tzinfo)
  File "/usr/lib/python2.4/site-packages/trac/util/datefmt.py", line 108, in format_datetime
    t = to_datetime(t, tzinfo).astimezone(tz)
  File "/usr/lib/python2.4/site-packages/trac/util/datefmt.py", line 51, in to_datetime
    return datetime.fromtimestamp(t, tzinfo or localtz)
ValueError: year is out of range

[Remy Blank]

This is an InstallationIssue (or rather a LocalIssue), and not a bug in Trac. Check your ticket table for invalid values in the date columns (time and changetime).