DatabaseError: no such column: remaining_time

[igorl]

How to Reproduce

While doing a POST operation on /ticket/907, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'b8d872057100423ec565886f',
 'action': u'leave',
 'cnum': u'3',
 'comment': u'',
 'field_businessvalue': u'',
 'field_cc': u'',
 'field_complete_date': u'',
 'field_component': u'SP collector',
 'field_description': u'release.  database.  behavior.\r\n\r\nThediscarded.\r\n\r\nBoth\r\n\r\n ',
 'field_drp_resources': u'',
 'field_duration': u'',
 'field_i_links': u'',
 'field_keywords': u'',
 'field_milestone': u'Release 4.2',
 'field_o_links': u'',
 'field_priority': u'highest',
 'field_rd_points': u'',
 'field_remaining_time': u'',
 'field_reporter': u'a',
 'field_requesting_customer': u'',
 'field_severity': u'major',
 'field_sprint': u'Release 4.2 Default Sprint',
 'field_start_date': u'',
 'field_story_priority': u'',
 'field_summary': u'Not receiving',
 'field_svn_build_number': u'',
 'field_type': u'bug',
 'field_version': u'4.1',
 'id': u'907',
 'pane': u'edit',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2009-11-17 17:54:36+00:00'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.3 (KHTML, like Gecko) Chrome/4.0.223.16 Safari/532.3

System Information

Trac	0.11.5
Python	2.4.3 (#1, May 24 2008, 13:47:28) [GCC 4.1.2 20070626 (Red Hat 4.1.2-14)]
setuptools	0.6c9
SQLite	3.3.6
pysqlite	1.1.7
Genshi	0.5.1
mod_python	3.2.8
Pygments	1.0
Agilo	1.1.0-PRO
Mercurial	1.3.1
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/web/main.py", line 444, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/web/main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/ticket/web_ui.py", line 182, in process_request
    return self._process_ticket_request(req)
  File "/abn/trac/abn/plugins/binary_agilo-1.1.0_PRO-py2.4.egg/agilo/ticket/web_ui.py", line 200, in _process_ticket_request
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/ticket/web_ui.py", line 508, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/ticket/web_ui.py", line 1014, in _do_save
    cnum=internal_cnum):
  File "/abn/trac/abn/plugins/binary_agilo-1.1.0_PRO-py2.4.egg/agilo/ticket/model.py", line 756, in save_changes
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/ticket/model.py", line 274, in save_changes
    (self[name], self.id))
  File "/usr/lib/python2.4/site-packages/Trac-0.11.5-py2.4.egg/trac/db/util.py", line 59, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 255, in execute
    self.rs = self.con.db.execute(SQL % parms)
DatabaseError: no such column: remaining_time

[Remy Blank]

PluginIssue (Agilo).

[Martin Häcker <martin.haecker@…>]

Thanks for the heads-up rblank.

igori: Please take a look at AgiloForScrum for how to get help on Agilo, from the first look I would guess that this might be a recent bug we have seen very rarely.

Can you reproduce this issue? If so, please come to our user group to help track this down.