OperationalError: no such column: remaining_time

[jan]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'9b5b1a7618b66370aadf2ff4',
 'action': u'leave',
 'cnum': u'2',
 'comment': u'',
 'field_businessvalue': u'',
 'field_cc': u'',
 'field_component': u'component1',
 'field_description': u"must reassign each ticket to 'query' when making any change. system always reverts to 'defect' when updating or changing status.",
 'field_drp_resources': u'',
 'field_i_links': u'',
 'field_keywords': u'',
 'field_milestone': u'',
 'field_o_links': u'',
 'field_priority': u'should have',
 'field_rd_points': u'',
 'field_remaining_time': u'',
 'field_reporter': u'jan',
 'field_sprint': u'',
 'field_story_priority': u'',
 'field_summary': u"'type' reverts to defect upon any change to ticket",
 'field_type': u'bug',
 'field_version': u'',
 'id': u'36',
 'pane': u'edit',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2009-05-23 01:26:08+00:00'}

User Agent was: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.0.10) Gecko/2009042315 Firefox/3.0.10

System Information

Trac	0.11.4
Python	2.4.4 (#1, Apr 15 2008, 23:37:53) [GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)]
setuptools	0.6c9
SQLite	3.3.8
pysqlite	2.3.2
Genshi	0.5.1
Agilo	0.7.3.3-r1417-20090313
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/main.py", line 435, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-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.4-py2.4.egg/trac/ticket/web_ui.py", line 182, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/agilo-0.7.3.3_r1417_20090313-py2.4.egg/agilo/ticket/web_ui.py", line 202, in _process_ticket_request
    template, data, content_type = super(AgiloTicketModule, self)._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-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.4-py2.4.egg/trac/ticket/web_ui.py", line 1014, in _do_save
    cnum=internal_cnum):
  File "/usr/lib/python2.4/site-packages/agilo-0.7.3.3_r1417_20090313-py2.4.egg/agilo/ticket/model.py", line 645, in save_changes
    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/ticket/model.py", line 273, in save_changes
    (self[name], self.id))
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such column: remaining_time

[Remy Blank]

Duplicate of invalid #8315. Please search the ticket database to avoid posting duplicates.

(I don't know why I keep writing that, people don't even seem to care enough to set an e-mail address in the reporter field, so they will probably never even see this reply)