id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,branch,changelog,apichanges,internalchanges 9535,"DataError: (1264, ""Out of range value for column 'due' at row 1"")",jochenhebbrecht@…,,"==== How to Reproduce ==== While doing a POST operation on `/milestone/SPRINT 01`, Trac issued an internal error. ---- I was trying to define a ""due date"" for the milestone, but it seems impossible to store the date in the MySQL table. Any idea's? ---- Request parameters: {{{ {'__FORM_TOKEN': u'6530de88bc8792bfc7f89aed', 'action': u'edit', 'description': u'', 'duedate': u'1/1/2011', 'id': u'SPRINT 01', 'name': u'SPRINT 01'} }}} User agent: `Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.8) Gecko/20100723 Ubuntu/10.04 (lucid) Firefox/3.6.8` ==== System Information ==== || '''`Trac`''' || `0.12` || || '''`Genshi`''' || `0.6` || || '''`mod_wsgi`''' || `3.0 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})` || || '''`MySQL`''' || `server: ""5.1.31-community-log"", client: ""5.1.33"", thread-safe: 1` || || '''`MySQLdb`''' || `1.2.2` || || '''`Python`''' || `2.6.2 (r262:71605, Apr 14 2009, 22:40:02) [MSC v.1500 32 bit (Intel)]` || || '''`setuptools`''' || `0.6c11` || || '''`Subversion`''' || `1.6.6 (r40053)` || || '''`jQuery`''' || `1.4.2` || ==== Enabled Plugins ==== || '''`littlemary`''' || `1.0` || || '''`ticketimport`''' || `0.8` || || '''`timingandestimationplugin`''' || `1.0.5b` || || '''`tracaccountmanager`''' || `0.2.1dev-r7737` || || '''`tracburndown`''' || `1.9.2` || || '''`tracthemeengine`''' || `2.0.1` || ==== Python Traceback ==== {{{ Traceback (most recent call last): File ""C:\Program Files\Python26\lib\site-packages\trac\web\main.py"", line 513, in _dispatch_request dispatcher.dispatch(req) File ""C:\Program Files\Python26\lib\site-packages\trac\web\main.py"", line 235, in dispatch resp = chosen_handler.process_request(req) File ""C:\Program Files\Python26\lib\site-packages\trac\ticket\roadmap.py"", line 591, in process_request return self._do_save(req, db, milestone) File ""C:\Program Files\Python26\lib\site-packages\trac\ticket\roadmap.py"", line 673, in _do_save milestone.update() File ""C:\Program Files\Python26\lib\site-packages\trac\ticket\model.py"", line 1004, in update @self.env.with_transaction(db) File ""C:\Program Files\Python26\lib\site-packages\trac\db\api.py"", line 77, in transaction_wrapper fn(ldb) File ""C:\Program Files\Python26\lib\site-packages\trac\ticket\model.py"", line 1014, in do_update self.description, old_name)) File ""C:\Program Files\Python26\lib\site-packages\trac\db\util.py"", line 65, in execute return self.cursor.execute(sql_escape_percent(sql), args) File ""C:\Program Files\Python26\lib\site-packages\MySQLdb\cursors.py"", line 166, in execute self.errorhandler(self, exc, value) File ""C:\Program Files\Python26\lib\site-packages\MySQLdb\connections.py"", line 35, in defaulterrorhandler raise errorclass, errorvalue DataError: (1264, ""Out of range value for column 'due' at row 1"") }}}",defect,closed,normal,,database backend,0.12,normal,cantfix,,,,,,