ValueError: timestamp out of range for platform time_t

[didley@…]

I did enter the date 31.12.2100 in the due date field of Milestone. After that I can't go to the admin menu Milestone and I can't add new tickets. How can I remove this date?

Python Traceback
Most recent call last:

    * File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\ticket\model.py", line 684, in select
      Code fragment:
       679. cursor.execute(sql)
       680. milestones = []
       681. for name,due,completed,description in cursor:
       682. milestone = Milestone(env)
       683. milestone.name = milestone._old_name = name
       684. milestone.due = due and datetime.fromtimestamp(int(due), utc) or None
       685. if completed:
       686. milestone.completed = datetime.fromtimestamp(int(completed), utc)
       687. else:
       688. milestone.completed = None
       689. milestone.description = description or ''
      Local variables:
      Name	Value
      cls 	<class 'trac.ticket.model.Milestone'>
      completed 	0
      cursor 	<trac.db.util.IterableCursor object at 0x01BA0EF0>
      db 	<trac.db.pool.PooledConnection object at 0x01A3A670>
      description 	u''
      due 	4133890800L
      env 	<trac.env.Environment object at 0x00EEF590>
      include_completed 	True
      milestone 	<trac.ticket.model.Milestone object at 0x019D18D0>
      milestones 	[<trac.ticket.model.Milestone object at 0x01BA0FF0>, ...
      name 	u'Waste'
      sql 	'SELECT name,due,completed,description FROM milestone '

File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\web\main.py", line 431, in dispatch_request
  dispatcher.dispatch(req)
File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\web\main.py", line 217, in dispatch
  resp = chosen_handler.process_request(req)
File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\admin\web_ui.py", line 96, in process_request
  path_info)
File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\ticket\admin.py", line 41, in render_admin_panel
  return self._render_admin_panel(req, cat, page, version)
File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\ticket\admin.py", line 192, in _render_admin_panel
  'milestones': model.Milestone.select(self.env),
File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\ticket\model.py", line 684, in select
  milestone.due = due and datetime.fromtimestamp(int(due), utc) or None

Trac:  	0.11dev-r5555
Python: 	2.5 (r25:51908, Sep 19 2006, 09:52:17) [MSC v.1310 32 bit (Intel)]
setuptools: 	0.6c5
SQLite: 	3.3.4
pysqlite: 	2.3.2
Genshi: 	0.4.1
Subversion: 	1.4.3 (r23084)
jQuery:	1.1.2

[didley@…]

sorry for this bad pasting. Once again.

Python Traceback Most recent call last:

File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\web\main.py", line 431, in dispatch_request

dispatcher.dispatch(req)

File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\web\main.py", line 217, in dispatch

resp = chosen_handler.process_request(req)

File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\admin\web_ui.py", line 96, in process_request

path_info)

File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\ticket\admin.py", line 41, in render_admin_panel

return self._render_admin_panel(req, cat, page, version)

File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\ticket\admin.py", line 192, in _render_admin_panel

'milestones': model.Milestone.select(self.env),

File "c:\python25\lib\site-packages\Trac-0.11dev_r5555-py2.5.egg\trac\ticket\model.py", line 684, in select

milestone.due = due and datetime.fromtimestamp(int(due), utc) or None

System Information

Trac: 0.11dev-r5555 Python: 2.5 (r25:51908, Sep 19 2006, 09:52:17) [MSC v.1310 32 bit (Intel)] setuptools: 0.6c5 SQLite: 3.3.4 pysqlite: 2.3.2 Genshi: 0.4.1 Subversion: 1.4.3 (r23084) jQuery: 1.1.2

[Christian Boos]

For a quick fix, use the sqlite3 command line, and reset that due date to empty manually.

e.g.

sqlite3 db/trac.db "update milestone set due = '' where name = 'Waste'"

[Christian Boos]

Duplicate of #5322