OperationalError: no such column: blockedby

[krogers@…]

How to Reproduce

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

We updated trac to Agilo trac and having some issues with normal ticket flow. I tried to add a comment to this ticket and received an error about a missing time column. Then I tried to edit and close the ticket and received another similar error. It looks like these are related to add ons that were setup for the original track and not working correctly after the transfer. )

Request parameters:

{'__FORM_TOKEN': u'd542f60e1936082383aff39f',
 'action': u'resolve',
 'action_resolve_resolve_resolution': u'fixed',
 'cnum': u'1',
 'comment': u'It was not clear which server he should have remote desktop access to, so I set it up on both and sent him a notification email with the password. ',
 'field_description': u"=== General description ===\r\n\r\nJoel is working on the implementation of the SPLUNK API, and as Metro SPLUNK instance is only accessible via Web1 or Web2, I'd like to ask to have him a remote desktop privilege granted to Web2. He doesn't need to be an administrator, just remote desktop user at this stage.\r\n",
 'field_drp_resources': u'',
 'field_remaining_time': u'',
 'field_reporter': u'mgimelfarb@privacystar.com',
 'field_sprint': u'',
 'field_summary': u'Grant Joel Doyle access to Web1',
 'field_type': u'Task',
 'id': u'374',
 'pane': u'edit',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2012-03-15 20:48:38+00:00'}

User Agent was: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.79 Safari/535.11

System Information

Trac	0.11.7
Python	2.5.4 (r254:67916, Dec 3 2009, 14:36:49) [GCC 4.1.2 20080704 (Red Hat 4.1.2-46)]
setuptools	0.6c11
SQLite	3.3.6
pysqlite	2.5.6
Genshi	0.6
mod_wsgi	3.1 (WSGIProcessGroup tracdaemon WSGIApplicationGroup %{GLOBAL})
Pygments	1.1.1
Agilo	py2.5
CustomFieldAdmin	0.2.2
Subversion	1.7.2 (r1207936)
RPC	1.0.6
Docutils	0.8.1
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/web/main.py", line 450, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/web/main.py", line 206, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/ticket/web_ui.py", line 182, in process_request
    return self._process_ticket_request(req)
  File "build/bdist.linux-x86_64/egg/agilo/ticket/web_ui.py", line 225, in _process_ticket_request
    template, data, content_type = super(AgiloTicketModule, self)._process_ticket_request(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/ticket/web_ui.py", line 513, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/ticket/web_ui.py", line 1034, in _do_save
    cnum=internal_cnum):
  File "build/bdist.linux-x86_64/egg/agilo/ticket/model.py", line 759, in save_changes
    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/ticket/model.py", line 277, in save_changes
    (self[name], self.id))
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/db/util.py", line 64, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/db/sqlite_backend.py", line 80, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/db/sqlite_backend.py", line 59, in execute
    args or [])
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.7-py2.5.egg/trac/db/sqlite_backend.py", line 51, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such column: blockedby

[Remy Blank]

PluginIssue (AgiloForScrum).

[stefano.rago@…]

@rblank: thanks for the cc @krogers: please try disabling all the third party plugins other than Agilo. If you still have problems, please write to support@…